> Peter, > Actually, > > Mysql -uUSERNAME -pPASSWORD works just fine. > > Donny
And `mysql -u root -p somepassword` will not work. With the space between -p and "somepassword", mysql will attempt to interpret "somepassword" as the name of a database.
As to the original question, the problem appears to be with root's privileges, not root's password. First doublecheck that mysql believes you are [EMAIL PROTECTED] with
SELECT CURRENT_USER();
Then, you can check your privileges with
SHOW GRANTS FOR [EMAIL PROTECTED];
If they don't look right, you may be able to fix them with
GRANT ALL ON *.* TO 'root'@'localhost' WITH GRANT OPTION
so long as you still have rights to the mysql db. If that doesn't work, reply with the results.
Finally, you probably should not log in with
mysql -u root -psomepassword
as it makes the password visible to others using ps at the right moment. Instead, just use
mysql -u root -p
and let mysql prompt you for the password.
Michael
Donny Simonton wrote:
-----Original Message----- From: Sunmaia [mailto:[EMAIL PROTECTED]
hi
this may be the problem or it may just be a typo! you are showing
#mysql -u root -psomepassword
which should be #mysql -u root -p somepassword (note the space after -p)
the first will not pass the password, which would explain the lack of privileges.
Otherwise start with skip-grant-tables and reset the root password.
If you do is there a possibility it may have been hacked?
Peter
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Hi Guys,
I have been using mysql for a year now without any problems. Recently, I just noticed that my root user is not able to create any databases when I login. I have tried to change my root password and try but it does not work:
-- #mysql -u root -psomepassword Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 52 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database slugz; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'slugz' mysql> --
I am able to do use databasename and show table commands but cannot make any changes. I have been able to before without any problems and I have not made any configuration changes to mysql. Is there something that I might be missing?
Any help would be grately appreciated.
Thanks in advance, -Simran
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
