|
|
第1行: |
第1行: |
− | {{From|https://help.ubuntu.com/community/phpMyAdmin}} | + | {{From|https://help.ubuntu.com/community/PhpMyAdmin}} |
− | {{Languages|UbuntuHelp:phpMyAdmin}} | + | {{Languages|UbuntuHelp:PhpMyAdmin}} |
− | == Introduction ==
| + | Čia apibūdinkite PhpMyAdmin. |
− | 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 [[UbuntuHelp:ApacheMySQLPHP|ApacheMySQLPHP]] for instructions.
| + | tetsasas |
− | == Installing From Package ==
| + | |
− | Install '''phpMyAdmin''' from the Universe repository see [[UbuntuHelp:InstallingSoftware|InstallingSoftware]] for detailed instructions on using repositories and package managers.
| + | |
− | From console:
| + | |
− | <pre><nowiki>
| + | |
− | sudo apt-get install phpmyadmin
| + | |
− | </nowiki></pre>
| + | |
− | * 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.
| + | |
− | <pre><nowiki>
| + | |
− | Include /etc/phpmyadmin/apache.conf
| + | |
− | </nowiki></pre>
| + | |
− | * If you are using Ubuntu 9.04 (Jaunty), there is no need to modify /etc/apache2/apache2.conf as the package installer already copied the file phpmyadmin.conf into /etc/apache2/conf.d directory. You can also skip the set up step and go directly to http://<hostname>/phpmyadmin and login with the user and password you set up during install.
| + | |
− | Once phpMyAdmin is installed point your browser to [http://localhost/phpmyadmin] to start using it. You should be able to login using any users you've setup in MySQL. If no users have been setup, use ''admin'' with no password to login.
| + | |
− | Should you get a 404 "Not Found" error when you point your browser to the location of phpMyAdmin (such as: [http://localhost/phpmyadmin]) this is likely caused by not checking the 'Apache 2' selection during installation. To redo the installation run the following:
| + | |
− | <pre><nowiki>
| + | |
− | sudo dpkg-reconfigure -plow phpmyadmin
| + | |
− | </nowiki></pre>
| + | |
− | Then select Apache 2 for the webserver you wish to configure.
| + | |
− | If this does not work, then you can do the following to include the phpMyadmin-shipped Apache configuration into Apache:
| + | |
− | <pre><nowiki>
| + | |
− | sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
| + | |
− | sudo /etc/init.d/apache2 reload
| + | |
− | </nowiki></pre>
| + | |
− | == 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 [[UbuntuHelp:Subversion|Subversion]] installed to download the source.
| + | |
− | To install it from source open the console and cd to the www directory using:
| + | |
− | <pre><nowiki>
| + | |
− | cd /var/www/
| + | |
− | </nowiki></pre>
| + | |
− | then download it using svn by writing:
| + | |
− | <pre><nowiki>
| + | |
− | sudo svn checkout https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/tags/STABLE/phpMyAdmin phpMyAdmin
| + | |
− | </nowiki></pre>
| + | |
− | then cd to phpMyAdmin
| + | |
− | <pre><nowiki>
| + | |
− | cd phpMyAdmin
| + | |
− | </nowiki></pre>
| + | |
− | and create the folder config
| + | |
− | <pre><nowiki>
| + | |
− | sudo mkdir config
| + | |
− | </nowiki></pre>
| + | |
− | after that chmod it
| + | |
− | <pre><nowiki>
| + | |
− | sudo chmod o+rw config
| + | |
− | </nowiki></pre>
| + | |
− | 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).
| + | |
− | ----
| + | |
− | [[category:CategorySoftware]]
| + | |
| | | |
| [[category:UbuntuHelp]] | | [[category:UbuntuHelp]] |