mysql problem
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")
i get this error when i run the command : "mysql -u root -p" i m currently using manjaro linux. |
What does:
Code:
netstat -ln | grep mysqld |
nothing
the command was just executed successfully without an error but didnt give me any output.
|
Quote:
How did you start your mysql server, if at all? Also, what does: Code:
ps aux | grep mysql |
[bakabon@bakabon-Xenon mysql]$ ps aux | grep mysql
root 3758 0.0 0.1 70072 4864 pts/0 T 22:54 0:00 sudo mysqld_safe root 3759 0.0 0.0 13888 3252 pts/0 T 22:54 0:00 /bin/sh /usr/bin/mysqld_safe mysql 3873 0.1 3.0 656468 121084 pts/0 Sl 22:54 0:00 /usr/bin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/bakabon-Xenon.err --pid-file=bakabon-Xenon.pid --socket=/run/mysqld/mysqld.sock --port=3306 bakabon 4000 0.0 0.2 43024 9360 pts/0 S+ 22:56 0:00 mysql bakabon 4023 0.0 0.0 10764 2104 pts/1 S+ 22:58 0:00 grep --colour=auto mysql |
Do you have a /run directory in your system?
Look like a setup error to me (should be /var/run) |
Quote:
/run is simply a symlink to /var/run (at least on arch linux) so it shouldn't really matter. Best regards, HMW |
Quote:
To Op: Did you check /run/mysqld content and permissions? |
how do i do it?
|
Kali Linux is your installed OS?
I ask because I heard there are no other user than root in setup, and mysql requires 'mysql' user and group Anyway, you can check permissions and content with the ls command Code:
ls -l /run/mysqld |
All times are GMT -5. The time now is 08:32 PM. |