Installing phpMyAdmin - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 20

Let's enter the minimum parameters required for a first connection. We assume that
our MySQL server is located on localhost, so we keep this value and all the proposed
values intact, except for the following:

•
•

User for config auth : we enter our user name, marc
Password for config auth : we enter our password, bingo

We then click Add , and we get the New server added message. Now our setup
process knows about one MySQL server, and there are sections of the interface that
enable us to Edit or Delete these server settings:

We can have a look at the generated configuration lines by using the Coniguration/
Display button—then we can analyze these parameters using the explanations given
in The config.inc.php File section later in this chapter.

At this point, this configuration is still just in memory, so we need to save it.
This is done via the Configuration/Save button. It saves config.inc.php in the
special config directory we created previously. This is a directory strictly used for
configuration purposes.

The last step is to copy config.inc.php from the config directory to the top-level
directory—the one that contains index.php . By copying this file, it becomes owned
by the user instead of the web server, ensuring that further modifications are
possible. This copy can be done via FTP or by commands such as:

cd config
cp config.inc.php ..

As a security measure, it's recommended to change the permission on
the config directory—for example, with the chmod ugo-rwx config
command. This is to block any non-authorized writing in this directory.

Other configuration parameters can be set with these web-based setup pages. To do
so, we would have to:

1. Enable read and write access to the config directory
2. Copy the config.inc.php there
3. Ensure that read and write access are provided to this file for the web server
4.

Start the web-based setup tool