Install mysql and configure security in windows

Mysql installation and Security Configuration in windows-Linux Enterprise Application-Linux server application information. For more information, see. The mysql database is a linux database and a windows database is a transplanted database. Because it is not native

Windows causes many security faults or configuration vulnerabilities. The following describes precautions for mysql installation and security configuration.

Things

1. Installing
Double-click setup to start installation and select installation mode
Three options: typical (standard) complate (full) custom (custom)
Select custom installation
Installation component selection is generally normal. You do not need to note that the installation location of the mysql main program and the mysql database is consistent.
Next installation path
Try not to install it on the system disk, which may cause security problems due to system disk permissions.
Complete installation after next step
A new interface is displayed for mysql Initialization Configuration.
In the configuration Wizard, select detailed configuration (manual precise configuration) and click Next.
Step 2 select the server type
1 developer machine (Development Server)
Using mysql for program configuration debugging is relatively low
2 server machine (server type)
Mysql, which is used as a database and website storage server, occupies a relatively high volume.
3 dedicated mysql server machine
Use mysql as an independent database server to exclusively occupy all idle resources

Select option 2 for general servers

Step 3 select server usage
Select multifunctional database. The other two options do not support mysql external access to the next step.
Select the default number of connections for mysql.
We recommend that you set a fixed value for your server to avoid mysql port overflow due to attacks caused by external port Publishing.
This step is required to enable TCP/IP access. Otherwise, mysql does not support external access.
Select Spanish Encoding
Select utf8
Then, set the mysql root Password.
Set a root user password with a high password strength (note: the root password cannot recognize symbols and only uppercase/lowercase letters and numbers are recognized)
Then proceed
Configuration complete

2. Security Configuration after completion
Step 1 my computer -- anti-key -- Management -- users and groups -- create a new user under a user as an independent mysql startup user
We recommend that you set the user name and password to more than 8 characters.
Cancel all Group Permissions

Step 2
Grant this user all permissions to the mysql installation directory

Step 3 step 1 my computer -- anti-key -- Management -- services and applications -- services
Find the mysql service anti-key selection Attribute-security-Login
Change the default login user system to the user Tianxin Network Data Center (Tianxin Network) created earlier, and test and restart mysql.
(If the restart fails, check whether the temporary folder of the system has the write modification permission of every)

This operation is used to prevent the server from being hacked due to mysql problems to improve server security.