User creation error.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rathlon
Forum Commoner
Posts: 45
Joined: Sun Nov 10, 2002 8:07 pm

User creation error.

Post by rathlon »

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 avatar
TheTestUser
Forum Newbie
Posts: 9
Joined: Sat Dec 14, 2002 9:25 pm

Post by TheTestUser »

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
Post Reply