Phpmyadmin connects to remote mysql and phpmyadminmysql

Phpmyadmin connects to remote mysql and phpmyadminmysql

Phpmaadmin connects to remote mysql

Procedure

• . Make sure phpmyadmin already exists. If not, go to the terminal.
• Go to the phpmyadmin installation directory, where C: \ wamp \ apps \ phpmyadmin4.1.14,
• 
  
• . Create the config folder; copy. config. inc. php to \ config. inc. php.
• 
  
• Execute http: // localhost/phpmyadmin/setup in the browser, and enter host, user, and password based on your topic.
• 
  
• After saving the. settings, copy. \ config. inc. php to. \ config. inc. php (it is best to back up the original file)

File config. inc. php

<? Php/** Generated configuration file * Generated by: phpMyAdmin 4.1.14 setup script * Date: Wed, 24 Sep 2014 08:15:24 + 0200 * // * Servers configuration */$ I = 0; /* Server: 85 [1] */$ I ++; $ cfg ['servers'] [$ I] ['verbose '] = '85 '; $ cfg ['servers'] [$ I] ['host'] = '2017. 163.25.85 ';/* remote Database Host */$ cfg ['servers'] [$ I] ['Port'] = ''; $ cfg ['servers'] [$ I] ['sockets '] = ''; $ cfg ['servers'] [$ I] ['connect _ type'] = 'tcp '; $ cfg ['ser Vers'] [$ I] ['extension'] = 'mysqli'; $ cfg ['servers'] [$ I] ['nopassword'] = true; $ cfg ['servers'] [$ I] ['auth _ type'] = 'config';/* authentication method, authentication using configuration files */$ cfg ['servers'] [$ I] ['user'] = 'user2 '; /* database account */$ cfg ['servers'] [$ I] ['Password'] = ''; /* the password is blank */, $ cfg ['servers'] [$ I] ['allownopassword'] = true;/* when the account password is blank, add this sentence * // * End of servers configuration */$ cfg ['defaultlang '] = 'en'; $ cfg ['serverdefault'] = 1; $ cfg ['uploaddir'] = ''; $ Cfg ['savedir'] ='';?>

$ Cfg ['servers'] [$ I] ['allownopassword ']

$ Cfg ['servers'] [$ I] ['allownopassword']

Type: boolean

Default value: false

 

Whether to allow logins without a password. the default value of false for this parameter prevents unintended access to aMySQL server with was left with an empty password for root or on which anonymous (blank) user is defined.

How to control a remote mysql database through phpmyadmin on your computer

Database (powerful). Use VC to develop a client program and connect to a remote database.

Step 1: Create a MYSQL "object" and initialize it (required in this document );

Step 2: Connect using the mysql_real_connect function. We do not recommend using mysql_connect (this is an earlier version );

Note: The connection is established through TCP/IP, so the IP address of the server is entered for HOST, for example, 166. 111 .***.***

Second, provide the login name (USER) and password (PWD), and the default connected database name.

When Mysql is built on a linux server, there is naturally a linux Password verification.

I don't know any good method. I just tried to set the username and pwd of the database to be consistent with that of linux, and then I tried to pass
 
How can I use phpmyadmin on my computer to control remote mysql databases?

Mysql provides a set of c api functions that can directly manipulate the database (which is powerful). To develop a client program with VC, you need to connect to a remote database.

Step 1: Create a MYSQL "object" and initialize it (required in this document );

Step 2: Connect using the mysql_real_connect function. We do not recommend using mysql_connect (this is an earlier version );

Note: The connection is established through TCP/IP, so the IP address of the server is entered for HOST, for example, 166. 111 .***.***

Second, provide the login name (USER) and password (PWD), and the default connected database name.

When Mysql is built on a linux server, there is naturally a linux Password verification.

I don't know any good method. I just tried to set the username and pwd of the database to be consistent with that of linux, and then I tried to pass
References: Baidu