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

This article mainly introduces MySQL 8.0.13 download installation example analysis, has a certain reference value, interested friends can refer to, I hope you read this article after a lot of gains, the following let Xiaobian take you to understand.

First go to mysql official website download, address: https://dev.mysql.com/downloads/mysql/

Select this version of the above picture to download the latest version of MySQL for Windows. After clicking it, it will not download immediately, but will jump to the page below. Just click No thanks, just start my download.

Then it starts downloading. Download can be decompressed to the place you want to put, in general, C disk is best not to put too many things, so I put on the D disk, the following picture is decompressed look, to create their own my.ini configuration file. My.ini in the picture is my own creation.

The my.ini file contains the following:

[mysql]#Set mysql client default character set default-character-set=utf8[mysqld]#Set port 3306 port = 3306#Set mysql installation directory basedir=D:\Program Files (x86)\MySQL\mysql-8.0.13-winx64#Set mysql database data storage directory, MySQL 8+ does not need the following configuration, the system can generate its own, otherwise it may error # datadir=D:\Users\sqldata#Maximum allowed connections max_connections=20#Character set used by server default is 8-bit encoded latin1 character set character-set-server=utf8#Default storage engine used when creating new tables default-storage-engine=INNODB

MySQL configuration file is ready, you can start the database service, first we run the command control character as an administrator, as shown in the figure, win10 inside, click the small circle at the bottom left, enter cmd, right click on the administrative prompt and select Run as an administrator.

After entering this page, cd to MySQL installation directory.

Initialize database:

mysqld --initialize --console

After initializing the database, as shown in the figure, a default password appears: 1SofNjpitN*h

Installation:

mysqld install

Startup Services:

net start mysql

The operation is as shown in the figure:

After starting the service, you will start using the database. First, you will log in to the database.

Command:

mysql -h hostname-u username-p

Parameter Description:

-h: Specify the MySQL host name to which the client should log in, log in locally (localhost or 127.0.0). 1)This parameter can be omitted;-u: Login username;-p: Tells the server that a password will be used to log in. This option can be omitted if the login username password is blank.

If we want to log into our MySQL database, we just need to type the following command:

mysql -u root -p

Press Enter to confirm that if the installation is correct and MySQL is running, you will get the following response:

Enter password:

After successful landing, as shown in the figure

Then the command prompt will always be mysq> plus a blinking cursor waiting for the command input, enter exit or quit to log out

You must reset your password using ALTER USER statement before executing this statement. this error

alter user() identified by "123456";

So we can use MySQL.

First select database.

Command: use mysql; Next, you can operate on this database, you can use the show table; command to view all the tables under this database, etc., when writing MySQL commands, you must end with a semicolon.

Thank you for reading this article carefully. I hope that the article "MySQL 8.0.13 download and installation example analysis" shared by Xiaobian will help everyone. At the same time, I hope that everyone will support you a lot and pay attention to the industry information channel. More relevant knowledge is waiting for you to learn!

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.