## 新增用戶和重置密碼 及 授權 [TOC] ****** >[info] #### 新增用戶及授權 ~~~ mysql>select host,user,password from mysql.user; mysql>grant all on *.* to 用戶名@"%" identified by "您的密碼" mysql>flush privileges; 附：如果只授權某一數據庫操作： mysql>grant all on `庫名`.* to 用戶名@"%" identified by "您的密碼" ~~~ >[info] #### 修改密碼 ~~~ mysql>use msyql; mysql>update user set password = password("密碼") where user = "帳號"; mysql>flush privileges; ~~~ >[info] #### 刪除用戶 ~~~ mysql>delete from mysql.user where user ='您的用戶名' ; mysql>flush privileges; (刷新系統權限表) ~~~ >[warning] #### 重置忘記的密碼 * 應用于Linux ~~~ #vim /etc/my.cnf //在[mysqld]的段中加上一句：skip-grant-tables 例如： [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-grant-tables 重新啟動mysqld # /etc/init.d/mysqld restart # mysql -u root -p 回車進入 mysql>update user set password = password("密碼") where user = "帳號"; mysql>flush privileges; ~~~