connection to mysql

narayanank · 02-25-2010, 06:46 AM

when i try to connect to mysql from terminal i get the following error message.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

What do i do to connect to mysql

tronayne · 02-25-2010, 07:31 AM

First off, is the MySQL daemon running; i.e., did it start at boot and if you execute

Code:

ps -ef | fgrep mysql

you should see something like

Code:

root      3683     1  0 Feb20 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/v
mysql     3720  3683  0 Feb20 ?        00:00:01 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=

If you do not have something similar to the above, did you initialize MySQL; i.e., did you, as root, execute

Code:

mysql_install_db --user=mysql

(the --user-mysql is vital) to initialize the data base. In the above case, the data directory is /var/lib/mysql and mysql_install_db creates a new installation with owner and group mysql (some things are group root). Your data directory will be owner and group mysql (if not, change them).

You may need to look for the daemon start up and shut down script (it could be in /etc/rc.d or somewhere similar) and make sure that it is executed during system start up.

Hope this helps some.

narayanank · 02-26-2010, 02:03 AM

Quote:

Originally Posted by tronayne

First off, is the MySQL daemon running; i.e., did it start at boot and if you execute

Code:

ps -ef | fgrep mysql

you should see something like

Code:

root      3683     1  0 Feb20 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/v
mysql     3720  3683  0 Feb20 ?        00:00:01 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=

If you do not have something similar to the above, did you initialize MySQL; i.e., did you, as root, execute

Code:

mysql_install_db --user=mysql

(the --user-mysql is vital) to initialize the data base. In the above case, the data directory is /var/lib/mysql and mysql_install_db creates a new installation with owner and group mysql (some things are group root). Your data directory will be owner and group mysql (if not, change them).

You may need to look for the daemon start up and shut down script (it could be in /etc/rc.d or somewhere similar) and make sure that it is executed during system start up.

Hope this helps some.

it was working thanks,. ihad actually not started the mysqld service

resetreset · 02-27-2010, 01:20 PM

just to say, you can use "ntsysv" to start up and stop all your services on fedora.