MySQL Forums
Forum List  »  Install & Repo

Re: Access denied to mysql database using w2K professional
Posted by: anand sarda
Date: September 18, 2004 06:56PM

There are a few suggestion to look at:

First, You can refer to the tutorial section in MySQL manual for managing the server.

Second, determin whether you have proper access to the server.
- Login using "mysql -u root" on the command prompt. Use "-p <password>" if you have set up the password for the user "root"
- On the console enter
- "use mysql" command, this will select the mysql database.
- "select host, user, password", this will show you the list of host and users
who have access to this server.

Now, check if the list contain the computer from which you are trying to access this server, if not then add it to the list in the following manner:
insert into user (host, user, password) values (<client's ip address>, <username>, password(<password string>);

After that, from the client computer's command prompt login as mentioned above using the new user name and password


Hope this helps.

Regards,
Anand

Options: ReplyQuote


Subject
Written By
Posted
Re: Access denied to mysql database using w2K professional
September 18, 2004 06:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.