Hi everyone 1) I have a mySQL problem.After logging in as root and creating a database I am trying to grant all the privileges on it to a user with the following command which I read in the book "MySQL by Paul Dubois". GRANT ALL ON db_name.* TO user@% IDENTIFIED BY 'some_password' ; On running the above command i get the following syntax error
ERROR 1064: You have an error in your SQL syntax near '% identified by 'mypassword'' at line 1 2) Next i modiyfied the command to GRANT ALL ON db_name.* TO user@'%' IDENTIFIED BY 'some_password' ; This particular query ran FINE but when i try connecting to the databse with the following mysql -p db_name and after specifying the correct password.I get ERROR 1045: Access denied for user: 'user@localhost' (Using password: YES) I did like to know what am i doing wrong.Why am i not able to run the query in point (1) and secondly why am i not able to get connected in (2) What am i doing wrong over here.Please help. I am using linux 7.1 kernel 2.4.2-2 and MySQL 3.23.38 Thanks everybody. Regards Virindera -- _______________________________________________ Win a ski trip! http://www.nowcode.com/register.asp?affiliate=1net2phone3a ================================================ To subscribe, send email to [EMAIL PROTECTED] with subscribe in subject header To unsubscribe, send email to [EMAIL PROTECTED] with unsubscribe in subject header Archives are available at http://www.mail-archive.com/ilugd%40wpaa.org =================================================
