Some problem solving about MySQL installation start-up

MySQL because of its free, efficient characteristics has been the university, training course of the main database management software. But for beginners may not be so friendly, one is not common with Windows software that a set of visual operations, basically initially in a state of not with NAVICAT can only use black screen operation, to the novice very bad user experience. Now summarize some of the problems that occur:

Installation

1. Unzip to a folder, such as my directory is D:\mysql-5.7.16-winx64

2. Fill in this directory of My-default.ini (of course you can copy the file as I do for another my.ini, so that you do not modify the default file conditions to modify, but also for the backup operation)

Fill in the section, such as the Red Line section, the careful person will doubt the data directory does not exist, because after a certain version (seemingly for security), you need to manually generate the data directory

See 3

3. Because it is a semi-automated installation, it is necessary to manually generate the directory using the command mysqld--initialize-insecure and then wait for the directory to be generated (will be prompted to complete the build)

4. This time is basically ready to use, but for more convenience, the installation service mysqld--install to ensure that you can use the net start/stop mysql boot shutdown server (this process may prompt to be rejected, Because of the WINDOWS10 permissions problem of dog blood, the solution is to enter the directory with administrator privileges to install, again waiting for prompt to succeed

5. Most of the problems have been fixed at this time, and you can use Exit to exit cmd black screen. Here are some questions to explain

Problems

1. How do I open MySQL?

Description: MySQL is divided into server side and client, server to install directory using net start MySQL open, net stop MySQL to close. It is important to note that Windows needs to enter with administrator privileges in order to use net start MySQL to open correctly, or the deny localhost display is likely to appear (this disgusting beginner always makes me feel crash:)

Turn off likewise. Access to Task Manager to find Mysqld.exe confirm open

This time has confirmed that the server is open. The following opens the client, which needs to reopen a CMD window. Enter Mysql-u root-p, enter password, default is empty, enter can

At this point, it has been successful. If the program is OK, you will see the above interface.

2. How do I change the default password?

For error 1054 (42S22): Unknown column ' Password ' in ' Field List ',
Change password by password-free login, enter update mysql.user set Password=password (' root ') where user= ' root ' Prompts for error 1054 (42S22): Unknown column ' Password ' in ' Field List ', which is already in MySQL database has no password This field, password field changed to Authentication_string
That is: Update mysql.user set Authentication_string=password (' root ') where user= ' root '

3. Ultimate Dafa (filter out all landing problems)

Use mysqld--defaults-file= "D:\mysql-5.7.16-winx64\my.ini"--console--skip-grant-tables

Skip the steps. Thus directly into the server, if there is no successful prompt, then go to Task Manager, turn off Mysqld.exe, use the command again to log in.

4. Replace the client CMD window with Navicat

Some problem solving about MySQL installation start-up