RE: Access Error - Carsten H. Pedersen - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRE: Access Error

From	Sent On	Attachments
Hai Nguyen	08 Dec 2001 09:36
Hai Nguyen	09 Dec 2001 19:32
Carsten H. Pedersen	09 Dec 2001 23:24
+markus	10 Dec 2001 14:15

Subject:	RE: Access Error
From:	Carsten H. Pedersen (cars...@bitbybit.dk)
Date:	12/09/2001 11:24:52 PM
List:	com.mysql.lists.mysql

Hi,

I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2 linux box. I installed it using rpm.

I can start mysql but everytime I try to create a database, I keep getting this error:

mysql> create database guessbook; ERROR 1044: Access denied for user: '@localhost' to database 'guessbook' mysql>

Does anyone know what is going on here?

You're logged on to mysql as the anonymous user, and you only have access to the database "test". Log on as root, and set the correct permissions. More info:

http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0

http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0

sec. 4.2.4 - 4.2.10 of the manual

/ Carsten