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;
}







0















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.










share|improve this question









New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











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


















0















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.










share|improve this question









New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











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














0












0








0


1






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.










share|improve this question









New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












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






share|improve this question









New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited yesterday







Lee Jack













New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









Lee JackLee Jack

11




11




New contributor




Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Lee Jack is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




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



















  • 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










0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

Popular posts from this blog

Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...