Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to install and run mysql database, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

How to install and run mysql: first download Mysql and extract it; then go to the bin directory, open cmd; and execute the command "mysqld-install" to install it; finally, initialize it and start mysql with the command "net start mysql".

Download, install and start mysql

Download Mysql by yourself.

(follow my steps should not encounter other problems, because ~ I stepped over the hole to solve all the problems before sending them out.)

Step-by-step description: decompress after download, my download path:

D:\ soft\ mysql my decompression path:

D:\ soft\ mysql\ mysql-8.0.11-winx64 New File my.ini My.ini file content: # [client] port=3306 default-character-set=utf8 [mysqld] port=3306 character_set_server=utf8 # installation path basedir=D:\\ soft\ mysql\ mysql-8.0.11-winx64 # data path datadir=D: \\ soft\ mysql\ mysql-8.0.11-winx64\ data sql_mode=NO_ENGINE_SUBSTITUTION STRICT_TRANS_TABLES [WinMySQLAdmin] Server=D:\\ soft\ mysql\ mysql-8.0.11-winx64\ bin\ mysqld.exe### enter the bin directory Open cmd

Install: perform mysqld-install initialization: execute mysqld-- initialize (this step is necessary, initialize data, you must! ) Startup: to execute net start mysql notes, you must enter the bin directory for installation, initialization and startup operations! Otherwise, you will fail and report the wrong result! After executing mysqld-install, you must execute mysqld-- initialize! Or it won't start at all! The path letter in the my.ini file must use a double slash! Otherwise, although the installation can be successful, initialization and startup will fail!

About password

Mysql will generate a default password, my

The default password for version 8.0 is in the data path: machine name .err

Just use this password to go in and then change the password.

-Log in with the default password

Change the password to "123456"

Ok pull, screenshots can take a look at my test commands, oh, by default there are these databases !

Connect Navicat

1251-Client does not support authentication protocol error occurred in Navicat for MySQL connection Mysql 8.0.11!

The solution is as follows:

Login: mysql-u root-p change password: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 1

23456permission; refresh permission: FLUSH PRIVILEGES

Test the connection again and show that the connection is successful!

The above is all about how to install and run the mysql database. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.