How to install MySQL using rpm

How to install MySQL using rpm: First download the rpm package and start installing the server; then install [mysql-client], the code is [rpm -ivh MySQL-client-5.6.20-1.el6. i686.rpm].

The operating environment of this tutorial: Windows 7 system, mysql version 8.0.22. This method is suitable for all brands of computers.

Related free learning recommendations: mysql video tutorial

How to install MySQL using rpm:

1. First, you need to download the rpm package:

You can choose to download according to different versions. What I downloaded is:

MySQL-server-5.6.20-1.el6.i686.rpm

MySQL-client-5.6.20-1.el6.i686.rpm

MySQL-devel-5.6.20 -1.el6.i686.rpm (this package is for backup)

Because if you install mysql in rpm mode, you will not be able to connect to mysql in command line mode only by installing mysql-server. You also need to install mysql-client

2. Start installing the server side:

Execute the command:

rpm -ivh MySQL-server-5.6.20-1.el6.i686.rpm

After the installation is completed, there will be a prompt:

Tip 1: After installing mysql-server, a password for the root account will be randomly generated and saved in: /root/.mysql_secret Here

Tip 2: After installing mysql-server for the first time When connecting to mysql, you need to change the default password

After confirming this, you need to execute the command: find / -name mysql to find the installation location of mysql-server, as follows:

/etc/logrotate.d/mysql                                                                                                                                --- - Contains the my-default.cnf file

/usr/bin/mysql

/usr/lib/mysql

/var/lib/mysql                                                                                                                                                                                                                                 Database file Storage directory

Then execute:

find / -name my.cnf

Find the location of the mysql-server configuration file, as follows: <div class="code" style="position:relative; padding:0px; margin:0px;"><pre class="brush:php;toolbar:false">/usr/my.cnf</pre><div class="contentsignin">Copy after login</div></div> Then start mysql-server and execute:

/etc/init.d/mysql  start

After prompting that the startup is successful, execute:

ps -el | grep mysql

The system will list the related process information of mysqld, indicating that the mysql-server installation is successful!

3. Install mysql-client:

Since there is no way to connect to the database under the command line after installing mysql-server, you need to continue to install mysql-client and execute Command:

rpm -ivh MySQL-client-5.6.20-1.el6.i686.rpm

After a while, the system will prompt that the installation is successful. At this time, execute:

mysql -u root -p to connect to mysql. You need to enter a password when connecting. The password is the same as before. The generated random password can be entered successfully!

After entering the mysql console, execute:

show databases;

I found that the system prompts that I need to change the password first, so: exit the system first, and then execute: mysqladmin -u root -p password 'new-passwd '

to change the password, then connect to mysql again, enter the password you just set, and then continue to execute the show databases; command and find success!

4. Then there is a question. Do I still need to install the mysql-devel package?

try it. Execution:

rpm -ivh MySQL-devel-5.6.20-1.el6.i686.rpm

It prompts that the installation is successful, then connect to mysql and execute show databases; it still works. . . !

The above is the detailed content of How to install MySQL using rpm. For more information, please follow other related articles on the PHP Chinese website!