LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Zenwalk (https://www.linuxquestions.org/questions/zenwalk-75/)
-   -   problem with mysql (https://www.linuxquestions.org/questions/zenwalk-75/problem-with-mysql-798941/)

shifter 03-30-2010 01:20 PM

problem with mysql
 
I've installed mysql on Zenwalk 6.2. I have the following questions:

1) How can to access into mysql prompt. I have the following error:

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

2) How can to set mysql user and password?

regards,
savio

bathory 03-30-2010 03:16 PM

Hi,

1.
First verify that mysqld is running and /var/run/mysql/mysql.sock exists.
You should check my.cnf and see where the client (mysql) expects to find the mysql socket.
You have to make sure it's the same as the one in the daemon part of my.cnf:
Quote:

[client]
...
socket = /var/run/mysql/mysql.sock
...
[mysqld]
...
socket = /var/run/mysql/mysql.sock
...
2.
You can read this for help.

Regards


All times are GMT -5. The time now is 08:31 PM.