error 1045 (28000): access denied for user

Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using : Yes) Password With The
Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using : Yes) Full Grant On

Operations related to importing and exporting data are disabled, after executing the above command from the command prompt.

Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using : Yes) Password With The

Replace the password with the password that you want to use.

You can turn off this feature to get a quicker startup with -A.

However, turns out I cant backup db1 or db2 or db3 using the script using rootlocalhost.

ERROR 1045 (28000): Access denied for user rootlocalhost (using password: YES).

Having a problem installing a new program Want to know which application is best for the job Post your question in this forum.

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.

Join our community today Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.

Are you new to LinuxQuestions.org Visit the following links: Site Howto.

Having a problem logging in Please visit this page to clear all LQ-related cookies.

For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration.

This book contains many real life examples derived from the authors experience as a Linux system and network administrator, trainer and consultant.

They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.

If that works, I imagine (based on my understanding of what youve said), that your script should work, too.

Plan B, for whatever its worth, might be to use a DIFFERENT user in the script.

PSM.

One other change that I made, and which i overlooked; sorry about that, was the line below in the backup script.

Here is how I setup db4: When I created this db, i created the following user to access the db: mysql create user userTlocalhost identified by; mysql grant all on db4.

But isnt it that root by default has grant on every db created So I made a duplicate of my backup script and made the change like this.

Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using : Yes) Full Grant On

So the only thing I can think of is that root had full grant on db1, db2, db3 but not db4 and hence the error But when i do this.

In several different aspects, for several different potential reasons.

This link might help: Anyway, it sounds like you got it working.

If possible, I encourage you to experiment with different combinations of MySQL username, MySQL host name and grants (using commands like we did above).

Always run flush privileges (andor restart mysql) after making any changes.

Your. PSM PS: Please do click the thanks button if any of our posts helped.

While I have u here, how come my mysql configuration is so tiny.

I ran rpm -ql mysql and it doesnt show me any other config files.

Are these all the config parameters needed to run mysql daemon.

Error 1045 (28000): Access Denied For User 'Root'@'Localhost' (Using Password: Yes) Mac