mysql 离线安装后用户初始化

 

systemctl ebable mysqld

 

systemctl start mysqld

 

查看/var/log/mysqldlog,找到临时的密码

cat /var/log/mysqld.log

2020-04-13T07:40:51.250462Z 1 [Note] A temporary password is generated for root@localhost: Hrc?(h8B17XH

登录修改密码

mysql -u root -p

密码:  Hrc?(h8B17XH

ALTER USER 'root'@'localhost' IDENTIFIED BY '@YGVbgd23';

GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY '@YGVbgd23';

或者登录后创建新用户

CREATE USER 'root'@'%' IDENTIFIED BY '@YGVbgd23';
flush privileges;

 

posted on 2020-04-13 15:57  cococooder  阅读(242)  评论(0)    收藏  举报