Installation and configuration of MySQL under Centos 7

Put the MySQL installation files into the virtual machine, the FTP software upload up

Configure Yum to install MySQL with Yum

To reset MySQL: mysql_install_db--datadir=/var/lib/mysql

Enter/var/lib/mysql Modify Permissions

Chown Mysql:mysql *-R

Enter the root directory to see the password recorded in the. Mysql_secret: Cat. Mysql_secret

Log into the database with the above password mysql-u root-p

Change password alter user ' root ' @ ' localhost ' identified by ' ******* '

Create user Word

Plus permission to use

Installation and configuration of MySQL under Centos 7