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] > Sent: 01 June 2004 01:26 > To: [EMAIL PROTECTED] > Subject: Root users permissions not working > > > 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] > > > Email has been scanned for viruses and SPAM by Trader Mailmanager > www.trader.uk.com > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
