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

# Start your mysql server
/etc/init.d/mysql start

3.2
5
Roijan Eskor 105 points

                                    #/usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock

3.2 (5 Votes)
0
0
0

                                    # this saved my ass
# first  you must perform a graceful shutdown of the server from the command line rather than powering off the server
shutdown -h now

# an additional method for getting it back up again when you run into this problem is to move mysql.sock

# to centos
mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak

# to ubuntu
mv /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock.bak

# restart mysql
service mysqld start

0
0
0
9
Loronzo 75 points

                                    service mysql start

0
0
4
6
Janty 100 points

                                    sudo apt-get install mysql-server

4 (6 Votes)
0
Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
digitalocean can't connect to local mysql server through socket "var/run/mysqld/mysqld.sock" dgitalocean can't connect to local mysql server through socket "var/run/mysqld/mysqld.sock" mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Error: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) ubuntu Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")" when trying to connect Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2) docker DBI connect failed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (Mysql2::Error) an't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111) Can't connect to local MySQL server through socket '/var/run /mysqld/mysqld.sock' can't connect to local mysql server through socket '/run/mysqld/mysqld.sock' (2) popsql google cloud can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2) Uh oh :( Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (111) Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqd.sock' (2) MySQL server through socket '/var/run/mysqld/mysqld.sock' can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2) ubuntu 20.04 Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111) Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysql d.sock' (2) "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' k<li how to fix Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") RROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)$ ubuntu Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2) in ubuntu ERROR 2002 (HY000): Can't connect to local MySQL server through socket Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") RROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' can't connect to local mysql server through socket '/run/mysqld/mysqld.sock' (2) an't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' can't connect to mysql local server through socket /var/run/mysqld/mysqld.sock ERROR 2002 (HY000): Can't connect to local MySQL error can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)\ ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ubuntu Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' ubuntu 18.04 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)r ubuntu error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) . Your options are: MySQL server through socket '/var/run/mysqld/mysqld.sock' docker docker "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'" Got error: 2002: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) mac can't connect to local mysql server through socket '/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") docker Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) cant connect to local mysql server through socket /var/run/mysqld/mysqld.sock RROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) valet ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' ( <pre>Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)</pre> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' for azure shell ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' azure cloud shell Can't connect to local MySQL server through socket '/var/run/my sqld/mysqld.sock' (2) error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' uh oh can t connect to local mysql server through socket '/var/run/mysqld/mysqld sock 2 can't connect to local mysql server through socket wsl ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) phpmyadmin can't connect to local mysql server through socket Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' '/var/run/mysqld/mysqld.sock' (2) Can't connect to local MySQL server through socket '/var/run/mysql.in popd/mysqld.sock' (2) Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while installing mysql rror: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) error 2002 can't connect to local mysql through socket Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' ubuntu can't connect to local mysql server through socket can't connect to local mysql server through socket '/tmp/mysql.sock' #<Mysql2::Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)> /var/run/mysqld/mysqld.sock' (2) Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock cannot connect to local mysql server through socket /var/run/mysqld/mysqld.sock can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock' (2) ubuntu mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect Exception Value: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)> Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 Enter password for user root: Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' ( ec2 Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ubuntu error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Got error: 2002: "Can't connect to MySQL server on ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) can't connect to local mysql server through socket '/var/run/mysqld/mysqld.sock'
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source