|
Replies:
1
-
Pages:
1
-
Last Post:
Oct 13, 2010 2:30 PM
by: cweyn_109
|
|
|
Posts:
1
Registered:
5/2/10
|
|
|
|
Access denied for user . . . . . can not connect
Posted:
May 8, 2010 2:05 PM
|
|
|
Using TOAD on WinXP client and can not connect to mysql on remote linux (redhat) server. Error: Access denied for user 'dlw27'@clientname. Why does error msg show 'client' machine name instead of host server name I typed in?
Verified dlw27@servername valid user in mysql (user table within mysql DB).
Verified port 3306 listening for TCP (used portqry utility).
|
|
|
Posts:
3
Registered:
10/13/10
|
|
|
|
Re: Access denied for user . . . . . can not connect
Posted:
Oct 13, 2010 2:30 PM
in response to: don-psu
|
|
|
Don,
The client name is displayed because that is how the user security is setup in MySQL: users are authorized when connecting from a certain location (in this case, from 'clientname'). This prevents someone from trying to connect from any server. In many cases, I restrict connection to localhost, or to the IP address of the server on which my database is, so that no one, not even me, can connect from another location.
I hope this helps,
Chris
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
