/nginx/sites-available/default-ssl
curl-l https:/ /Gist.github.com/frdmn/7853158/raw/sites-available_phpmyadmin-o/usr/local/etc/nginx/sites-available /phpmyadmin Use the Git clone my instance virtual host configuration from Github (including the default 404, 403 pages, and one phpinfo() rewrite). Clone http://git.frd.mn/frdmn/nginx-virtual-host.git/var/www
rm-rf/var /www/.git After cloning, remember to delete the. Git directory so that it won'
Apache. That's all.
7. Test whether PHP is associated with MySQL.Run VI/Server/Apache/htdocs/test. phpThis step is forgotten. You just need to execute it.
8. Click I to enter the insert and edit mode. Then, enter// Phpfans http://www.phpfans.net$ Conn = mysql_connect ("localhost", "root ","");If ($ conn) echo "Else echo "?>
9. Click ESC to return to the VI command line mode. Enter WQ and press Enter.
10. Open http: //
be omitted.
Then execute:SET PASSWORD for ' root ' @ ' localhost ' = old_password (' xqin.com ');The command here is because the password hashing algorithm used by MySQL 4.1 and its later version authentication protocol is incompatible with the old client, and the login with the correct password in phpMyAdmin will also prompt:Client does not support authentication PRotocol requestedby server; Consider upgr
/apachectl-k restart.
If not, it is recommended that you restart Linux again. Execute/server/apache/bin/apachectl start to start Apache. It should be all right.
7. Test if PHP is associated with MySQL.
Executive vi/server/apache/htdocs/test.php
This step has been forgotten. It's all done.
8. Click the I key to enter the insert edit mode. and enter
Phpfans http://www.phpfans.net
$conn = mysql_connect ("localhost", "root", "");
if ($conn) echo "
Su
The PhpMyAdmin advanced features are not all set and some features are not available. To find out why, please click here. ”
After configuring PhpMyAdmin login, the general prompt "PhpMyAdmin advanced features not all set, some features are not available." To find out why, please click here. ”
I'll fix it in the following way
Create a data table
be omitted.
Then execute:SET PASSWORD for ' root ' @ ' localhost ' = old_password (' xqin.com ');The command here is that the password hashing algorithm used in MySQL 4.1 and its later version verification protocol is incompatible with the old client, and the login with the correct password in phpMyAdmin will also prompt:Client does not support authentication protocol requestedby server; Consider upgrading
. If your server requires more than one PHP version, you only need to register "register new PHP versions" multiple times. Press "Change PHP version" to select PHP. 3. Here you can directly edit the php.ini file, you can modify the error log storage directory, you can modify the post, upload file size. 4. Here you can open, close, and add modules. Is it more convenient than manual setup?Installation of phpMyAdminphpMyAdmin is a web-version online MySQL database management tool that allows ad
file and load the PHP module so that it can parse the PHP program# vim/etc/httpd/conf.d/php.confAdd an Line:loadmodule php5_module/usr/lib64/httpd/modules/libphp5.so4. Edit phpMyAdmin configuration file, configure access path and MARIADB user name password and other information# cp/var/www/html/phpmyadmin/libraries/config.default.php \/var/www/html/phpmyadmin/co
phpMyAdmin is the client software used to connect the MySQL database remotely, the user can refer to the following steps
To configure phpMyAdmin software:
Please download the Phpmyadmin.rar file to your local;
Use WinRAR to extract the file and generate a phpmyadmin directory;
Please use software such as Notepad on the local host to edit the file config.inc.ph
directory in IIS php points to E:\php\phpMyAdmin.
6, test phpMyAdmin, done
Open Browser Input http://localhost/php if the following interface appears, the instructions are done.
Login now to manage MySQL database.
In phpMyAdmin, you can perform various operations on the
. getElementById ("username"). value;Var password = document. getElementById ("password"). value; Xhr = new XMLHttpRequest ();Xhr. open ("POST", "http: // localhost/login. php", false, username, password );Xhr. send (null ); Return xhr. status = 200;}Script
Basic Auth-based automatic login solution --
1. the user name and password are directly written in the URL.
Disadvantage: it is not safe enough, and IE does not support it.
2. write a login
/';
B. find $ cfg ['servers'] [$ I] ['host'] = 'localhost'; (the default value is usually used, and there are exceptions. You do not need to modify the value)
C. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
Debug config in your own machine. If you use cookies in the network space, now that we have added the web site before, we recommend that you use cookies.
D. find $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (mysql user nam
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: // localhost/
of LAMP architecture collaborative application-phpMyAdmin
PhpMyAdmin and Wordpress for LAMP applications
PhpMyAdmin logon timeout Solution
Install phpMyAdmin and Adminer in Ubuntu
Implement SSL functions based on LAMP and install phpMyAdmin
---------------------------------
Go deep into phpMyAdmin installation and configuration steps. 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, phpmyadmin is a mysql management tool. after installing phpmyadmin, you can directly manage mysql
Install lamp:
New --> edit --> use the task group to mark the software package --> hook "lamp server" and install it again.
Add the following in Apache. conf:
$ Sudo gedit/etc/apache2/apache2.conf
Add (last added ):
Addtype application/X-httpd-PHP. php. htm. html
Addtype application/X-httpd-PHP-source. PHPs
Add the following content to PhP. ini to make PHP and MySQL work together:
$ Sudo gedit/etc/PhP5/apache2/PHP. ini
Add the following in dynamic extension:
Extension = mysql. So
Extension = Gd.
extension is not installed. No php-mrcrpt extension is available in official sources. Please install epel source before yum install php-mcrypt
2. phpmyadmin cannot be accessed
Phpmyadmin can only be accessed through http: // localhost/phpmyadmin by default. You can modify the corresponding part of/etc/httpd/conf. d/
* Modifications in Linux *Add the following to phpmyadmin. conf:AllowOverride NoneOrder allow, deny# Allow from 127.0.0.1Allow from all
* Modification in Windows *1. Click the "WAMPSERVER" icon in the lower right corner.2. Select "Apache"> "Alias directories"> "http: // localhost/phpmyadmin/"> "Editalias"3. After phpmyadmin
browse and open the management login page of phpMyAdmin. You can also open the URL http: // localhost/phpmyadmin/index. php In vps. [MYSQL Default Administrator Account: root Password: name of your host room member]
2. Create a database. For example, in the right window of php MyAdmin, enter the Database Name and click Create.
~
For example, here we create a d
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