MYSQL Access denied
Hi,
First time I have taken a dedicated server and on that I have very less knowledge about MYSQL and Linux commands.
When I am trying to enter
shell>MYSQL
it is giving access denied message. Even when I am using
shell> mysql -u root -p
I am getting this error message "Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"
Can some please help in why >MYSQL is not working and how to retrrieve the mysql root password.
Thanks in Advance
Amjad
First time I have taken a dedicated server and on that I have very less knowledge about MYSQL and Linux commands.
When I am trying to enter
shell>MYSQL
it is giving access denied message. Even when I am using
shell> mysql -u root -p
I am getting this error message "Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"
Can some please help in why >MYSQL is not working and how to retrrieve the mysql root password.
Thanks in Advance
Amjad
Computers & Internet - Sun - MySQL
Answers & Comments
Hi Buddy,
Try this option....
mysql -u root -p
mysql will then ask you for the password give the proper password.
For changing mysql root password
mysqladmin -u root -p password <<newpwd>>
then mysql ask you to give password this is the old password and now the new password for the root will be newankush.
You can also use:
sudo -s
Then whatever code lines you need to have all permissions on the system