Resolution to Mac OSX Update Which Causes PHP and MySQL To Stop Talking

Upon restarting from the lastest couple of automatic Leopard updates from Apple PHP could no longer connect to MySQL, giving the error:

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

What this means is it can't find mysql.sock OR it's not finding the database ip you specified in your connection code. So, try this first:
- replace "localhost" with "127.0.0.1" in your PHP

If that doesn't work, you probably need to create a virtual linked file from /var/mysql/mysql.sock to /private/tmp/mysql.sock (where you are bound to have one):

1. Fire up the Terminal application
2. Type:
cd /var
ls

3. If you DO NOT have a mysql directory already in here type:
sudo mkdir mysql

4. Do the important bit:
cd mysql
sudo ln -s /private/tmp/mysql.sock mysql.sock

5. If you get a mysql_connect Access denied for user type error subsequently, try:
GRANT ALL PRIVILEGES ON database_name TO user@host IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Comments

Post a Comment

Popular posts from this blog

Installing LAMP Apache/MySQL/PHP on Chromebook/Chromebox

Google Chromebook / Chromeboxes make excellent mini web-servers for development/testing/office use, or for using in kiosks / taking to tradeshows etc. Amazingly there is enough space on them for a reasonable sized web-site and database, and the oomph is comparable to a medium-size virtual server from one of the popular web-hosts. Firstly, get your Chromebox / Chromebook running Linux by installing Chrubuntu: Follow this guide here ->  http://webonaut.blogspot.co.uk/2012/11/installing-ubuntu-linux-on-your.html Bring up a Terminal. (Remember, your user is called "user" with password "user" by default). Type: sudo apt-get install tasksel sudo  tasksel Use the cursors to select "LAMP" (dom't deselect the default options or you may take away your desktop!) then hit return. (BTW: Now is a good time to try Edubuntu as it is cool, and openssh-server is useful too ;) Give the mysql root user a password when prompted. Test it out! Try this
Read more

Installing Ubuntu Linux on your ChromeBox/ChromeBook

NOTE: THIS WILL WIPE YOUR BOX! (but you only store stuff in the cloud, right?) Switch the developer switch on your machine (it's in a little hole on the back of the Chromebox. Use a paper clip and BE CAREFUL - it's not a strong switch) Switch the machine on. The unhappy face means you are in developer mode (sweet!). You can wait (and put up with the loud double-beep) or press Ctrl+D to continue Log into ChromeOS as normal Open a browser window and press Ctrl+Alt+T to bring up the mildly rubbish in-browser crosh terminal type "shell" to get a decent bash shell type "sudo bash" to get an even better root shell! type " chromeos-firmwareupdate --mode=todev " to update and properly enter developer mode Note: switch back later by typing the reverse into an Ubuntu shell, e.g. " chromeos-firmwareupdate --mode=normal " type "reboot" and follow steps 4,5 and 6 again The next steps are a bit convoluted, but here's a handy
Read more

Changing your Mac OSX Terminal's default text editor

For just this session, simply type: export EDITOR=emacs (or replace emacs with vim , nano or whatever) Personally, I like to use emacs on servers, but on my Mac TextWrangler is way more helpful. One of the great things about TextWrangler is that you can get it to magically pop edit requests out of the Terminal simply by installing it and typing "edit". To make all other programs use this method try: export EDITOR="edit -w" For a more permanent fix, add the same line to your .bashrc file. If you've not already got one of those, type: edit ~/.bashrc (The one exception is git, which you'll need to configure thus:) git config core.editor "edit -w"
Read more