Linux MySQL installation, remote access, and password reset

Installation:

Yum install MySQL

Yum Install Mysql-server

Yum Install Mysql-devel

Set boot up:

Chkconfig-add mysqld

See if boot boot settings are successful chkconfig--list | grep mysql*, the result should be as follows:

Mysqld 0: Off 1: Off 2: Enable 3: Enable 4: Enable 5: Enable 6: Off

To create a root administrator:

Mysqladmin-u Root Password 123456

Reset Password:

Service Mysqld Stop

Mysqld_safe--skip-grant-tables &

Note that the final & symbol must not be less

Mysql-u Root

Use MySQL;

Update user set Password=password ("New_pass") where user= "root";

Flush privileges;

Quit

MySQL Related directories:

Database directory

/var/lib/mysql/

Configuration file

/usr/share/mysql (mysql.server command and configuration file)

Related commands

/usr/bin (Mysqladmin mysqldump and other commands)

Startup scripts

/etc/rc.d/init.d/(startup script file for MySQL directory)

Linux MySQL installation, remote access, and password reset