Stack Overflow
Stack Overflow

Questions tagged [mysql-error-2002]

Can't connect to local MySQL server through socket

Can't connect to local MySQL server through socket

54 questions
1
vote
1 answer

Cannot connect to Mysql Socket

I have an AWS server. I have mysql running and it connects just find to my RDS server, but I want a local mysql instance running. When I type mysql into the command prompt I get the following. ERROR 2002 (HY000): Can't connect to local MySQL…
user839884
  • 11
  • 1
  • 2
1
vote
1 answer

Actions to restore env.file in Laravel

I am new in programming. I mistakenly changed my .env file from production server into the local .env file in my Laravel project. I created a new env file, filled the data about DB, made php artisan key:generate, started the commands: php artisan…
Alisa
  • 23
  • 3
1
vote
1 answer

how to use lampp with external mysql

I have installed normal mysql with apt-get and now I need to connect it with my lampp server, when is lampp booting it echo "Another MySQL deamon already running" (of course - thats right), but when I open phpmyadmin it gives me an message 2002 -…
yety
  • 611
  • 2
  • 14
  • 26
1
vote
1 answer

Ubuntu 17.10 - ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I've seen similar questions being asked on stack overflow but none of them seem to solve my issue properly. I have recently upgraded my system from Ubuntu 16.04 to Ubuntu 17.10 . Since then, I've been experiencing a problem with mysql where I'm not…
vamshi krishna Anandesi
  • 25
  • 1
  • 8
1
vote
1 answer

MySQL remote database server connect failed

I am trying to connect Cakephp 3.x remote database server from my local machine. But it showing below error Error: SQLSTATE[HY000] [2002] No route to host My local database configuration in app.php is look like - 'Datasources' => [ 'default'…
Sumon Sarker
  • 2,375
  • 1
  • 19
  • 32
1
vote
1 answer

phpmyadmin 2002 Error, mysql.sock.lock seems to have taken the place of mysql.sock file

Hi I just downloaded mysql 5.7.13 for OS X 10.11, and I am having issue getting phpmyadmin to connect with it. I was able to fully install mysql, turn on the mysql server and set the root password. I then went to set up phpmyadmin which i was able…
Dave Kin
  • 11
  • 4
1
vote
0 answers

Getting "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock'" (2) mysql on El Capitan

I know that this question has already been submitted many times. Yet, all the solutions seem to be a bit out-of-date or not in line with the current version of mysql. So, I've tried to install Mysql 5.7.11 on El Capitan via Homebrew. When I…
Stefano Bommarito
  • 11
  • 1
1
vote
3 answers

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (error 2002)

I know this is a question many times asked, but I can't seem to find any solution out of the other topics. what I've tried: reinstalling mysql-server (so not the client) chown mysql:mysql /var/lib/mysql checked out my.cnf where everything seems…
Saar Tranchet
  • 11
  • 1
  • 3
1
vote
1 answer

Xampp mysql error #2002

anyone can help me, how to fix this when i open localhost/phpmyadmin/ it says Error MySQL said: Documentation #2002 - No connection could be made because the target machine actively refused it. The server is not responding (or the local…
Mumus
  • 13
  • 5
1
vote
1 answer

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)' on FreeBSD

Hello guy's i have this problem : root@Myname:~ # mysql -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38) root@Myname:~ # chown -R mysql /var/db/mysql chown: mysql: illegal user…
FighterWks
  • 17
  • 2
  • 7
1
vote
4 answers

#2002 Cannot log in to the MySQL server

I am working on a windows server 2012 and trying to get PHPMyAdmin working. I cant get it to connect to the MySQL by root user or a non root user. I have searched and searched all over google. everywhere I saw it said to set allowroot and change…
Shredder2500
  • 1,035
  • 2
  • 11
  • 25
1
vote
1 answer

Mysql weird connection problem

I've a weird problem. I've mysql 5.1 installed on my ubuntu 9.04. I've used it a long time (say 3 month) and everything was going right. Until i faced this really weird problem. When i want to connect to a random database i get this message: ERROR…
santiagobasulto
  • 10,542
  • 9
  • 61
  • 85
1
vote
1 answer

MySQL won't start in CentOS 5.5 and the "ERROR 2002"

I would like to ask a help for the problem I encountered. My mysql server suddenly stopped after I install php-soap. I don't know why it get stopped actually... Since it's stopped I tried to start it by typing the line: # /etc/init.d/mysqld…
Mir
  • 184
  • 1
  • 1
  • 10
1
vote
1 answer

MySQL Error 2002 - Can't connect through socket '/tmp/mysql.sock' on 64-bit, with a botched 32-bit uninstall complicating things

I'm new to Macs/MySQL, and am struggling to get MySQL working. I'm on 64-bit Lion, and first attempted to install the 32-bit MySQL from the command line. I then attempted to remove it and replace it with the 64-bit DMG, but the results of mysql -V…
Matthew Du Pont
  • 187
  • 1
  • 1
  • 13
0
votes
1 answer

MySQL hanged after LoadTest. Error 2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

I had a project running on my server. I ran "LoadTest" and it hanged my MySQL server. Now I cannot connect to the server via UI. If I try restart via command line, then also getting error "Can't connect to local MySQL server through socket…
aayushi
  • 151
  • 5
  • 17
1
2
3 4