MySQL出現(xiàn)Accessdeniedforuser'root&amp_MySQL
來源:懂視網(wǎng)
責(zé)編:小采
時(shí)間:2020-11-09 20:04:10
MySQL出現(xiàn)Accessdeniedforuser'root&_MySQL
MySQL出現(xiàn)Accessdeniedforuser'root&_MySQL:bitsCN.com 登錄某臺(tái)服務(wù)器的mysql時(shí)候總報(bào)錯(cuò):mysql2/client.rb:58:in `connect': Access denied for user 'root'@'localhost' (using password: YES) (Mysql2::Error) 解決方法: 在windows 下的解決方法也一樣的
導(dǎo)讀MySQL出現(xiàn)Accessdeniedforuser'root&_MySQL:bitsCN.com 登錄某臺(tái)服務(wù)器的mysql時(shí)候總報(bào)錯(cuò):mysql2/client.rb:58:in `connect': Access denied for user 'root'@'localhost' (using password: YES) (Mysql2::Error) 解決方法: 在windows 下的解決方法也一樣的
bitsCN.com
登錄某臺(tái)服務(wù)器的mysql時(shí)候總報(bào)錯(cuò):
mysql2/client.rb:58:in `connect': Access denied for user 'root'@'localhost' (using password: YES) (Mysql2::Error)
解決方法:
在windows 下的解決方法也一樣的
[sql] view plain copy
- # /etc/init.d/mysqld stop
- # mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
- # mysql -u root mysql
- mysql> UPDATE user SET Password= PASSWORD(’newpassword’) where USER=’root’;
- mysql> FLUSH PRIVILEGES;
- mysql> quit
- # /etc/init.d/mysqld restart
- # mysql -uroot -p
- Enter password: <輸入新設(shè)的密碼newpassword>
- mysql>
bitsCN.com
聲明:本網(wǎng)頁內(nèi)容旨在傳播知識(shí),若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系,我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
MySQL出現(xiàn)Accessdeniedforuser&#x27;root&_MySQL
MySQL出現(xiàn)Accessdeniedforuser'root&_MySQL:bitsCN.com 登錄某臺(tái)服務(wù)器的mysql時(shí)候總報(bào)錯(cuò):mysql2/client.rb:58:in `connect': Access denied for user 'root'@'localhost' (using password: YES) (Mysql2::Error) 解決方法: 在windows 下的解決方法也一樣的