Hi

i'm a complete newbie on this subject and i've got an error when running the command c:\mysql\bin\mysql mysql

The error i get is: ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Can anyone help me solve that problem.

I'm running on Windows XP and using mysql version 4.0.2a

Thanks

Try using mysql>mysql -u root

I'm not sure why you are getting that error - I don't get the error myself. But if you use the root username, you should be able to get into mysql and start mucking around with the databases.

I managed to solve my problem.

I switched to an older version of mysql, version 4.0.15a instead of the current release of 4.0.2a and it works fine.

Thanks

Paul

A better solution than using old MySQL versions:

Connect as root using the following command:
mysql -u root -p mysql

After this the prompt will ask you for a password which is set to 'root' as default in newer versions of MySQL. Like this:

-------------------------------------------------------------------
C:\mysql\bin>mysql -u root -p mysql
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.20a-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql;
-------------------------------------------------------------------

You can set the password for individual databases by using the 'update' command:

-------------------------------------------------------------------
update mysql.user set password='wrox' where user='root'
-------------------------------------------------------------------

This will change 'wrox' as a password for root user.

(Thx to anand_smart@http://forums.devshed.com)

Ok I am having the same problem and I did what you said but that password wouldn't let me in. I am using veriosn 4.0.20a. Thanks

I am getting the same error message and i have tried all the availabel options. i am running mysql-4.0.20d on windows xp home edition.

At the C:\> prompt, type:

c:\> c:\mysql\bin\mysql mysql -u root

(This is a change in the newer versions of mysql.) Now you can continue and Delete the default users, and set the pass for the root. Another change you will encounter is in #3 after deleting the user, you now need to type:
c:\> c:\mysql\bin\mysqladmin -u root reload

Again, this is a change for the newer versions of mysql and will be addressed in the second edition of the book.

Hope that helps.

-Elizabeth Naramore

now after doing that step and following some other ones that are in the posting i get this message:


c:\mysql\bin> mysql -u root mysql
access denied

i do not have a clue why it would say that.

thank you for you help!!!!