Peter, Actually, Mysql -uUSERNAME -pPASSWORD works just fine.
Donny > -----Original Message----- > From: Sunmaia [mailto:[EMAIL PROTECTED] > Sent: Monday, May 31, 2004 7:44 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Root users permissions not working > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]