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

Source: Internet
Author: User
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

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.