Database first section install MySQL sever5.5 with view database CREATE table

2018.05.03 Database Class first section

MySQL sever5.5 the last step in the installation process failed for unknown reason

The first step opens after the marquee selection, select Next Next

The second step pops up the next dialog box and then chooses to accept this agreement

The third step is to choose the second step, the Custom setting option (custom) and then click Next (Next)

The fourth step is to select the installation path of the MySQL database in the Custom installation screen, here I set the C drive (the network diagram is the D drive, my path option in C drive) Click "Next" to continue the installation:

Fifth step next go to the ready to install the interface, first confirm the previous settings, if wrong, press "back" to return, no errors, click the "Install" button to continue the installation:

The sixth step after clicking the "Install" button appears following the installation of the interface, after very little time, the MySQL database installation completed, the completion of the MySQL installation interface,:

Seventh step continue to click Next to wait silently

Eighth step click Finish and Accept Options

Nineth step in the window that appears, select the type of server, "Developer Machine (Development test Class)", "Server machine (server type)", "Dedicated MySQL server machine (dedicated database server)", We are only used for learning and testing, the default is OK, click "Next" to continue,:

The tenth step is to choose the purpose of MySQL database in the configuration interface that appears, "Multifunctional Database (Universal multifunction)", "Transactional database Only", " Non-transactional Database only (non-transactional) ", here I select the first item, generic installation, click" Next "to continue the configuration:

The 11th step in the interface, the InnoDB tablespace configuration, is to select a storage space for InnoDB database files, if modified, to remember the location, reload the time to choose the same place, otherwise it may cause database corruption, of course, A backup of the database is no problem:

12th step in the open page, select the number of MySQL visits, simultaneous connections, "decision Support (DSS)/olap (20 or so)", "Online Transaction Processing (OLTP) (500 or so)" , "Manual Setting (set to 15 manually) here, select manual settings, click" Next "to continue:

The 13th step in the open page to set whether to enable TCP/IP connection, set the port, if not enabled, you can only access the MySQL database on their own machine, which is connected to Java operation, the default port is 3306, and enable strict syntax settings, click "Next" to continue:

14th step in the Open Character encoding page, set the character encoding MySQL to use, the first is the Latin code, the second is a multi-byte universal UTF8 encoding, the third is manual, we choose Utf-8 or GBK, click "Next", continue to configure:

15th, in the open page, choose whether to install MySQL as a Windows service, you can also specify the service name (Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin, Instead of pointing out the directory name, such as a connection, "Mysql–u username–p password;" Yes, click "Next" to continue with the configuration:

16th step, in the open page set whether to modify the default root user (super Administrator) password (default is empty), "New root password", if you want to modify, fill in the new password here, and enable the function of root remote access, do not create anonymous users, click "Next" Continue the configuration:

Please note that the above method is the first installation, if you have previously installed a problem that is not working properly without uninstalling it is not available after installation

If you uninstalled the installation has not been successful then please find the root directory and then delete

1. Open the C drive, I install the drive letter C drive option

2. Select the C drive to see the option selection

3. Select the C drive, view options, select hidden items

4. Select drive C, view options, Show hidden folders

5. Remove the MySQL folder

6. Turn off the WIN10 firewall

7. Reboot and install

Manually create a folder using SQL Yog software and CREATE database

And then create TABLE create tables

Database first section install MySQL sever5.5 with view database CREATE table