|
3682.
|
|
|
In a browser go to <emphasis>http://servername/phpmyadmin</emphasis>, replacing <emphasis role="italic">servername</emphasis> with the server's actual hostname. At the login, page enter <emphasis>root</emphasis> for the <emphasis>username</emphasis>, or another <application>MySQL</application> user, if you have any setup, and enter the <application>MySQL</application> user's password.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:304(para)
|
|
3683.
|
|
|
Once logged in you can reset the <emphasis>root</emphasis> password if needed, create users, create/destroy databases and tables, etc.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:311(para)
|
|
3684.
|
|
|
The configuration files for <application>phpMyAdmin</application> are located in <filename>/etc/phpmyadmin</filename>. The main configuration file is <filename>/etc/phpmyadmin/config.inc.php</filename>. This file contains configuration options that apply globally to <application>phpMyAdmin</application>.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:319(para)
|
|
3685.
|
|
|
To use <application>phpMyAdmin</application> to administer a MySQL database hosted on another server, adjust the following in <filename>/etc/phpmyadmin/config.inc.php</filename>:
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:325(para)
|
|
3686.
|
|
|
$cfg['Servers'][$i]['host'] = 'db_server';
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:330(programlisting)
|
|
3687.
|
|
|
Replace <emphasis role="italic">db_server</emphasis> with the actual remote database server name or IP address. Also, be sure that the <application>phpMyAdmin</application> host has permissions to access the remote database.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:335(para)
|
|
3688.
|
|
|
Once configured, log out of <application>phpMyAdmin</application> and back in, and you should be accessing the new server.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:341(para)
|
|
3689.
|
|
|
The <filename>config.header.inc.php</filename> and <filename>config.footer.inc.php</filename> files are used to add a HTML header and footer to <application>phpMyAdmin</application>.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:345(para)
|
|
3690.
|
|
|
Another important configuration file is <filename>/etc/phpmyadmin/apache.conf</filename>, this file is symlinked to <filename>/etc/apache2/conf-available/phpmyadmin.conf</filename>, and, once enabled, is used to configure <application>Apache2</application> to serve the <application>phpMyAdmin</application> site. The file contains directives for loading <application>PHP</application>, directory permissions, etc. From a terminal type:
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:350(para)
|
|
3691.
|
|
|
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
|
|
|
|
(no translation yet)
|
|
|
|
Located in
serverguide/C/lamp-applications.xml:358(command)
|