How to securely access the database using Mysql Web-based management tools _ MySQL

How to securely access the database using Mysql Web management tools bitsCN.com

How to securely access the database using Mysql Web management tools

How to securely access the database using Mysql Web management tools

When using the Tongda OA system, many users need to use Mysql Web-based management tools to go to the background database to view data and perform relevant 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 OA installation directory/webroot/mysql 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 /! Bytes

Note:

1. when installing the mysql Web-based database management tool, the default directory name is mysql. to prevent users from using the 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.

BitsCN.com