Databases Reference
In-Depth Information
Apache is usually run as a service, so we have to ensure that the user under which
the service is running has normal read privileges to access our newly created
directory. The same principle applies to IIS, which uses the IUSR_machinename
user. This user must have read access to the directory. You can adjust permissions in
the Security/permissions tab of the directory's properties.
First Connection Configuration
Here we learn how to prepare and use the configuration file which contains
the parameters to connect to MySQL, and which can be customized as per our
requirements. In this chapter, we will concentrate on the parameters that deal with
connection and authentication. Other parameters will be discussed in the chapters
where the corresponding features are explained.
Before configuring, we can rename the directory phpMyAdmin-2.11.0-
all-languages-utf-8-only to something easier to remember,
like phpMyAdmin , phpmyadmin , admin , or whatever. This way, we
or our users will be able to visit an easily remembered URL to start
phpMyAdmin. We can also use a symbolic link if our server supports
this feature.
Configuration Principles
In versions before 2.8.0, a generic config.inc.php file was included in the
downloaded kit. Since 2.8.0, this file is no longer present in the directory structure.
Note that phpMyAdmin looks for this file in the first level directory—the same one
where index.php is located.
Without a configuration file, phpMyAdmin uses its default settings as defined
in libraries/config.default.php and tries to connect to a MySQL server on
localhost , the same machine where the web server is running, with user root
and password NO . This is the default setup produced by most MySQL installation
procedures, even though it is not really secure. However, if our freshly installed
MySQL server still has the default root account, we will be able to login easily and
see a warning given by phpMyAdmin about such lack of security.
We can verify this fact by opening our browser and visiting http://www.mydomain.
com/phpmyadmin —substituting the proper values for the domain part and the
directory part. If we see phpMyAdmin's home page—as described in Chapter 3—it
means the MySQL server is still configured by default.
 
Search WWH ::




Custom Search