Java Basic Learning Note 24 MySQL installation diagram

, MySQL Installation

1. Open the downloaded MySQL installation file mysql-5.5.27-win32.zip, double-click Unzip, run "Setup.exe".

2, choose the installation type, there are "typical (default)", "Complete", "Custom (User Defined)" Three options, select "Custom", press "next" key to continue.

3. Click "Browse" to specify the installation directory manually.

4, fill in the installation directory, my is "F:\Server\MySQL\MySQL Server 5.0", also recommended not to be placed in the same partition as the operating system, so as to prevent system backup restore, the data is emptied. Press "OK" to continue. Confirm the previous settings and, if wrong, press "back" to return to redo. Press "Install" to start the installation.

5, in the installation, please wait until the following interface appears, complete the installation of MySQL

Second, the configuration of MySQL

1, the installation is complete, the following interface will enter the MySQL Configuration Wizard.

2, choose the configuration mode, "Detailed configuration (manual and precise)", "Standard configuration", we choose "Detailed configuration", easy to familiarize with the configuration process.

3, select the server type, "Developer Machine (Development test class, MySQL occupies very little resources)", "Server machine (server type, MySQL occupies more resources)", "dedicated MySQL server Machine (dedicated database server, MySQL occupies all available resources) "

4, choose the general purpose of MySQL database, "Multifunctional database (Universal multifunction, good)", "Transactional database only (server type, focus on transaction processing, general)", " Non-transactional Database only (non-transactional, simpler, mainly to do some monitoring, counting, MyISAM data type support is limited to non-transactional), press "Next" to continue.

5. Select the number of concurrent connections, decision Support (DSS)/olap (20 or so), Online Transaction Processing (OLTP) (500 or so), Manual Setting (manually set, lose a number yourself) ".

6, whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on their own machine, on this page, you can also select "Enable Standard mode" (enabled Strict mode), so that MySQL will not allow small syntax errors. If you are a novice, it is recommended that you remove the standard mode to reduce hassle. However, when you are familiar with MySQL, try to use standard mode as it can reduce the possibility of harmful data entering the database. Press "Next" to continue

7, is the MySQL default database language encoding to set (important), general election UTF-8, press "Next" to continue.

8, choose whether to install MySQL as a Windows service, you can also specify the service name (the Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under the bin, instead of indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

9. Ask if you want to modify the password for the default root user (super Admin). "Enable root access from remote machines (whether to allow root users to log on to other machines, if it is safe, do not tick, if it is convenient, tick it)". Finally "Create an Anonymous account (create a new anonymous user, anonymous users can connect to the database, unable to manipulate data, including queries)", generally do not check, set up, press "Next" to continue.

10, confirm the settings are correct, press "Execute" to make the settings effective, that is, complete the installation and configuration of MySQL.

Note: Set up, press "Finish" after a more common error, is not "Start service", generally appear in the previous installation of MySQL server, the solution, the first to ensure that the previous installation of the MySQL server completely uninstalled out; Check whether the previous password has been modified as described in the previous step, and if it does not, back up the Data folder in the MySQL installation directory and delete it, after the installation is complete, the Data folder will be installed and the backup Data folder can be removed. Restart the MySQL service again, in which case you might need to check the database and fix it once to prevent data errors.

Here's how to fix it:

• 1. Uninstall MySQL
• 2, Windows XP system Delete directory C:\Documents and Settings\All Users\Application Data\Windows 7\8\10 Operating system Delete directory C:\ProgramData\MySQL
• 3, re-install it can be

Java Basic Learning Note 24 MySQL installation diagram