How to install and configure mysql 5.7.19 under centos6.5

The detailed steps for installing mysql5.7.19 on centos6.5 are as follows

1. Download mysql5.7.19 from the oracle website
2. Add centos user group and user MySQL

groupadd mysql
useradd mysql -g mysql

3. Unzip the files to be installed to the specified directory.

You need to set the chown 755 directory to allow mysql to access it.

4. Find bin in the unzipped mysql directory, where there is the mysqld executable file. implement

./mysqld --user=mysql --basedir=/home/mysql/mysql-5.7.16-linux-glibc2.5-x86_64 --datadir=/home/mysql/data --initialize

5. Copy my-defalut.cnf in the support-files directory under the installation directory to /etc/my.cnf

6. Copy mysql.service in the support-files directory under the installation directory to /etc/init.d/mysqld

7. Set up the mysql connection and connect the mysql in the bin directory under the installation directory to /usr/local/bin
ln -fs /home/mysql/mysql-5.7.16-linux-glibc2.5-x86_64/bin/mysql /usr/local/bin/mysql

8. Modify /etc/my.cnf

set up
basedir=/home/mysql
datadir=/home/mysql/data
user=mysql

9. service mysql start starts mysql

10. mysql -uroot connects to mysql and prompts root@localhost login is not allowed , you need to set a password

Shut down mysql first

Modify /etc/my.cnf

Add skip-grant-tables to mysqld

Enable mysql

Enter

mysql>UPDATE mysql.user SET authentication_string=password('123456') WHERE User='root' AND Host='localhost';

Just change the root password.

Or enter mysql> set password=password('123456');

11. Set the character type of the database

Edit /etc/my.cnf
Add in mysqld
character-set-server=utf8
Add in client
default-character-set=utf8

12. Check the character type of the database

mysql>show variables like "%character%";

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.