Women in Technology

Article:		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? ~~J.

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.

• Can't log in to MySQL - seems to be properly configured
  2005-10-16 14:51:33  Curt Hibbs | [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):
  
  http://instantrails.rubyforge.org/
  
  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 "127.0.0.1" 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!
  
  ~~J.