I created a new user for access via the web. As far as I can guess they only need a few privileges. Problem is, when I try to create a new connection via mysqlCC with the new users credentials, I get this connection error:
[Projects web connect] ERROR 1045: Access denied for user: 'web@ws-74r116-11l.dm.af.mil' (Using password: YES)
Easy enough...the server is denying logins beyond localhost...i.e. anything with '@blah.blah.com'. Question is, what is causing this setting and how do I reverse it so that this user may login?
User creation error.
Moderator: General Moderators
- TheTestUser
- Forum Newbie
- Posts: 9
- Joined: Sat Dec 14, 2002 9:25 pm
As far as I remember, it has to do with the host field in the mysql.user table.
You probably have an entry for the user as localhost in the Host field, right? Do you have a seperate entry for hosts outside of localhost? Allowing them to login via any domain/host may be as simple as copying that other field with the Host Field set to '%'.
Don't take my word for it, check out the documentation:
http://www.mysql.com/doc/en/Access_denied.html
http://www.mysql.com/doc/en/Privileges.html
http://www.mysql.com/doc/en/User_Accoun ... ement.html
You probably have an entry for the user as localhost in the Host field, right? Do you have a seperate entry for hosts outside of localhost? Allowing them to login via any domain/host may be as simple as copying that other field with the Host Field set to '%'.
Don't take my word for it, check out the documentation:
http://www.mysql.com/doc/en/Access_denied.html
http://www.mysql.com/doc/en/Privileges.html
http://www.mysql.com/doc/en/User_Accoun ... ement.html