Re: unable to create database even as root user
Posted by:
siva balan
Date: February 17, 2012 11:32PM
hello scott,
i have posted the entire things.please find
[root@localhost etc]# mysql --host=localhost --user=root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.52 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show grants;
+--------------------------------------+
| Grants for @localhost |
+--------------------------------------+
| GRANT USAGE ON *.* TO ''@'localhost' |
+--------------------------------------+
1 row in set (0.00 sec)
mysql> create database a;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'a'
mysql>
Subject
Written By
Posted
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
Re: unable to create database even as root user
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.