Step-by-Step Guide to Install MySQL 5.7 on CentOS 6

Author: 云上之山 Source: http://blog.csdn.net/nengyu/article/details/51615836

1. Download MySQL 5.7.13

Obtain the tar.gz package from the official MySQL download page.

2. Create MySQL user and group, and data directory

# groupadd mysql
# useradd -g mysql -d /opt/my/mysql mysql
# mkdir /opt/my/mysql/data

3. Extract the package

# tar -xzvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz
# mv mysql-5.7.9-linux-glibc2.5-x86_64 mysql

4. Initialize the database

MySQL 5.7 deprecates mysql_install_db; use mysqld --initialize instead.

# ./bin/mysqld --user=mysql --basedir=/opt/my/mysql --datadir=/opt/my/mysql/data --initialize

If the data directory already contains files, the command will fail; remove the contents and re‑run.

# cd /opt/my/mysql/data
# rm -fr *

5. Start the MySQL service

# cd /home/mysql
# ./support-files/mysql.server start
Starting MySQL.. SUCCESS!

If the service fails, edit /support-files/mysql.server to set the correct basedir and datadir paths.

6. Create a symbolic link

# ln -s /opt/my/mysql/bin/mysql /usr/bin/mysql

7. Configure my.cnf

# mv /etc/my.cnf /etc/my.cnf.bak
# cp my-default.cnf /etc/my.cnf
# vim /etc/my.cnf

[mysqld]
basedir = /opt/my/mysql
datadir = /home/mysql/data
character_set_server=utf8
init_connect='SET NAMES utf8'

[client]
default-character-set=utf8

8. Enable automatic start on boot

# cp /opt/my/mysql/support-files/mysql.server /etc/init.d/mysqld
# chmod 755 /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 345 mysqld on

9. Manage the MySQL service

# service mysqld start
# service mysqld restart
# service mysqld stop

10. Set the root password

Stop the service, then initialize again to obtain the temporary password, and change it with mysqladmin or SQL statements.

# service mysqld stop
# ./bin/mysqld --initialize   # generates temporary password
# mysqladmin -u root -p'temporary' password 'new_password'

11. Grant remote access

Example grant statement:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'new_password' WITH GRANT OPTION;
FLUSH PRIVILEGES;

After completing these steps, MySQL 5.7 is installed, configured, and ready for use on CentOS 6.