Home > Cannot Connect > Cannot Connect Mysql.sock

Cannot Connect Mysql.sock

See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information. Sign Up Log In submit Tutorials Questions Projects Meetups Main Site logo-horizontal DigitalOcean Community Menu Tutorials Questions Projects Meetups Main Site Sign Up Log In submit View All Results By: decaobr What are 'hacker fares' at a flight search-engine? [email protected]:~/pycodes/python-scraping/chapter5$ **mysqladmin -p variables|grep socket** Enter password: | socket | ***/var/run/mysqld/mysqld.sock*** | [email protected]:~/pycodes/python-scraping/chapter5$***ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock*** [email protected]:~/pycodes/python-scraping/chapter5$ ll /tmp/mysql.sock lrwxrwxrwx 1 zack zack 27 11月 29 13:08 /tmp/mysql.sock -> /var/run/mysqld/mysqld.sock= share|improve http://electrictricycle.net/cannot-connect/cannot-connect-to-mysql-server-through-socket-var-lib-mysql-mysql-sock.html

This issue reproduces fairly reliably, however it doesn't appear to be 100%, because every once in a blue moon, my test suite does in fact run without hitting this error. See this page for more details http://dev.mysql.com/doc/workbench/en/wb-manage-db-connections.html According to this other page a socket file is used even if you specify localhost. However, for a variety of reasons, many MySQL installations place this socket file somewhere else like /var/lib/mysql/mysql.sock. Sorry, this must be really basic stuff for everyone else but it's causing me a lot of grief and if I can just get through this I can actually do some

Just edit your post and add the explanation. –RLF Jul 13 at 21:20 Visit the help centre, take the tour and check out the "help us to help you" Loading... I tried the following: Code: sudo apt-get install mysql-server Thinking that I might not have the server installed (I've done worse), and got the following in reply: Code: [email protected]:~$ sudo apt-get Loading...

A good link for this process of reinstalling: http://www.coolestguyplanettech.com/how-to-install-php-mysql-apache-on-os-x-10-6/ share|improve this answer answered Jul 3 '12 at 4:08 tandy 6771217 add a comment| up vote 0 down vote I've deleted mysql.sock If I could find where the error file is I would post it here, but I don't have a clue where it would be inside the os I found addition help Manual connection …. I'm a real newbie to all this so would be grateful for answers in words of one syllable and sorry if this is obvious to everyone else, but most comments are

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock' (2) in /srv/disk2/833826/www/mycprogamsolution.co.cc/Connections/check_mag.php on line 9 Fatal error: Can't connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock' (2) in Putting the rights on it didn't work at all. Use ps aux | grep mysql to check if the PID is changing. http://dba.stackexchange.com/questions/98467/how-to-solve-cant-connect-to-local-mysql-server-through-socket-error Storage of a material that passes through non-living matter What are 'hacker fares' at a flight search-engine?

This is something specifically to do with the Python client since all other access through the socket works fine, including other access from Python. –Old Pro May 11 '13 at 19:17 What do we call the initial text of the terminal? Sign in Share More Report Need to report the video? Add to Want to watch this again later?

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed http://www.tech-recipes.com/rx/762/solve-cant-connect-to-local-mysql-server-through-socket-tmpmysqlsock/ Is it possible to bleed brakes without using floor jack? Probability of All Combinations of Given Events My manager said I spend too much time on Stack Exchange. Anonymous Should I be able to connect to MySQL over my LAN?

So I started mysql service with the command: /etc/init.d/mysqld start So.. click site mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') -> WHERE User='root'; mysql> FLUSH PRIVILEGES; share|improve this answer edited Apr 4 '14 at 1:40 answered Apr 4 '14 at 1:32 preynolds 530612 add a comment| As @RLF says, your answer is a bit bare. –Vérace Jul 14 at 4:00 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up Is there a wage gap between smokers and non-smokers?

mysql.sock not exist in /var/lib/mysql/0Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock Hot Network Questions What are 'hacker fares' at a flight search-engine? The nth numerator Does the "bat wing" aircraft paint design have a proper name? But I haven't created any database yet!??? news Loading...

Those logs are from the 27th of April.. 2013. –yoonix Sep 15 '14 at 2:32 The 644 permissions you mention are not enough to know whether MySQL can write The first thing you can do is execute the following to see if there are any config errors: /usr/sbin/mysqld --verbose --help 1>/dev/null I did have one error that showed up: 160816 Kathryn Brewer that was mean.

Published on May 25, 2012ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) http://plus84ga.blogspot.com/2012/05/...

Reply Log In to Comment 0 fullyfaltu601 October 28, 2015 [deleted] Reply Log In to Comment 0 derek_tgm February 9, 2016 Killed 5 hours trying to figure out what causes the Ivan Ignacio Lopez Ambrocio 2,331 views 1:25 MySQL Tutorial - Duration: 41:10. more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Tango Icons Tango Desktop Project.

InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. Join Date Feb 2008 Location Swansea Beans 144 DistroUbuntu 9.04 Jaunty Jackalope Re: MySQL ERROR 2002 (HY000): Can't connect to local... The [client] section did the trick after some really hair pulling days trying to make MySQL 5.6.17 work. More about the author Make sure /tmp has the correct access rights in the OS.

Verify using 'ps -ef | grep mysql'. Loading...