linux 安装 mysql

1.安装mysql

yum install mysql-server -y

2.启动mysql服务
service mysqld start

开机启动
chkconfig mysqld on

通过mysql命令进入命令行接口  修改登录权限信息

进入 mysql

mysql

use mysql

select host, user, password from user;

3.mysql设置密码

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

4.delete from user where host != '%';

select host, user, password from user;

5.flush privileges;

shang