Post

Visualizzazione dei post da dicembre, 2010

#2002 - Il server non risponde (o il socket del server locale MySQL non è correttamente configurato)

Immagine
Messaggio di MySQL: #2002 - Il server non risponde (o il socket del server locale MySQL non è correttamente configurato)  Editare etc/php.ini nelle linee che seguono ; Default socket name for local MySQL connects.  If empty, uses the built-in ; MySQL defaults. ; http://php.net/mysql.default-socket mysql.default_socket = /tmp/mysql.sock

Uninstalling MySQL on Mac OS X Leopard

To uninstall MySQL and completely remove it (including all databases) from your Mac do the following: Use mysqldump to backup your databases to text files! Stop the database server sudo rm /usr/local/mysql sudo rm -rf /usr/local/mysql* sudo rm -rf /Library/StartupItems/MySQLCOM sudo rm -rf /Library/PreferencePanes/My* edit /etc/hostconfig and remove the line MYSQLCOM=-YES- rm -rf ~/Library/PreferencePanes/My* sudo rm -rf /Library/Receipts/mysql* sudo rm -rf /Library/Receipts/MySQL* The last two lines are particularly important as otherwise, you can't install an older version of MySQL even though you think that you've completely deleted the newer version!

Installing MySQL 5.5 on OS X 10.6 (Snow Leopard)

I was successfully able to install MySQL 5.5 on OS X 10.6 according to the following steps. Download MySQL Community Server 5.5.8 for Mac OS X. I chose to download Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive . The DMG archive is nice as it has a startup package that installs a MySQL control panel (although it dosn’t work from the start without tweaking). Open the DMG archive and execute the mysql-5.5.8-osx10.6-x86_64.pkg. I had no issues with installation although the ReadMe.txt file suggests that problems may occur. After successful installation, execute the MySQLStartupItem.pkg. This will install the MySQL Startup startup items. This should complete successfully. Next, install the MySQL preferences pane by double-clicking the MySQL.prefPane item in the mounted drive. This will install the MySQL preferences item, although MySQL cannot yet be started through it. First, the mysql.server file must be edited by hand to specify the location of the base directory. At a te