Summary of mysql installation and startup

Summary of mysql installation and startup

1 Installation

Install mysql 5.6.24 as usual. The error code 2503 is found during the installation process.

CauseInsufficient installation permissions

Solution

I

1. Run the command by selecting the administrator in the command prompt.

2. Go to your mysql installation package path.

3. Enter the mysql-5.6.24-winx64.msi (installation package name) and press enter to install

II

For more information, see the http://jingyan.baidu.com/article/59a015e34f4870f79488652e.html (this method does not have a specific experiment, personal feeling can solve)

2. Start the mysql server

Net start mysql

The problem is as follows:

CauseNo related services in the system

Solution (all commands are run in the administrator)

3. Connect to the database (remember to add the environment variable C: \ Program Files \ MySQL Server 5.6 \ bin installation path in path First)

Enter mysql-uroot-p (the root behind-u is the default user name (which can be left empty) for database installation ), if you want to add new user details, please add Baidu and replace root with the user name of your own Tianji.

-P followed by the password

Because my database does not have a password after-p, you do not need to add a password)

This may happen if a semicolon is added.

Database

Http://pan.baidu.com/s/1o86DjCm

Visualization tools

Http://pan.baidu.com/s/1dFAtsIX