V. Basic configuration of MySQL database

MySQL Database basic configuration

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm# RPM-IVH mysql-community-release-el7-5.noarch.rpm

# yum Install Mysql-community-server
Restart MySQL after installation is complete, Systemctl Restarat mysqld.service
Initial Entry Install root user does not have password:
[Email protected] linuxidc]# mysql-u root

A. #设置msyql密码为 123456:

mysql> set password for ' root ' @ ' localhost ' =password (' 123456 '); #远程连接设置;

B. All remote users connected to the root account with a password of 123456:

Mysql> Grant all privileges on * * to [e-mail protected] '% ' identified by ' 123456 ';

C. #更新权限mysql >flush privileges;

This article is from the IT Technology blog blog, so be sure to keep this source http://weonline.blog.51cto.com/1467072/1878433

V. Basic configuration of MySQL database