MySQL Forums
Forum List  »  Newbie

Can't Create Database - Receive Error 1044
Posted by: ntwrkadmin
Date: May 30, 2005 09:28PM

I am having a hard time creating a new database in MySQL, because I get an Error 1044 that says "access denied for user: '@localhost' to database 'seo' ("seo" is the new database I am trying to create).

I can successfully log on to MySQL by typing: mysqladmin -u root -p status and then entering my password, which is accepted.

After doing this, I type "mysql" and I get the following message: "Welcome to the MySQL monitor. Your MySQL connection id is 13 to server version 4.0.24-nt."

At the "mysql>" prompt, I then type: CREATE DATABASE seo;

After I hit ENTER, I receive the Error 1044 message access denied for user: '@localhost' to database 'seo'.

I'm not sure why I can't create a database. I can show available databases by typing: SHOW DATABASE; but I can't create one.

Does anyone have any solutions to this dilemma?

Options: ReplyQuote


Subject
Written By
Posted
Can't Create Database - Receive Error 1044
May 30, 2005 09:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.