#1044-Access denied for user ****@localhost to _DBNAME_ in Yahoo!

[gasernag]

I just installed MySQL and phpMyAdmin in Yahoo! webhosting but when I try to create a table I get the error message: #1044-Access denied for user ****@localhost to _DBNAME_.

I am sure I have a database persmission problem that doesn't allow me to do basically anything but I don't know how go fix it.

I also notice that the error message says user ***@localhost when it should really say ***@mysql (because Yahoo! doesn't use "localhost" but "mysql" as the localhost. Also, instead of saying _DBNAME_ it should say mysql which is the default name for my database, but again I don't know how to fix it.

I have seen recommendations like "run the script mysql_fix_privilege_tables". But, HOW do I run it? WHERE?.

In other places I have seen recommendations like "run these series of MySQL commands ...". Again, HOW do i run MySQL commands? WHERE? I don't have a local installation of MySQL, I am using Yahoo!'s installation.

I would appreciate any help from anyone.

Thanks

[vssp]

This ERROR message is a result usually of the user not logging onto mySQL correctly.

In the Dos Prompt type

c:/mysql/bin/mysql -u root

This will open the mySQL monitor window under the user "root" the default administrator that mySQL has set up automatically.

From here you can add users and give them "PRIVILAGES or GRANTS" (enables access rights to the programme to create, drop ,change databases or tables etc)

Hope this helps.

p.s. some commands for DOS mySQL newbies

mysql> show databases;

mysql> create 'database name' (creates database)

mysql> drop 'database name' (BE CAREFUL deletes databases)

mysql> use 'name of database' (drop the ' ' and this will enable you to acces a database)

mysql> show tables (shows tables in a database)

mysql> create 'table name' (creates a table in a db)

mysql> drop 'table name' (deletes a table)

mysql> select * from 'table name' (show contents of table)

mysql> explain 'table name' (shows table details)

You'll have to look up the rest your self happy mysqling
Thanks
Vssp