Access Denied For User 'Root'@'Localhost' (Using : No) Install MySQL 5

Community List of all users List of all organizatioins Advent Calendar Qiita Jobs Qiitadon () Qiita Zine Community Guideline How to write good articles Release note Signup Login.

What is going on with this article Its illegal (copyright infringement, privacy infringement, libel, etc.) Its socially inappropriate (offensive to public order and morals) Its advertising Its spam Other than the above, but not suitable for the Qiita community (violation of guidelines) rake db:migrate Access denied for user rootlocalhost (using password: NO) MySQL GitHub ActiveRecord rake Rails4 More than 3 years have passed since last update.

Mysql2::Error: Access denied for user rootlocalhost (using password: NO).

We will deliver articles that match you By following users and tags, you can catch up information on technical fields that you are interested in as a whole you can read useful information later efficiently By stocking the articles you like, you can search right away Sign up Login.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.

Win a Raspberry Pi.

Learn about Rust and Web Assembly this week in the Server-Side JavaScript and NodeJS forum.

If its not the appropriate forum, moderators please move this thread to the one.

Access Denied For User 'Root'@'Localhost' (Using : No) Install MySQL 5

I have been trying to install MySQL 5.0 in Windows XP.

The installation was successful but during the final step of configuration i had been getting this error, Error Nr 1045.

As someone else suggested i have opened the TCPIP Port 3306 (where MySQL gets installed as a service and listens to any connection request) through the Windows Personal Firewall (inside Control Panel).

I verified the same in command prompt through netstat -a command also.

When the same issue arose in my home pc, i got it resolved through excluding the port through Personal Firewall The only difference is i am inside a corporate network here at office.

Can anyone help me out in resolving this issue Am i missing something here Thank you in advance.

Is the current user a local admin on the box, else you wont have permissions to set the firewall (to the best i know) 2.

Take an output of netstat - aon and see which process is binded to what.

Are you able to do a telnet to port 3306 Thanks December 03, 2007: Message edited by: Bindesh Vijayan.

Please check the MySQL install documentation for user setup (if I recall correctly, you need to specify both user and host, like rootlocalhost) in a users table.

As you have set one in the setup, this is not allowed, and the connection fails.

Apparantly the installation itself ignores the password it has just set.

But still how come the same got resolved in my home pc but not here quite confused and getting bugged off I tried completing by NOT giving the password for root user.

The configuration was successful but i could not proceed further as my login to mysql was not getting in as i am not aware of the default password being set.

And, according to the documentation (see here ), whether there is an initial password or not depends on the installation procedure that you choose.

The documentation is, in my experience, accurate and detailed, so you shouldnt have a problem reinstalling MySQL.

You can change your password in the following way Resetting Permissions Mysql Hope this helps.

It did work Still i wonder how come the same got resolved in my home PC and not in my office PC until i did this work around Thank you again for helping me resolve a big issue.

Mac Access Denied For User 'Root'@'Localhost' (Using Password: No)