MySQL installation uses

Install MySQL Online
1°, view MySQL dependencies
Rpm-qa | grep MySQL
2°, delete MySQL dependency
Rpm-e--nodeps ' Rpm-qa | grep MySQL '
3°, yum install MySQL
Yum-y Install Mysql-server
4°, start MySQL service
Service mysqld Start
5°, join to boot startup item
Chkconfig mysqld on
6°, initialize configuration MySQL service
Whereis mysql_secure_installation
Execute Script/usr/bin/mysql_secure_installation
7°, Access MySQL service
Mysql-h Node0-uroot-proot
Problem: Host ' node0 ' isn't allowed to connect to this MySQL server
Workaround:
Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ';
Mysql>grant all privileges on * * to ' root ' @ ' localhost ' identified by ' 123456 ' with GRANT option;
mysql> flush Privileges;

Install MySQL offline
1°, view MySQL dependencies
Rpm-qa | grep MySQL
2°, delete MySQL dependency
Rpm-e--nodeps ' Rpm-qa | grep MySQL ' or
Rpm-e--nodeps ' Rpm-qa | grep MySQL '
3°, offline install MySQL
RPM-IVH mysql-server-5.1.73-1.glibc23.x86_64.rpm
RPM-IVH mysql-client-5.1.73-1.glibc23.x86_64.rpm
4°, start MySQL service
Service MySQL Start
5°, join to boot startup item
Chkconfig MySQL on
6°, initialize configuration MySQL service
Whereis mysql_secure_installation
Execute Script/usr/bin/mysql_secure_installation
7°, Access MySQL service
Mysql-h Node0-uroot-proot
Problem: Host ' node0 ' isn't allowed to connect to this MySQL server
Workaround:
Mysql> Grant all privileges on * * to ' root ' @ '% ' identified by ' 123456 ';
mysql> flush Privileges;

MySQL installation uses