Results 1 to 5 of 5
Thread: error 2002 on mysql login
Enjoy an ad free experience by logging in. Not a member yet? Register.
error 2002 on mysql login
I have mysql installed and running fedora 16.
[root@me /]# rpm -qa | grep mysql
[root@me /]# mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none): ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- Join Date
- Oct 2007
- Tucson AZ
Use the command below to see if it is running:
ps -e | grep my
Check the link below:
MySQL :: Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ps -e | grep my. Does not give any results.
True /var/lib/mysql/mysql.sock does not exist, but to the link above, the point to the path /var/lib/mysql is empty. i followed the link changed permissions and edited the file /etc/my.cnf, to add the lines given in the link. it has still not worked.
- Join Date
- Apr 2012
- Virginia, USA
Thanks it worked, i checked the mysqld service and started it.
#service mysqld statusCode:
#service mysqld start
#mysql -u root -p