Women in Technology

Hear us Roar

  Rolling with Ruby on Rails
Subject:   Can't log in to MySQL - seems to be properly configured
Date:   2005-10-16 10:59:52
From:   TresWife
Local install on Win XP SP2, from an Administrator account.
Attempting to use from the same account under which it was set-up.
Firewall: Zone Alarm

Installations done according to tutorial. No password set for MySQL. MySQL Front log-in set-up with a made up name in General, server=localhost port=3306 connection type=direct under Connection, and user=root password= under Log-In.

I get:
SQL Execution error #1045. Response from the database: Access denied for user 'root'@'localhost' (using password=NO) Please check the username and password. Afterwards, please ask the database administrator (Internet provider) if you are allowed to connect fromt he computer.

I've also tried un-installing and re-installing witha configuration that includes a password, and I get the same result.

Any ideas?


Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • Can't log in to MySQL - seems to be properly configured
    2006-03-09 09:57:51  sandrino [View]

    I was getting an access denied error:

    #28000Access denied for user 'root'@'localhost' (using password: NO)

    I got around the problem by deleting the password. from the root account. It is not the ideal solution but it will allow me to continue the tutorial. I had tried setting MySQL to use the old password format but that had no effect whatsoever. Deleting the password was the only thing that worked for me.
  • Curt Hibbs photo Can't log in to MySQL - seems to be properly configured
    2005-10-16 14:51:33  Curt Hibbs | O'Reilly AuthorO'Reilly Blogger [View]

    It sounds like you've done everything right. I'm not sure what's going on.

    As an alternative you could try using "Instant Rails" instead (this didn't exist when this tutorial was written):


    Instant Rails includes mysql and apache, but can safely ignore the apache part and just make use of the included mysql (which is set up with no password). If you decide to try Instant Rails, be sure to uninstall your existing mysql first.
    • Can't log in to MySQL - seems to be properly configured
      2005-10-16 16:00:11  TresWife [View]

      Thank you for that tip-off.

      However, the access issue has now been fixed by using "" fo rhte host name, instead of "localhost", per mention by one Dan Greening in the comments threat at http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html .

      Maybe this will help someone else as well!

      Again, thanks!