Hi, > > ERROR 1045 (28000):Access denied for user 'pa1'@'localhost' (using > > > password: > > > YES) >
> 1. Login to mysql using root account > 2. Create new user account in MySQL > 3. Grant required privilege to the user. > > > 1. Login to mysql using root account $ mysql -u root -p mysql Enter password:[enter the password, nothing will be displayed ,not even asterisks] mysql> 2. Create new user account in MySQL mysql>CREATE USER 'pa1'@'localhost' IDENTIFIED BY 'some_pass'; 3. Grant required privilege to the user. mysql>grant all on *.* to 'pa1'@'localhost' identified by 'some_pass'; mysql>grant all on *.* to 'pa1'@'%' identified by 'some_pass'; ref manual for selective grant options. 4. get out of mysql mysql>exit 5. enter into mysql with the new user which has been created $ mysql -u pa -p Enter password 6.Entering right password ,Bingo , you are in mysql> My take is that ,ensure you have entered right password. HTH, Cheers, Thyagarajan Shanmugham _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
