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: <pre class="brush:php;toolbar:false">/usr/my.cnf</pre>
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!