The phpmyadmin configuration file is in the config.default.php under Libraries , the main configuration is as follows:
In general, if you have MySQL and phpMyAdmin on the same server, the hostname is directly localhost
The code is as follows
Copy Code
$cfg [' Servers '] [$i] [' host '] = ' localh
establishing an an. htaccess file:
authuserfile/srv/www/domain.com/.htpasswd
Authgroupfile/dev/null
AuthName Adminauthtype Basic
Order Deny,allow
Deny from all
Allow from localhost
Require user admin
Satisfy any
The above code snippet makes the assumption that the path/srv/www/domain.com is not protected so the. htaccess file is outside the Web path (for example, DocumentRoot in Apache is/srv/www/domain.com/html). To create a/srv/www/dom
caiknife 17 9月 21 10:52 phpinfo.phplrwxrwxrwx 1 caiknife caiknife 21 9月 22 10:18 phpmyadmin -> /usr/share/phpmyadminlrwxrwxrwx 1 caiknife caiknife 21 10月 12 18:27 pma -> /usr/share/phpmyadmin
Then direct access to the subdirectory is possible.
Update
According to the main idea, I made the following configuration:
location /p { root /usr/share/phpmyadmin;
People who have used phpMyAdmin know that in phpMyAdmin, the use of file config.inc.php to save the user name and password, when the need to change the user or user password changes, you must modify the config.inc.php file, and then upload, especially inconvenient. Sometimes, in order to modify the MySQL library or table to use the root account, if at this time the other site's automatic search system index
People who have used phpMyAdmin know that in phpMyAdmin, the file config. inc. php saves the user name and password. you must modify the config. inc. php files, and then upload them again, which is especially inconvenient. More often, you can use the root account to modify the MYSQL database or table.
People who have used phpMyAdmin know that in
Under ubuntu open phpmyadmin 404 error after installing phpmyadmin open localhost/phpmyadmin 404 error, google after looking for a solution, in the ubuntu http://www.noob2geek.com/linux to open phpmyadmin 404 error
After phpmyadmin
file:
AuthUserFile /srv/www/domain.com/.htpasswd
AuthGroupFile /dev/null
AuthName adminAuthType basic
Order Deny,Allow
Deny From All
Allow From localhost
require user admin
satisfy any
The above code snippet makes the assumption that the path/srv/www/domain.com is not protected so the. htaccess file is outside the Web path (for example, DocumentRoot in Apache is/srv/www/domain.com/html). To create a/srv
] ['host'] = 'localhost'; (the default value is usually used, and there are exceptions. you do not need to modify the value)
6. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
Debug config in your own machine. if you use cookies in the network space, now we have added the Web site before, and then modify it to a cookie. we recommend that you use cookies here.
7. find $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, genera
['blowfish _ secret'] = ''; and $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';, if the value of $ cfg ['servers'] [$ I] ['auth _ type'] is as cookie as we saw earlier, therefore, we must write a string of characters in the quotation marks of $ cfg ['blowfish _ secret'] = ''. you can regard it as an identity verification code. For example, $ cfg ['blowfish _ secret'] = 'sunec '. Save the disk and exit.
So far, the installation and configuration of phpm
['servers'] [$ I] ['auth _ type'] is as cookie as we saw earlier, therefore, we must write a string of characters in the quotation marks of $ cfg ['blowfish _ secret'] = ''. you can regard it as an identity verification code. For example, $ cfg ['blowfish _ secret'] = 'sunec '. Save the disk and exit.
So far, the installation and configuration of phpmyadmin is over. enter the browser and enter http: // localho
This article describes how to install and configure phpMyAdmin. For more information, see phpmyadmin.
Phpmyadmin is a mysql management tool. after installing this tool, you can directly manage mysql data in the form of web, instead of executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. next I
To put it simply, phpmyadmin is a mysql management tool. After installing this tool, you can directly manage mysql Data on the web without executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. Next I will explain how to install the tool. download phpmyadmin from the Internet and decompress it to the accessible web directory (if it is a virt
Libraries directory, locate the following, and then follow the instructions to configure it.
1. Visit the website
$cfg [' pmaabsoluteuri '] = '; Fill in PhpMyAdmin's access URL here.
2. MySQL Host Information
$cfg [' Servers '] [$i] [' host '] = ' localhost '; MySQL hostname or IP address
Fill in the IP address of localhost or MySQL server, and if MySQL and the phpMyAd
clear about the file permissions indicated by 777, refer to the CHMOD command.
How to install phpMyAdmin-MySQL Database Management
Use the interface Manager:
System-> System Management-> New Software Package Manager-> Search phpMyAdmin-> right-click to mark installation.
Or directly use a command:
sudo apt-get install phpmyadmin
Installation starts.
If you encounter the following error during Remote Access to PHPMyAdmin: Forsecurityreasons, thisURLisonlyaccesibleusinglocalhost (127.0.0.1) asthehostname or timeout. Check your Apache
If you encounter the following error during Remote Access to PHPMyAdmin: For security reasons, this URL is only accesible using localhost (127.0.0.1) as the hostname or Access to
Today, we started using ubuntu kylin, which is also the Kirin linux. In fact, all the versions are the same. Let's first talk about the many online problems related to phpmyadmin which cannot be used in ubuntu, right, I will only add the new version.Note that you 'd better configure phpmyadmin after installing php5 apache2 and mysql,Here is a brief introduction to the specific installation.Use apt-g
Profile
# VI Config.inc.php3
Find the following section
$cfgServers [1][' host '] = ' localhost '; MySQL's hostname
$cfgServers [1][' port '] = '; MySQL's port blank indicates a preset 3306
$cfgServers [1][' adv_auth '] = true; Whether to adopt advanced function
$cfgServers [1][' stduser '] = ' root '; MySQL's manager
$cfgServers [1][' stdpass '] = ' 123456 '; MySQL Manager's password
I use root as the manager, the password is 123456 y
mysql|window| Graphics phpMyAdmin is a web-based MySQL graphics management tool.
This article only discusses how to install phpMyAdmin under Windows NT 4.0 or Windows 2000, IIS 4.0, PHP3, and MySQL.
This article uses phpmyadmin_2.0.5.tar.gz.
First, software download
You can download to the latest version from the following sites:
http://www.phpwizard.net/phpMyAdmin
such as: $cfg [' pmaabsoluteuri '] = ' http://ip/phpmyadmin/'; or $cfg[' pmaabsoluteuri '] = ' http://ip:8899 ' (write out the absolute URL of the access phpMyAdmin)
There are also these changes in place:
$cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exceptions)
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; authentic
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.