MySQL Forums
Forum List  »  Newbie

unable to create database even as root user
Posted by: siva balan
Date: February 17, 2012 02:51AM

i am using centos linux with mysql server installed.
i can enter as mysql root user by entering >mysql -u root
When i try to create a database,
ERROR 1044 (42000): Access denied for user ''@'localhost'
error comes.
when i execute the following command
mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
output comes.
i stopped my mysql service and start agin with mysqld_safe --skip-grant-tables &
then i executed the same previous command >mysql -u root
mysql> select user();
+--------+
| user() |
+--------+
| root@ |
+--------+

what's wrong?please guide me!
thanks in advance

Options: ReplyQuote




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.