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
Subject
Written By
Posted
unable to create database even as root user
February 17, 2012 02:51AM
February 17, 2012 03:29AM
February 17, 2012 03:53AM
February 17, 2012 09:57PM
February 17, 2012 10:06PM
February 17, 2012 11:32PM
February 26, 2012 11:04PM
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.