mysql数据库用户密码管理

创建用户:create user 'oracle'@'localhost' identified by 'password';

MySQL 8以上:alter user 'root'@'localhost' identified with mysql_native_password by 'newpassword';

MySQL 8以下版本: 1.set password for 'root'@'localhost' password('newpassword');

           2.update user set password="newpassword" where user="root";

                               3.mysqladmin -uroot -ppassword password newpassword;

posted @ 2019-03-08 16:15  localtion  阅读(807)  评论(0编辑  收藏  举报