Installation and configuration of phpMyAdmin

Source: Internet
Author: User

phpMyAdmin is a tool for managing MySQL in a Web interface. If the Rootdocument directory is/var/www/html, the phpMyAdmin is installed in the directory and can be accessed through http://IP:port/phpmyadmin. But to be safe, to avoid cyber-bots attacking, we typically rename that directory to a different name. Next we'll look at the detailed configuration:

  1. Unpack The TAR package:

    #tar-ZVXF phpmyadmin-4.0.8-all-languages.tar.gz-c/var/www/html

  2. Rename the Directory

    #mv/var/www/html/phpmyadmin/var/www/html/mysqladmin

  3. Modifying a configuration file

    #cd/var/www/html/mysqladmin/libraries

    #vim config.default.php

    Modify the following lines:

    $cfg [' pmaabsoluteuri '] = ' http://192.168.1.145/mysqladmin ';

    This is the access address after you rename the directory name

    $cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';

    If you are debugging on your own machine, the following parameters are config; If you are debugging over the network, the following parameters are cookies. Here I modify the cookie.

    $cfg [' Servers '] [$i] [' user '] = ' root ';

    Here is the MySQL user name

    $cfg [' Servers '] [$i] [' password '] = ';

Here's the MySQL password.

$cfg [' defaultlang '] = ' zh ';

This is the default language


Then we can manage the MySQL database through http://IP:port/mysqladmin/.

This article is from the "Operational Work Notes" blog, make sure to keep this source http://yyyummy.blog.51cto.com/8842100/1439303

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.