特殊:Badtitle/NS100:PhpMyAdmin

{{#ifexist: :PhpMyAdmin/zh | | {{#ifexist: PhpMyAdmin/zh | | {{#ifeq: {{#titleparts:PhpMyAdmin|1|-1|}} | zh | | }} }} }} {{#ifeq: {{#titleparts:PhpMyAdmin|1|-1|}} | zh | | }}

Introduction

phpMyAdmin is a very famous MySQL mangement software package. To use it you should install and configure PHP, Apache and php mysql (or mysqli) extension see ApacheMySQLPHP for instructions.

Installing From Package

Install phpMyAdmin from the Universe repository see InstallingSoftware for detailed instructions on using repositories and package managers. From console:

sudo apt-get install phpmyadmin

• If you're using Ubuntu 7.10 (Gutsy) or later select Apache2 from the "Configuring phpmyadmin" dialog box.

To set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf.

Include /etc/phpmyadmin/apache.conf

Once phpMyAdmin is installed point your browser to [1] to start using it. You should be able to login using any users you've setup in MySQL.

Installing from source

You may install phpmyadmin from source. This method circumvents the package manager and you will need to install updates yourself. This is not recommended for a production web server. Also, you'll need to have Subversion installed to download the source. To install it from source open the console and cd to the www directory using:

cd /var/www/

then download it using svn by writing:

sudo svn checkout https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/tags/STABLE/phpMyAdmin phpMyAdmin

then cd to phpMyAdmin

cd phpMyAdmin

and create the folder config

sudo mkdir config

after that chmod it

sudo chmod o+rw config

then open http://localhost/phpMyAdmin/scripts/setup.php and follow the instructions. Note: This guide has been tested on Ubuntu 6.06 (Dapper), Ubuntu 7.10 (Gutsy), and Ubuntu 8.04 (Hardy).

---