数据库MySQL配置命令详解

hebao0

已于 2022-06-09 10:13:33 修改

阅读量384

点赞数

文章标签： linux 运维服务器

于 2022-04-24 08:17:22 首次发布

本文链接：https://blog.csdn.net/weixin_46338291/article/details/124374400

版权

命令行打开数据库

create user ‘hag’@‘%’ identified by ‘HagSoft@123’;//创建一个可远程登陆账户
ALTER USER root@localhost IDENTIFIED BY ‘HagSoft@123’;//更改本地root用户登录密码
alter user’hag’@‘%’ IDENTIFIED BY ‘HagSoft@123’;//更改账户密码
grant all privileges on . to ‘hag’@‘%’ with grant option;//允许任何ip通过hag账户进行远程连接
grant all privileges on . to ‘hag’@‘localhost’ with grant option;//赋予hag本地账户任何权限
flush privileges;//MySQL用户数据和权限有修改后，希望在”不重启MySQL服务”的情况下直接生效

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘HagSoft@123’ PASSWORD EXPIRE NEVER;//设置密码永不过期
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘HagSoft@123’;//设置密码加密模式为mysql_native_password
FLUSH PRIVILEGES;