Describe how to configure phpMyAdmin. Starting from version 1.4.2 for the $ login servers array, phpMyAdmin supports managing multiple MySQL-servers. Therefore, the $ login servers array is added to store login information of different servers. We are
$ Worker servers array
PhpMyAdmin supports managing multiple MySQL-servers from version 1.4.2. Therefore, the $
PhpMyAdmin 3.x version requires more than php5.2, mysql5.0 above,phpMyAdmin is a MySQL management tool that manages MySQL directly from the web1: Upload phpmyadmin-3.4.5-all-languages.tar.gz2: Unzip # tar ZXVF phpmyadmin-3.4.5-all-languages.tar.gz3: Rename # mv Phpmyadmin-3.
--enable-module=shared--with-pcre=/opt/local/pcre-8.41 -- with-apr-util=/opt/local/apr-util-1.6. 0 --with-apr=/opt/local/apr-1.6. 2 #ServerName localhost: Cancel CommentConfigure HTTPD.CONF to support PHP7(1) Add library file support(2) Add to homepage index(3) Add File type supportSecond, compile and install PHP5. php source Download, the Web page cannot copy the download link, so first download the file to the native Windows, and then upload to the
phpinfo. php file under the root directory of the website.Phpinfo ();?>Open in a browserHttp: // localhost/phpinfo. phpIf the following information appears, it indicates that php has been configured.Next, we will test the association between php and mysql databases.Create a test. php file under the root directory of the website[Copy to clipboard] CODE:
Php// Php fans station series tutorial [url] http://www.phpfans.net [/url]$ Host="
Macos + apache + php + phpmyadmin integration process. There are two ways to start Apache: enter localhost in the browser, and you can see that the content is Itworks! In the Library WebServerDocument to start Apache
There are two methods:
In this way, enter "http: // localhost" in the browser and you will see the content of "It works !" Is located under "/Librar
configured.Next, we will test the association between php and mysql databases.Create a test. php file in the root directory of the website. The content isCODE:Php$ Host="Localhost";$ User="Root";$ Password="12345";// Change 12345 to your mysql password$ Link=Mysql_connect($ Host,$ User,$ Password);If (!$ Link) Echo";Else echo";Mysql_close();?>Open http: // localhost/test. php In the browserIf the output is
application/X-gzip. GZ. tgz.Add a line after this lineAddtype application/X-httpd-PHP. phpIn this way, Apache can explain the PHP file.Now the configuration is complete.
######## Restart Apache. Click restart #########
Create a phpinfo. php file under the root directory of the website.
Phpinfo ();?>
Open in a browserHttp: // localhost/phpinfo. phpIf the following information appears, it indicates that PHP has been configured.
Next, we will test the a
.
######## Restart Apache. Click restart #########
Create a phpinfo. php file under the root directory of the website.
Phpinfo ();?>
Open in a browserHttp: // localhost/phpinfo. phpIf the following information appears, it indicates that PHP has been configured.
Next, we will test the association between PHP and MySQL databases.Create a test. php file under the root directory of the website[Copy to clipboard]
Code:
// PHP lovers station series tutorial
Introduction: This is the phpMyAdmin user name and password (reprinted) Details page, introduced and PHP, PHP, localhost, user name, password phpMyAdmin user name and password (reprinted) related knowledge, skills, experience, and some PHP source code.
Class = 'pingjiaf' frameborder = '0' src = 'HTTP: // biancheng.dnbc?info/pingjia.php? Id = 357336 'rolling = '
website.
Phpinfo ();?>
Open in a browserHttp: // localhost/phpinfo. phpIf the following information appears, it indicates that PHP has been configured.
Next, we will test the association between PHP and MySQL databases.Create a test. php file in the root directory of the website. The content is Code:
PHP $ Host = "Localhost" ; $ User = "Root" ; $ Password = "12345" ; // Change 12345
virtual root, such as Pharmar's local storage location is D:\Program files\apache\htdocs\phpadmin.
2, find the phpMyAdmin folder in the config.sample.inc.php file, renamed to config.inc.php file. Open for editing with WordPad that supports UTF-8 encoding.
3. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with the default, there are exceptions, you can not modify)
5. Find $cfg [' Serve
phpMyAdmin is a graphical management tool for MySQL that allows you to manage your MySQL database on a web interface, which is not easy and fast.This installation and configuration is under the CentOS 6.4 system, the system has been deployed LNMP environment. For phpMyAdmin installation, you can choose Yum's online installation or download it on its official website and unzip it to your Web server directory
Problem Description:The root password is changed under the console shell and cannot be logged in under Http://localhost/phpmyadmin.Error: #1045-access denied for user ' root ' @ ' localhost ' (using Password:yes)Operation Recurrence:Mysql-u root-p#以前的密码Use MySQL;Update user set Password=password (' new_passwd ') where user = ' root '; #设置你新的密码Flush privileges;And then you can't log in phpMyAdmin.Cause of th
Affected (0.00 sec) mysql> show databases;+--------------------+| Database |+--------------------+| Information_schema || MySQL || Performance_schema || Python || Test |+--------------------+5 rows in Set (0.02 sec) Mysql> 3. OK, the above method is not the best, but it is simple and feasible, Enjoy it!!! 4, Method four: These days with a blank password login mysql, and then modify the MySQL default password, the use of MySQL table has been the problem, hint: Error 1044 (42000): Access denied f
the insert and edit mode.4. InputPhpinfo ();?>5. Click Esc to return to the vi command line. Enter wq and press Enter.The system will save the phpinfo. php file and exit the vi editor.6. Open http: // localhost/phpinfo. php In the browserIf the following page is displayed, php has been installed. If a download dialog box is displayed, go to the page and find a solution.If this interface appears, check that the first step of environment testing is to
installation.
Phpmyadmin settings:
In the installation process, you must select Web server: apache2 or lighttpd, select apache2, press the tab key, and click OK. Then, you must enter the Mysql database Password and the Password of the database's administrative user.
Then create a connection between phpmyadmin and apache2. Take My Example: www contents in/var/www, phpmy
');
Check/var/lib/phpmyadmin/blowfish_secret.inc.php. there is only one sentence.
The code is as follows:
$ Cfg ['blowfish _ secret'] = 'w1hm7axcx5aqvutjvoygdepy ';
The "$ cfg ['blowfish _ secret'] =" statement in phpmyadmin installed in CentOS is in config. inc. php.
The code is as follows:
Vim/usr/share/phpmyadmin/config. inc. php
Find
The code is as
phpMyAdmin is a PHP based on the Web-base schema on the site host. MySQL database management tools that allow administrators to control and manipulate MySQL databases on a web basis. Second, the method: through the phpMyAdmin tool operation database or through the command Way backup data ;Third, the installation process:1. Download phpmyadmin4.3.13.1Wgethttps://files.phpmyadmin.net/
Install phpMyAdmin
The code is as follows
Copy Code
TAR-ZXVF phpmyadmin-2.11.5.1-all-languages.tar.gzsudo mv Phpmyadmin-2.11.5.1-all-languages/usr/local/apache-2.2.8/htdocs/phpmyadmin
Ask to see if you can:
http://host/phpMyAdmin/index
:
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/domain.com/.htpasswd file using the HTPASSWD tool:
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.