#change root passwd
use mysql;
update user set password=password('rootpasswd') where user='root';
flush privileges;
#add user
use mysql;
GRANT ALL PRIVILEGES ON *.* TO newuser@localhost IDENTIFIED BY 'newuserpasswd' WITH GRANT OPTION;
#user name 'newuser',password 'newuserpasswd',can login from localhost with
# full privileges.
flush privileges;
#refresh privileges to make your modifies valid,or you should have to restart
#your mysql server.
#any questions, please read mysql-doc.
#good luck.
# kurt Xiang. xqterry@yeah.net
mysql user management tips
本文介绍如何在 MySQL 中更改 root 用户的密码以及如何添加新的用户并赋予其所有权限。通过 SQL 命令实现用户管理,确保数据库的安全性和访问控制。

被折叠的 条评论
为什么被折叠?



