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