Cannot create database{MySql}

[Dillinger4]

Ive been tinkering with MySql and everytime i try to create a database using sql i get an error in dos. ERROR 1044: Access denied for user: '@localhost' to database 'whatever the database name is '

How can acccess be denied when i haven't even created the database yet.

[brucevde]

If MySQL security is anything like SQL Server then your server login has not been granted permissions to create databases.

[mendhak]

In your connection string, is root your username?

The default in MySQL is username: root with a blank password.

[Dillinger4]

Posted by mendhak
In your connection string, is root your username?

The default in MySQL is username: root with a blank password.

Im trying to create the database from dos but i don't understand what dos trying to tell me. It's saying that access is denied to the database when i haven't even created it yet.

[Dillinger4]

I found this in a mysql reference manual. So this should fix it.

Access denied for user error

If you attempt to run a MySQL client program to connect to a server running on the same machine, but get the error Access denied for user: 'some-user@unknown' to database 'mysql', this means that MySQL cannot resolve your hostname properly. To fix this, you should create a file named `\windows\hosts' containing the following information:

127.0.0.1 localhost

[Dillinger4]

Ok ***. This $hit ain't working at all. What is host supposed to be saved as? Just a .txt file?

[mendhak]

No, it'll be a file named hosts without an extension.

Just like in

C:\WINNT\system32\drivers\etc

[Dillinger4]

I saved 127.0.0.1 localhost in notepad which i named hosts which has the path C:\WINDOWS\hosts with no extension but this still dosen seem to help.

[Dillinger4]

This version(and probably others) allowme to connect as an anonymous user to the server running on local host.

I ran mysql> select user(); and it came upODBC@localhost so i don't think it's a connection issue.

Maybe need to be granted privileges to create databases? Can i use the following or is this just used when you want to access a db that already exists?

mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host';

[Dillinger4]

Ah forget it. Ill just use the db that comes with mysql for now. C:\mysql\data\test If anyone still knows what i can do please still post.

[slice]

I know this is two years old thread.
But i am having same problem...
Windows XP and mysql 4.1 ... How to solve ^^ same error.