Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
[root@ns bin]# ./mysqldump -u root -p dcb
Enter password:
./mysqldump: Got error: 1045: Access denied for user: 'root@localhost' (Using password: YES) when trying to connect
[root@ns bin]#
I can't figure out what my root is for mysql I used to could backup mysql databases and I can't figure out any root to get it to work any idea of how I can recover a root pass?
Originally posted by Zac2003 but I don't use ensim this specific box is a plesk box.
What ever I use plesk. Same difference. You just have to use "/usr/local/psa/mysql/bin/mysql/" as the paths and by default plesk install the root user is in some cases gone and it's "admin".
Well I'm not sure about using init.d for sending flag such as --skip-grant-tables; Does this really work?
I think you have to kill the proess init.d creates and then start the mysql server from a root shell. Reset the pass and then kill that shell and start again via init.d.
And if your stiil getting this error for root make sure you have a root user in mySQL! Is this the default install?
Found the cause of the problem !We have included "Special Character ( &%#@ ) "in our MYSQL root password and this had caused the problem . We reset the password without any Special character and it resolved the issue. Thank God !
Steps :
Make sure root pass is in /root/.my.cnf
This is usually the first root pass the box was given once cpanel is installed.
If it still does not work, you will need to reset the mysqld root pass.
First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop
Then stop chkservd to keep it from interfering with mysqld while you work on it with /etc/rc.d/init.d/chkservd stop
Start up mysqld , but, without the grant tables,
mysqld --skip-grant-tables -u mysql &
Then change the pass..
mysql -u root mysql UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
FLUSH PRIVILEGES;
Now you just killall -9 mysqld and start it up normally with it's safe_mysqld script..
and update your password in /root/.my.cnf
Remember NOT to include "Special Character" in the password !
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.