Resolve mysql.sock connecting problems on Rails

I handled it, and I am hoping my experience could be helping you. My machine deployment: MySQL5.1.6a, ruby1.8.4, rails1.1.2.

Update: type to make true you can correctly connect database by using username and password

mysql depot_development <db/create.sql -p

, If return error, continue to read.

Several minutes earlier I tumbled at my first Rails problem, when Rails was trying to connect MySQL database, it sucks. The shell prompt appears an error:

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

That means the Rails application can not connect my MySQL correctly, but why? Firstly I checked my configure file in config/database.yml, as the following:

development:
  adapter: mysql
  database: depot_development
  username:              #Note this
  password:
  host: localhost

test:
  adapter: mysql
  database: depot_test
  username:              #Note this
  password:
  host: localhost

production:
  adapter: mysql
  database: depot_production
  username: prod
  password: wibble
  host: localhost

I think my config file was right, and googled this error on web. It seems that the same problem is bothering mamy people who rock with Ruby on Rails. After skim over several sites I can search, all of them still can’t help me out to handle the mess. Some one suggest that it might be your MySQL setup version needed to upgrade, and others assist to type

ruby script/server environment=development

. I did it, but received same error.

Ermmmmmm, a little frustration…..eh? but back to the book Agile Web Development with Rails(1st edition), and preusing at page 52. I think the author describes this problem explicitly, yet many Rails forks who have same error didn’t get his point perfectly well. After creating a database in MySQL, you may assign such corresponding grant to users. Like:

mysql> create database depot_development;
mysql> create database depot_test;
mysql> create database depot_production;
mysql> grant all on depot_development.* to 'dave'@'localhost';
mysql> grant all on depot_test.* to 'dave'@'localhost';
mysql> grant all on depot_production.* to 'prod'@'localhost' identified by 'wibble';
mysql> exit

In config/database.yml, if you want any developer can access your database by conviention, you will left the username field blank, and find sth like this:

development:
  adapter: mysql
  database: depot_development
  username:              #blank
  password:
  host: localhost

test:
  adapter: mysql
  database: depot_test
  username:              #blank
  password:
  host: localhost

production:
  adapter: mysql
  database: depot_production
  username: prod
  password: wibble
  host: localhost

and that will cause error. Because when Rails connecting MySQL, it find the user name and password in conf/database.yml, if you left blank in username and password field, Rails will use root authority to connect database, but it can’t find what is the root password, then prompt error. That’s why it sucks rather than what MySQL version is, and you get:

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

You must specify the correct username and password that should be the same ones when creating relevant database. Such as:

development:
  adapter: mysql
  database: depot_development
  username: dave	#dave has no password in his database
  password:
  host: localhost

test:
  adapter: mysql
  database: depot_test
  username: dave	#dave has no password in his database
  password:
  host: localhost

production:
  adapter: mysql
  database: depot_production
  username: prod	#prod has password in his database
  password: wibble	#which is 'wibble'
  host: localhost

Refresh your browser, and you see…..? Cheers.

Important Update:

I strongly recommend that same individual must hold the same username and corresponding password in your different app’s config/database.yml for true, no matter which of databases in mysql you used in various app by the same user.

For instance, I am alex and I really am ^^). I have two Rails app, depot and radiant(a simple CMS, I take a trial just now). If both depot and radiant use ‘alex’ as a mysql connect username, I must specify same user name and same password in the two database.yml, otherwise one of these app will get confused and restrained as connecting mysql, even the two app will implement their respective databases, because they all use ‘alex’ to connect mysql. So ‘alex’ needs same database password in different Rails app.

If you installed Rails before installed MySql, Rails database driver cannot find your database. You should reinstall Rails or other choice, add MySql socket location to respective section in ‘database.yml’, such as

socket: /var/lib/mysql/mysql.sock

Or, prompt saying:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

to solve this sort of error, check it out my recent post on it.

If your problem to be worked out after reading my post or still have any connecting problem, I wish you can leave your comment here. Lemme know and welcome .

Advertisement