創(chuàng)建本地登陸的用戶test

CREATE USER test@localhost IDENTIFIED BY 'passwd';

修改用戶密碼

ALTER USER test@localhost IDENTIFIED WITH mysql_native_password BY 'new_passwd';

允許本地用戶test全權(quán)操作數(shù)據(jù)庫laravel

GRANT ALL PRIVILEGES ON laravel.* TO test@localhost;
flush privileges;

修改當(dāng)前登錄用戶密碼

mysql>SET PASSWORD = PASSWORD('new passwd');

修改用戶test的密碼

mysql>SET PASSWORD FOR 'test'@'localhost' = PASSWORD('newpasswd');

刪除用戶test

mysql>DROP USER 'test'@'localhost';