phpMyAdmin configuration and use on Mac OS X

This article mainly records phpmyadmin on Mac OS x configuration and use, to avoid the detours of friends, waste unnecessary time. 1. Download: 2. Open "Web Share" in "settings" to turn on the Apache that comes with your Mac, or you can restart Apache with sudo apachectl restart. 3. The source is placed into the directory specified by the DocumentRoot entry in the Apache configuration file-httpd.cnf, 4. Modify the DocumentRoot phpMyAdmin source access rights. Chmod-r 755 PHPMYADMIN-4.4.1/5. The httpd.conf configuration for Apache is as follows: <directory "/library/webserver/documents/phpmyadmin-4.4.1" >options Indexes FollowSymLinks multiviewsallowoverride Allorder Deny,allowallow from All</directory> 6. Under the phpMyAdmin-4.4.1 directory, copy config.example.inc.php Save as: config.inc.php, and modify some of its contents:

$cfg ['Blowfish_secret'] ="';/*You must FILL in the 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'[$i] ['Host'] ='localhost'; $cfg ['Servers'[$i] ['Connect_type'] ='TCP'; $cfg ['Servers'[$i] ['Compress'] =false; $cfg ['Servers'[$i] ['Allownopassword'] =false;

If you have forgotten the MySQL password, you can modify it by the following methods:

1. Sudo/usr/local/mysql/bin/mysqld_safe--skip-grant-tables-u root &    2.  "sudo/library/startupitems/ mysqlcom/mysqlcom start   can be skipped for unknown reason     3.  then you should is able to log into MySQL as root:    "/usr/local/mysql/bin/mysql-u Root"     4. Modify Password:  "UPDATE mysql.user SET Password = Password (' New-password ') WHERE user = ' root ';"            "FLUSH privileges;"            "quit;"      5.   Try to login:  "/usr/local/mysql/bin/mysql-u root-p"  7 with the new password. Coming soon! At this point, if you restart Apache via sudo apachectl restart, and access through the network address, you may still be prompted with an error: MySQL said:cannot connect:invalid settings.      This may be phpmyadmin by default using/var/mysql/mysql.sock to connect to mysqld. 8. Create a link to the phpMyAdmin default sock directory to connect to the real sock.      8.1  sudo mkdir/var/mysql/     8.2  sudo ln-s/tmp/mysql.sock/var/mysql/my Sql.sock     &nBsp;         9. Finally fuck, a programmer for the product, unexpectedly do not prompt the detailed stack, even the wrong hint of his mother Quickie, How much time is wasted on labor.    Reference: 1. http://stackoverflow.com/questions/13357561/ error-1045-cannot-log-in-to-mysql-server-phpmyadmin2. http://coolestguidesontheplanet.com/ installing-phpmyadmin-on-mac-osx-10-7-lion/ 

phpMyAdmin configuration and use on Mac OS x