問題描述
我不知道為什么我會得到這個，用戶，altjenb 在 mysql 數據庫中有完全訪問權限，但我仍然收到同樣的錯誤.我嘗試在 mysql8.db4free.net 和 db4free.net 上使用在線數據庫并得到相同的錯誤.在 localhost (xampp) 中嘗試過，仍然是同樣的錯誤..
I dont know why am I getting this, user, altjenb has full access in the mysql db but I still keep getting the same error. I tried to use online db at mysql8.db4free.net and db4free.net and got the same error. tried in localhost (xampp) and still the same error..
MySqlException: 用戶 'altjenb'@'localhost' 的訪問被拒絕(使用密碼:是)
MySqlException: Access denied for user 'altjenb'@'localhost' (using password: YES)
這是連接字符串
MySqlConnection connectionstring = new MySqlConnection("Server=localhost; port= 3306; Database=battlehunt_db; UserId=altjenb; Password=egrgeaf;");
我手動授予用戶完全訪問權限.但還是什么都沒有我試圖通過
I manually granted full access to the user. but still nothing, I tried to give access with
GRANT ALL PRIVILEGES ON * battlehunt_db. * TO 'altjenb'@'localhost';
但還是一樣的錯誤.
但是當我將用戶 ID 更改為 root 并且沒有密碼時.它連接到數據庫 .. 看起來它沒有收到用戶名.. 我嘗試添加一個未在(例如 egwetr)中注冊的隨機用戶名，但它仍然顯示相同的錯誤..
but when I change the userID to root and no password. it connects to the db.. it looks like it doesnt receive the user name.. I tried to add a random user name who is not registered in (eg. egwetr) and still it showed the same error..
我該如何解決這個問題?
how can I fix this?
我正在嘗試將 unity3d 5 與 mysql db 連接
Im trying to connect unity3d 5 with mysql db
推薦答案
好的，解釋我對這個問題的評論.
Ok, Explaining my comment on the question.
假設該用戶的密碼是正確的錯誤信息:
Assuming that the password for that user is correct the Error message:
MySqlException: Access denied for user 'altjenb'@'localhost' (using password: YES)
這可能意味著用戶沒有連接到服務器'localhost'的權限
It can mean that the user does not have permision to connect to the server 'localhost'
在用戶表中，您可以看到哪些主機具有權限:
In the user table you can see to what host has permission:
---------------------------
user | host |
---------------------------
user1 | localhost |
user1 | 127.0.0.1 |
user2 | 127.0.0.1 |
在這個例子中，user1 可以連接到 localhost 和 127.0.0.1 所以:
in this example, user1 can connect to localhost and 127.0.0.1 so:
new MySqlConnection("Server=localhost; port= 3306; Database=battlehunt_db; UserId=user1; Password=egrgeaf;");
new MySqlConnection("Server=127.0.0.1; port= 3306; Database=battlehunt_db; UserId=user1; Password=whatever;");
兩個連接都有效
但用戶 2 只能訪問 127.0.0.1
But user 2 only has access to 127.0.0.1
所以:
new MySqlConnection("Server=localhost; port= 3306; Database=battlehunt_db; UserId=user2; Password=egrgeaf;");
會失敗，因為它試圖連接到本地主機"
will fail because it's trying to connect to 'localhost'
和
new MySqlConnection("Server=127.0.0.1; port= 3306; Database=battlehunt_db; UserId=user2; Password=whatever;");
會成功.
在Mysql的用戶表中查看哪個主機可以訪問用戶'altjenb'，如果'altjenb'沒有主機'localhost'，您可以添加它或將連接字符串更改為用戶擁有的主機之一.
Check in the user table of Mysql to what host has access the user 'altjenb', if 'altjenb' does not have the host 'localhost' you can add it or change the connection string to one of the hosts the user has.
希望對您有所幫助
這篇關于MySqlException:用戶“altjenb"@“localhost"的訪問被拒絕(使用密碼:YES)的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！