If you want to access it using {{ic|http://localhost/phpmyadmin}}, open '/etc/httpd/conf/extra/httpd-phpmyadmin.conf' and change:

−

http://localhost/phpmyadmin/

+

Alias /phpmyadmin/ "/usr/share/webapps/phpMyAdmin/"

−

or

−

http://localhost/phpmyadmin/index.php

−

}}

−

−

Note: 'localhost' is the hostname in your /etc/rc.conf file.

−

−

If you want to access it using:

−

−

{{bc|

−

http://localhost/phpmyadmin

−

}}

−

−

in '/etc/httpd/conf/extra/httpd-phpmyadmin.conf' change:

−

−

{{bc|

−

Alias /phpmyadmin/ "/usr/share/webapps/phpMyAdmin/"

−

}}

−

to

to

+

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"

−

{{bc|

+

You should also read [https://bbs.archlinux.org/viewtopic.php?pid=632500 this thread].

−

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"

−

}}

−

−

You should also read [http://bbs.archlinux.org/viewtopic.php?pid=632500 this thread].

−

If you get the error "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)" then you might want to change "localhost" in /etc/webapps/phpmyadmin/config.inc.php on this line:

+

If you get the error "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)" then you might want to change "localhost" in {{ic|/etc/webapps/phpmyadmin/config.inc.php}} to your hostname:

{{bc|1=

{{bc|1=

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['host'] = 'localhost';

}}

}}

−

−

to your hostname specified in /etc/hosts and /etc/rc.conf under HOSTNAME.

If you would like to use phpmyadmin setup script by calling http://localhost/phpmyadmin/setup you will need to create a config directory that's writeable by the httpd in the /usr/share/webapps/phpmyadmin as follows:

If you would like to use phpmyadmin setup script by calling http://localhost/phpmyadmin/setup you will need to create a config directory that's writeable by the httpd in the /usr/share/webapps/phpmyadmin as follows:

Line 222:

Line 163:

==Lighttpd Configuration==

==Lighttpd Configuration==

−

The php setup for lighttpd is exactly the same as for apache.

+

Configurating Lighttpd is similar to Apache. Make sure Lighttpd is setup to serve PHP files (see [[Lighttpd]]).

You may run into some issues with phpmyadmin telling you "The Configuration File Now Needs A Secret Passphrase" and no matter what you enter, the error is still displayed. Try changing the ownership of the files to the NGINX specified user/group, e.g. nginx...

+

Or if running php-fpm with a separate entry for phpmyadmin, you can overwrite this value in your pool definition (in /etc/php/fpm.d/<pool file>):

While you can enter anything for the blowfish password, you may want to choose a randomly generated string of characters (most likely for security reasons). Here's a handy tool that will do that for you on the web[http://www.question-defense.com/tools/phpmyadmin-blowfish-secret-generator].

While you can enter anything for the blowfish password, you may want to choose a randomly generated string of characters (most likely for security reasons). Here's a handy tool that will do that for you on the web[http://www.question-defense.com/tools/phpmyadmin-blowfish-secret-generator].

When using SSL, you might run into the problem that the links on the pages generated by phpMyAdmin incorrectly start with "http" instead of "https" which may cause errors. To fix this, you can add the following fcgi_param to your SSL-enabled server section (in addition to your usual fastcgi params):

When using SSL, you might run into the problem that the links on the pages generated by phpMyAdmin incorrectly start with "http" instead of "https" which may cause errors. To fix this, you can add the following fcgi_param to your SSL-enabled server section (in addition to your usual fastcgi params):

−

fastcgi_param HTTPS on;

fastcgi_param HTTPS on;

Line 287:

Line 219:

Create a 'controluser', so that phpmyadmin can read from the main mysql database.

Create a 'controluser', so that phpmyadmin can read from the main mysql database.

−

{{bc|mysql -u root -pYOURROOTPASSWORD

+

{{bc|mysql -u root -p YOURROOTPASSWORD

mysql> grant usage on mysql.* to controluser@localhost identified by 'CONTROLPASS';

mysql> grant usage on mysql.* to controluser@localhost identified by 'CONTROLPASS';

Add blowfish_secret passphrase

If you see the following error message at the bottom of the page when you first log in to /phpmyadmin (using a previously setup MySQL username and password) :

ERROR: The configuration file now needs a secret passphrase (blowfish_secret)

You need to add a blowfish password to the phpMyAdmin's config file. Edit /etc/webapps/phpmyadmin/config.inc.php and insert a random blowfish "password" in the line

$cfg['blowfish_secret'] = ; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Go here to get a nicely generated blowfish_secret and paste it between the marks. It should now look something like this:

$cfg['blowfish_secret'] = 'qtdRoGmbc9{8IZr323xYcSN]0s)r$9b_JUnb{~Xz'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

The error should go away if you refresh the phpmyadmin page.

Enabling Configuration Storage (optional)

Now that the basic database server has been setup, it is functional, however by default, extra options such as table linking, change tracking, PDF creation, and bookmarking queries are disabled. You will see a message at the bottom of the main phpMyAdmin page, "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why...", This section addresses how to to enable these extra features.

Note: This example assumes you want to use the username pma as the controluser, and pmapass as the controlpass. These should be changed (the very least, you should change the password!) to something more secure.

In /etc/webapps/phpmyadmin/config.inc.php, uncomment (remove the leading "//"s on) these two lines, and change them to your desired credentials:

creating phpMyAdmin database user

Now to apply the permissions to your controluser, in the SQL tab, make sure to replace all instances of 'pma' and 'pmapass' to the values set in config.inc.php. If you are setting this up for a remote database, then you must also change 'localhost' to the proper host:

If you get the error "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)" then you might want to change "localhost" in /etc/webapps/phpmyadmin/config.inc.php to your hostname:

$cfg['Servers'][$i]['host'] = 'localhost';

If you would like to use phpmyadmin setup script by calling http://localhost/phpmyadmin/setup you will need to create a config directory that's writeable by the httpd in the /usr/share/webapps/phpmyadmin as follows:

While you can enter anything for the blowfish password, you may want to choose a randomly generated string of characters (most likely for security reasons). Here's a handy tool that will do that for you on the web[2].

When using SSL, you might run into the problem that the links on the pages generated by phpMyAdmin incorrectly start with "http" instead of "https" which may cause errors. To fix this, you can add the following fcgi_param to your SSL-enabled server section (in addition to your usual fastcgi params):

fastcgi_param HTTPS on;

Other (Older) information

This page holds a sample 'config.inc.php' file that you can place in the main phpMyAdmin directory so that it immediately starts working

Things you should do first

Create a 'controluser', so that phpmyadmin can read from the main mysql database.