Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES),

來源:互聯網
上載者:User

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES),

http://www.androidren.com/index.php?qa=211&qa_1=warning-mysql_connect-access-denied-root%40-localhost-password

代碼可能是這麼寫的:

//to make a connection with database$conn = mysql_connect("localhost", "root", "password") or die(mysql_error());

在某些情況下,你改成下面就可以解決:

$conn = mysql_connect("localhost", "root") or $conn = mysql_connect("localhost", "root", "")

但是,有些情況下它的根本原因是你的當前資料庫的使用者沒有獲得多資料庫訪問的授權。

其實,最多的原因可能是你的資料庫沒有起來。O(∩_∩)O哈哈~

解決方案是你啟動資料庫。

這種情況下的表現是:

1.在命令列下:

forlong401:Documents forlong401$ sudo mysql --user=root -p

Enter password: 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2. 在瀏覽器上:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /Library/WebServer/Documents/qa/qa-include/qa-db.phpon line 68

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /Library/WebServer/Documents/qa/qa-include/qa-db.php on line 68

Could not establish database connection. Please check the username, password and hostname in the config file, and if necessary set up the appropriate MySQL user and privileges.

3. 在phpmyadmin上:

#2002 無法登入 MySQL 伺服器



相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.