#Phpmyadmin for mac how to#
#Phpmyadmin for mac mac os x#
#Phpmyadmin for mac software#

Text edit the/etc/php.ini file, find the line 'mysql_default_socket = ', change it to 'mysql_default_socket = '/tmp/mysql/mysql.sock' and restart Apache, the problem is solved.When you want to setup PHP development environment on your local PC or Mac, XAMPP is the easy, free and most popular option. One way for you You can modify the socket line in the above file, and replace the '' with='/tmp/mysql.sock', but this only works for phpMyAdmin, and other programs will also prompt mysql errors.ДЄ better way is to modify the settings of php that comes with OS X, so that programs that use PHP and obtain mysql sockets from PHP can run without modification. What should I do? After searching and practicing, I found the key to the problem: Because the socket file created during the initial operation of the new version of MySQL OS X is not the previous directory, it is replaced with the/tmp directory, so many programs cannot be found. Warning: mysql_connect() : Can't connect to local MySQL server through socket'/var/mysql/mysql.sock' The same program will prompt other errors such as: I think the following configuration is fine, as for security issues, you can:ДЄccess Denied: #2002-The server is not responding (or the local MySQL server's socket is not correctly configured). The system comes with a file called, which can be copied as file, and then edit it. The traditional method is to manually generate the file. If you have any questions, you can refer to the official documentДЄ.

Shell> sudo chmod -R g+xw/Library/WebServer/Documents/mysqladmin/libraries Shell> sudo chown -R :_www/Library/WebServer/Documents/mysqladmin/ Correct permissions : Set the correct permissions for the scritps file, the principle is that the owner is you/administrator, the group should be the group that Apache runs, and the group name in Leopard is _Because the group in the permissions of all files is not _www after unzipping just now, so change: Leopard's quarantine 'quarantine' functionДЄ.

#Phpmyadmin for mac how to#

For how to delete quarantien, please refer to my previous blog: One thing to note is that each file after downloading and decompression contains the quarantine information of OS X Leopard. , So I can run it through After completing the above copy, the installation is complete. My choice is to put it in the mysqladmin directory in the Documents of the Apache service. AfterДownloading and decompressing, you have to decide how to run it. I downloaded the latest stable version of the 3.11 zip package ( Personal preference, you can use other formats, the smallest is. you can download it from the official website of : group_id=23067Д«ecause phpMyAdmin is actually written in php, it does not depend on the hardware and operating system, but requires your system to support php. There is a GUI tool to manage MySQL, but this tool is still very popular.ДЎ.

#Phpmyadmin for mac software#

PhpMyAdmin, as one of the most popular and active open software for managing MySQL through the web, is my first choice.

#Phpmyadmin for mac mac os x#

Mac OS X Leopard: Configure Apache, PHP, SQLite, MySQL, and phpMyAdmin (2) Mac OS X Leopard: Configure Apache, PHP, SQLite, MySQL, and phpMyAdmin (1)