MySql access denied...

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
sagarchandratrey
Forum Newbie
Posts: 3
Joined: Tue Nov 05, 2002 3:34 am
Contact:

MySql access denied...

Post by sagarchandratrey »

Hello.

I connect to mysql and try to use the mysql database.

MySql doesnt allow me saying
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

I can use the test database but not the mysql.

I tried the things mentioned in the docs on the MySql.com site..but it doesnt work !!!

Can any one suggest whats the problem??
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Have you checked to make sure that the username and password you are trying to use are correct, or are you in fact trying to access MySQL without a username and password where one is required?

Mac
User avatar
Wayne
Forum Contributor
Posts: 339
Joined: Wed Jun 05, 2002 10:59 am

Post by Wayne »

If the Username & Password are correct and you are using them to connect. In the MySQL database it specifies which location that user can obtain access from check the MySQL - user table and check what the host is for the user. The user you are trying to connect as may also not have priveledges to access the MySQL database.

Start by ruling out what Mac has suggested.
Post Reply