> 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 -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
