ruby - While connecting to mysql showing socket error -

ruby - While connecting to mysql showing socket error -

i have mysql server installed , contains info also. trying connect mysql ruby code. purpose installed mysql gem using gem install mysql. connection part in programme giving below

require 'rubygems' require 'mysql' require 'csv' $user_name = "root" $pas_wrd = "password" def mysql_connect(db_name) begin db = mysql.real_connect("localhost", "#{$user_name}", "#{$pas_wrd}", "#{db_name}") homecoming db rescue mysql::error => e puts "error code: #{e.errno}" puts "error message: #{e.error}" puts "error sqlstate: #{e.sqlstate}" if e.respond_to?("sqlstate") end end

it written day before , done job. when seek utilize same code shows mysql gem error,something 'initialize' not found. searching found solution re-installing gem. re-installing user command rvmsudo gem install mysql. above problem solved. showing error like

error 2002 (hy000): can't connect local mysql server through socket '/var/run/mysqld/mysqld.sock' (2)

i tried manually using mysql -u root -p

it showing same error.

my mysql my.cnf content given below.

[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql tmpdir = /home/presoft/documents skip-external-locking

the mysql not running in system.

ps aux | grep mysql presoft 3823 0.0 0.0 4368 816 pts/0 s+ 10:41 0:00 grep --color=auto mysql

i tried start using using sudo /etc/init.d/mysql start gave result of

rather invoking init scripts through /etc/init.d, utilize service(8) utility, e.g. service mysql start since script attempting invoke has been converted upstart job, may utilize start(8) utility, e.g. start mysql start: job failed start

can 1 help me find solution because db containing big amount of valuable data.

thanks

regards.

i solved problem above reply tip. problem mysql server corrupted.

so first run command

sudo apt-get purge mysql-common mysql-server

it remove mysql files , configurations out deleting data. after running please watch process , need total warning or error come. got warning like

dpkg: warning: while removing mysql-common, directory '/etc/mysql' not empty not removed.

so removed file , re run above command. after successful execution. re-installed mysql using

sudo apt-get install mysql-common mysql-server

then set root password. after getting in server info safe.

mysql ruby rubygems