집 >데이터 베이스 >MySQL 튜토리얼 >mysql常用的小技巧_MySQL
bitsCN.com
mysql常用的小技巧 1.输入原密码。接着设置新密码 代码:mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword'); 2.若你想新建一个具有所有权限的新用户 代码:GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; bitsCN.com