MySQL access denied error

[kozumo]

I'm just starting out with MySQL and I'm following the tutorial on mysql.com.

When I came to this part:


mysql> GRANT ALL ON menagerie.* TO your_mysql_name;
ERROR 1044: Access denied for user: '@localhost' to database 'menagerie'


...as you can see it gave me a permission error. What do I have to do to make a regular user the admin or whatever to solve this problem?

Thanx

[CanadaMan]

I'm just starting out with MySQL myself but I think your problem is that you're not identifing the host that your_mysql_name is comnig from. I know that MySQL allows for the same name with a different hostname or none at all.

Another possibility is that you might not be the root user (or a root-access user) when you run the command. Try and access the mysql database (use mysql). If you can't get in you're not root.

If this doesn't help look on the web-serving board here. They have lots of MySQL stuff.

[kozumo]

I tried that command with mysql under root and it works. Except I don't really want to do it with root. Is it possible to do it under a regular user?

I also tried:

kozumo@gaspar:~$ mysql -h gaspar -u kozumo -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'gaspar' (111)


And as you can see it spit out another error message. How do I create a user in MySQL? or whatever to make this work?

Thanx ;)