Shulou(Shulou.com)05/31 Report--

How to install and use mysql 8.0.12 decompressed version correctly? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something.

1. Official download installation board

two。 Decompression

This is the extracted directory, but we need to do two small operations on this basis.

(1) create a folder named data

(2) create a file named my.ini

3. Modify the my.ini file

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 set mysql installation directory basedir= D:\\ developtools\\ software\\ mysql\\ mysql-8.0.12-winx64 # set mysql database data storage directory datadir= D:\\ developtools\\ software\\ mysql\\ mysql-8.0.12-winx64\\ data # allow maximum connection The character set used by the max_connections=20# server defaults to the 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Special attention should be paid to:

(1) D:\ developtools\ software\ mysql\ mysql-8.0.12-winx64 this directory must be "\", do not make it "\" or you will report an error. Some people say it's okay to use "/". I haven't tested it.

(2) Mysq installation directory and data storage directory must be modified for your own directory, unless you and I set the same directory.

4. Configure the environment variables for mysql (this should all work)

Click Path to create a new

5. Run cmd as an administrator

(1) change to the bin directory of mysql

(2) execute mysqld install command

(3) execute mysqld-initialize-console command

Note: in order to generate a password here, be sure to remember this secret and copy it into a document.

(4) execute net start mysql command

(5) execute the mysql-u root-p command

Copy the previous password to the current location and copy as much as possible, otherwise it is easy to make mistakes

(6) change the password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' new password; is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.