Linux installation MySQL and MySQL remote access configuration

First, check whether the system has its own MySQL database

Rpm-qa | grep mysql//This command will check if the MySQL database is already installed on the operating system

Second, the existing database to uninstall

RPM-E MySQL//normal Delete mode

RPM-E--nodeps MySQL//brute force Delete mode, if you use the above command to delete, prompted to have other dependent files, then use this command can be strongly deleted

Third, the installation of MySQL with the yum command

Yum List | grep MySQL//view version information for downloaded MySQL on Yum

Yum install-y mysql-server mysql mysql-deve//Database installation

Rpm-qi Mysql-server//View version information for a database

Service Mysald start//Start database

Chkconfig--list | grep mysqld//Check to see if the database is booting

Chkconfig mysqld on//Set database on boot

mysqladmin-u root password ' password '//set root user password to password

Mysql-u root-p//Login database, enter password

Iv. Database Remote Access configuration

Log in to the database first

Mysql-u root-p//Login database, enter password

use MySQL;//select MySQL Database

Update user set host= '% ' where user= ' root '; If error 1062 (23000): Duplicate entry '%-root ' for key ' PRIMARY ' disregarded

Flush privileges; Save changes

Linux installation MySQL and MySQL remote access configuration