mysql cannot connect error.

**mr.popper** · 04-30-2005

I get this error whenever I try to connect to mysql. This error also appears when I type

<code>mysql -p root</code>

root@slackware:/var/run/mysql# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

**sdousley** · 04-30-2005

try connecting with:

Code:

mysql -u root -p

-u tells mysql server what username to use, and the -p (wqith nothing after it) tells the server to prompt for a password

**daikatana_** · 04-30-2005

Have you installed initial database?

Code:

su - mysql
mysql_install_db

**mr.popper** · 04-30-2005

I tried installing the initial database, but I still get the same error when I do

Code:

mysql -u root -p

I also set a root mysql password already. Whenever I turn on the computer, it also says that mysql has shut down. I will post the exact error when I can

**sdousley** · 05-01-2005

Originally Posted by mr.popper

Whenever I turn on the computer, it also says that mysql has shut down. I will post the exact error when I can

This could be a problem, if the mysql server isn'#t up and running, u cant connect to it. try:

Code:

/etc/init.d/mysql start

to start the mysql server, then try the

Code:

mysql -u root -p

command

**veritas** · 05-02-2005

I have a feeeling you could be getting the error that is caused by bad permissions in the mysql directory. Try this command out:

Code:

chown -R mysql&#58;mysql /var/lib/mysql

**mr.popper** · 05-04-2005

apparently there is no such directory as

/etc/init.d/mysql

I found it in /usr/bin/mysql

if I do /usr/bin/mysql start, I get the same error as always. I also tried chown-ing that folder, but with the same result.

**Goran** · 05-04-2005

Try this:

Code:

&#40;as root&#41;
chown +x /etc/rc.d/rc.mysqld
/etc/rc.d/rc.mysqld start
myswl_install_db
mysql -u root -p

Does it work ?

**mr.popper** · 05-04-2005

that worked, thanks! How do I get mysqld to start on boot?

**daikatana_** · 05-04-2005

Code:

chmod 755 /etc/rc.d/rc.mysqld

Thread Tools

Display

mysql cannot connect error.

Posting Permissions