MySQL : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'...
extract characters between two commas?
Why do we use polarized capacitors?
What are the advantages and disadvantages of running one shots compared to campaigns?
What does "enim et" mean?
Typesetting a double Over Dot on top of a symbol
Patience, young "Padovan"
Can the Produce Flame cantrip be used to grapple, or as an unarmed strike, in the right circumstances?
Does the average primeness of natural numbers tend to zero?
COUNT(*) or MAX(id) - which is faster?
Ideas for 3rd eye abilities
What does 'script /dev/null' do?
New order #4: World
Denied boarding due to overcrowding, Sparpreis ticket. What are my rights?
How to move the player while also allowing forces to affect it
How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)
Why was the "bread communication" in the arena of Catching Fire left out in the movie?
Are objects structures and/or vice versa?
What happens when a metallic dragon and a chromatic dragon mate?
Symmetry in quantum mechanics
Copycat chess is back
What is it called when one voice type sings a 'solo'?
Where else does the Shulchan Aruch quote an authority by name?
Is Social Media Science Fiction?
How can I fix this gap between bookcases I made?
MySQL : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [on hold]
Where can I find the MySQL socket on Snow Leopard?Normal permissions for running mysql Error starting MySQL server (error 2002)MySQL ERROR 2002 (HY000) on CentOS 5How to access MySQL when I delete the root user on openSUSE 11?Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories)How to completely shut MySQL server down on Ubuntu serverUnable to move MySQL data to external driveHow to connect to MySQL running on XAMPP through WSL terminalMySQL on Lightsail repeatedly needs restarting
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
My MySQL got an error after a long time of working.
When I ues command mysql -p
, I get an error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the my.cnf
,find ALL empty,only one line left:
!includedir /etc/mysql/conf.d/
Then I copy all lines in mysqld.cnf
into my.conf
,and want to restart mysqldb
. And here are my commands :
>>root@ICAS-2:/etc/init.d# mysql restart
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the /var/run
,but finding no mysql
folder
Then I want to find where is mysql.sock with command find but got an error :
>>root@ICAS-2:/var/run# find / -name mysql.sock
>>find: ‘/run/user/1000/gvfs’: Permission denied
When I want to use mysqld_safe
to recover the configuration , I find there is no mysqld_safe
under /usr/bin/
.
I know this questions has been asked more than thousands times, but I do need some help on my mysql database. This time my MySQL gets a big challenge.
linux ubuntu mysql database
New contributor
put on hold as too broad by DavidPostill♦ 2 days ago
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
My MySQL got an error after a long time of working.
When I ues command mysql -p
, I get an error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the my.cnf
,find ALL empty,only one line left:
!includedir /etc/mysql/conf.d/
Then I copy all lines in mysqld.cnf
into my.conf
,and want to restart mysqldb
. And here are my commands :
>>root@ICAS-2:/etc/init.d# mysql restart
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the /var/run
,but finding no mysql
folder
Then I want to find where is mysql.sock with command find but got an error :
>>root@ICAS-2:/var/run# find / -name mysql.sock
>>find: ‘/run/user/1000/gvfs’: Permission denied
When I want to use mysqld_safe
to recover the configuration , I find there is no mysqld_safe
under /usr/bin/
.
I know this questions has been asked more than thousands times, but I do need some help on my mysql database. This time my MySQL gets a big challenge.
linux ubuntu mysql database
New contributor
put on hold as too broad by DavidPostill♦ 2 days ago
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
finally I reinstall MySQL : firstly , apt-get remove mysql-*; then apt-get install mysql-server .Thought I had to reinstall a lot packages related to the mysql , But the MySQL finally works.
– Lee Jack
23 hours ago
add a comment |
My MySQL got an error after a long time of working.
When I ues command mysql -p
, I get an error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the my.cnf
,find ALL empty,only one line left:
!includedir /etc/mysql/conf.d/
Then I copy all lines in mysqld.cnf
into my.conf
,and want to restart mysqldb
. And here are my commands :
>>root@ICAS-2:/etc/init.d# mysql restart
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the /var/run
,but finding no mysql
folder
Then I want to find where is mysql.sock with command find but got an error :
>>root@ICAS-2:/var/run# find / -name mysql.sock
>>find: ‘/run/user/1000/gvfs’: Permission denied
When I want to use mysqld_safe
to recover the configuration , I find there is no mysqld_safe
under /usr/bin/
.
I know this questions has been asked more than thousands times, but I do need some help on my mysql database. This time my MySQL gets a big challenge.
linux ubuntu mysql database
New contributor
My MySQL got an error after a long time of working.
When I ues command mysql -p
, I get an error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the my.cnf
,find ALL empty,only one line left:
!includedir /etc/mysql/conf.d/
Then I copy all lines in mysqld.cnf
into my.conf
,and want to restart mysqldb
. And here are my commands :
>>root@ICAS-2:/etc/init.d# mysql restart
>>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Then I check in the /var/run
,but finding no mysql
folder
Then I want to find where is mysql.sock with command find but got an error :
>>root@ICAS-2:/var/run# find / -name mysql.sock
>>find: ‘/run/user/1000/gvfs’: Permission denied
When I want to use mysqld_safe
to recover the configuration , I find there is no mysqld_safe
under /usr/bin/
.
I know this questions has been asked more than thousands times, but I do need some help on my mysql database. This time my MySQL gets a big challenge.
linux ubuntu mysql database
linux ubuntu mysql database
New contributor
New contributor
edited yesterday
Lee Jack
New contributor
asked 2 days ago
Lee JackLee Jack
11
11
New contributor
New contributor
put on hold as too broad by DavidPostill♦ 2 days ago
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as too broad by DavidPostill♦ 2 days ago
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
finally I reinstall MySQL : firstly , apt-get remove mysql-*; then apt-get install mysql-server .Thought I had to reinstall a lot packages related to the mysql , But the MySQL finally works.
– Lee Jack
23 hours ago
add a comment |
finally I reinstall MySQL : firstly , apt-get remove mysql-*; then apt-get install mysql-server .Thought I had to reinstall a lot packages related to the mysql , But the MySQL finally works.
– Lee Jack
23 hours ago
finally I reinstall MySQL : firstly , apt-get remove mysql-*; then apt-get install mysql-server .Thought I had to reinstall a lot packages related to the mysql , But the MySQL finally works.
– Lee Jack
23 hours ago
finally I reinstall MySQL : firstly , apt-get remove mysql-*; then apt-get install mysql-server .Thought I had to reinstall a lot packages related to the mysql , But the MySQL finally works.
– Lee Jack
23 hours ago
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
finally I reinstall MySQL : firstly , apt-get remove mysql-*; then apt-get install mysql-server .Thought I had to reinstall a lot packages related to the mysql , But the MySQL finally works.
– Lee Jack
23 hours ago