How to securely access the database using Mysql web management tools

Using Mysql Web-based management tools to securely access databases methods using Mysql Web-based management tools to securely access databases when using the OA system, many users need to use Mysql Web-based management tools to enter the background database to view data, perform some operations. However, most users directly access the background database after installing the tool, which is not safe. So how can we securely use this tool to access the database? The following describes several methods. Method 1: Set the user name and password to log on to the database. The specific settings are as follows: 1. After installing the mysql database management tool, find the configuration file config. inc. php under the \ webroot \ mysql installation directory of the OA and open it with notepad. 2. Find the row $ cfg ['servers'] [$ I] ['auth _ type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie), change it to $ cfg ['servers'] [$ I] ['auth _ type'] = 'http '; // Authentication method (valid choices: config, http, HTTP, signon or cookie) and save it. 3. After modification, the following window is displayed when you log on to the background database. You must enter the user name and password. Otherwise, you cannot log on. Obviously, this method is more secure than direct logon. Note: The default user name is root and the password is mya888. Although the security of logging on to the database using the username and password method is enhanced a lot, using the default username and password of the database will obviously reduce the security. So how to make it more secure is to change the password of the mysql database. This is the second method to be introduced. Method 2: Modify the password of the mysql database to make it more secure to access the database. The password change operation method is not described here. For details, refer to this document: Tongda website/OA Knowledge Base /! Note: 1. When installing the mysql Web-based database management tool, the default directory name is mysql. To prevent users from using this tool to intrude into the database system, you can set the directory name to a complex one, for example, mysql23 @ 43 avoids directory name speculation. 2. The use of this management tool requires a certain database base. Do not perform dangerous operations. If you need to operate the database, please note that you must back up the database before the operation, to avoid data loss.