[TOC] ## 1. 修改root密碼（關閉安全模式） 1. 停止正在運行的MySQL進程 【Linux】運行 killall -TERM mysqld 2. 以安全模式啟動MySQL ~~~ 【Linux】運行 /usr/local/mysql/bin/mysqld_safe --skip-grant-tables & 【Windows】在命令行下運行 X:/MySQL/bin/mysqld-nt.exe --skip-grant-tables ~~~ 3. 完成以后就可以不用密碼進入MySQL了 ~~~ 【Linux】運行 /usr/local/mysql/bin/mysql -u root -p 進入 【Windows】運行 X:/MySQL/bin/mysql -u root -p 進入 ~~~ 4. 更改密碼 ~~~ >use mysql >update user set password=password("新密碼") where user="root"; >flush privileges; ~~~ ## 2. 允許用戶遠程訪問 ~~~ mysql>grant all privileges on *.* to root@'%' identified by 'tuna'; mysql>flush privileges; ~~~ ## 3. 查看當前使用的配置文件 ~~~ /usr/bin/mysql --verbose --help | grep -A 1 'Default options' ~~~ ## 4. 查看用戶權限 ~~~ mysql> show grants for 'systop'@'%'; ERROR 1141 (42000): There is no such grant defined for user 'systop' on host '%' mysql> show grants for 'systop'@'192.168.56.%'; +-----------------------------------------------------------+ | Grants for systop@192.168.56.% | +-----------------------------------------------------------+ | GRANT REPLICATION SLAVE ON *.* TO 'systop'@'192.168.56.%' | +-----------------------------------------------------------+ 1 row in set (0.00 sec) ~~~