Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to configure and use phpMyAdmin on Mac OS X. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

How to configure and use phpMyAdmin on Mac OS X: first download mac;, then put the source code into the configuration file of Apache, and modify the access permission of phpmyadmin source code; finally, configure [httpd.conf] of Apache.

The method of configuring and using phpMyAdmin on Mac OS X:

1. Download Mac OS X

two。 Open "web share" in "Settings" to open the Apache that comes with Mac, or restart Apache through sudo apachectl restart.

3. Put the source code in the configuration file of Apache-httpd.cnf in the directory specified by the DocumentRoot entry, and open the module of php5

# LoadModule php5_module libexec/apache2/libphp5.so

Change to:

LoadModule php5_module libexec/apache2/libphp5.so

4. Modify the access permissions of the phpmyadmin source code under DocumentRoot.

Chmod-R 755 phpMyAdmin-4.4.1/

5. The httpd.conf for configuring Apache is as follows:

Options Indexes FollowSymLinks MultiViewsAllowOverride allOrder Deny,AllowAllow from all

6. Under the phpMyAdmin-4.4.1 directory, save the copy config.example.inc.php as: config.inc.php, and modify some of its contents:

$cfg ['blowfish_secret'] =''; / * YOU MUST FILL IN THIS FOR COOKIE AUTH! * / * * Servers configuration*/$i = 0; / * * First server*/$i++;/* Authentication type * / $cfg ['Servers'] [$I] [' user'] = 'root'; / / mysql username here$cfg [' Servers'] [$I] ['password'] =' xxxx'; / / mysql password here$cfg ['Servers'] [$I] [' auth_type'] = 'config' / * Server parameters * / $cfg ['Servers'] [$] [' host'] = 'localhost';$cfg [' Servers'] [$] ['connect_type'] =' tcp';$cfg ['Servers'] [$I] [' compress'] = false;$cfg ['Servers'] [$I] [' AllowNoPassword'] = false

7. It's almost done! At this point, if you restart Apache via sudo apachectl restart and access it through a network address, you may still be prompted for an error:

Mysql said: cannot connect: invalid settings.

This may be because phpmyadmin uses / var/mysql/mysql.sock by default to connect to mysqld.

8. Create a link to the real sock for the default sock directory of phpmyadmin.

8.1 sudo mkdir / var/mysql/8.2 sudo ln-s / tmp/mysql.sock / var/mysql/mysql.sock so much for sharing the methods of configuring and using phpMyAdmin on Mac OS X. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.