mysql登入錯誤或者密碼錯誤

標籤：

一、mysql登入錯誤mysqladmin: connect to server at ‘localhost‘ failed       error: ‘Access denied for user ‘root‘@‘localhost‘ (using password: YES)‘解決辦法：破解mysql密碼#> service mysqld stop       #>mysqld_safe --skip-grant-tables &       輸入 mysql -uroot -p 斷行符號進入       >use mysql;       > update user set password=PASSWORD("newpass")where user="root";       更改密碼為 newpassord       > flush privileges; 更新許可權       > quit 退出service mysqld restart       mysql -uroot -p新密碼進入  二，忘記本地root的登入密碼解決過程：1、編輯/etc/my.cnf在[mysqld] 配置部分添加一行skip-grant-tables 2、儲存後重啟mysql[[email protected] etc]# service mysqld restartShutting down MySQL.                                         [  OK  ]Starting MySQL.                                                   [  OK  ]3、登入資料庫重新設定root密碼[[email protected] ~]# mysql -uroot -p mysqlEnter password:直接斷行符號進入Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.1.47-log Source distributionCopyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 licenseType ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || test               |+--------------------+3 rows in set (0.00 sec)執行下列語句mysql> update user set password=password("mysql") where user=‘root‘;Query OK, 4 rows affected (0.00 sec)Rows matched: 4  Changed: 4  Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.00 sec) 4、刪除/etc/my.cnf檔案中添加的“skip-grant-tables”行，重啟mysql；用新設的密碼就能正常登入了；原諒我沒有認真學過mysql吧。以上都是在網上找到的解決辦法，拿過來直接儲存了。

mysql登入錯誤或者密碼錯誤