mysql开局配置

2019独角兽企业重金招聘Python工程师标准>>>

1.安装

//查看是否安装

rpm -qa|grep -i mysql

//安装mysql

rpm -ivh --force  server*******.rpm

rpm -ivh --force  client*******.rpm

//查看是否安装成功

rpm -qa|grep -i mysql （出现server*与client*及lib说明安装成功）

2.初始化root密码

//使用default配置文件

mv /etc/my.cnf /etc/my.cnf.bak

//停止没有散去了服务

service mysql stop

//使用安全模式启动mysql

mysqld_safe --skip-grant-tables&

//配置mysql默认密码为空

UPDATE user SET password=PASSWORD("") WHERE user='root';

FLUSH PRIVILEGES;

正常重启mysql   service mysql restart

SET password=PASSWORD('');
FLUSH PRIVILEGES;

3.添加数据库用户

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT  ALL ON *.* to username@'localhost' IDENTIFIED BY 'passwoerd';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;

 

转载于:https://my.oschina.net/mylife993/blog/1635501