[Ilugc] error in installing mysql in ubuntu ?
- From: citizenofgnu@xxxxxxxxx (Thyagarajan தியாகராஜன்)
- Date: Mon May 10 22:51:37 2010
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
Other related posts: