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

This article records the installation and configuration method of mysql 8.0.15 for your reference. The specific contents are as follows

Installation:

1. Download zip from official website

2. Extract and copy to the specified directory. Create a new data file. Add environment variables

3. Create a new my.ini file

[mysqld]#Set port 3306 port=3306#Set mysql installation directory basedir=D:\\MySQL\\mysql-8.0.15-winx64#Set mysql database data storage directory datadir=D:\MySQL\\data#Max connections allowed =200#Number of connections allowed to fail. max_connect_errors=10#Character set used by server defaults to UTF8character-set-server=utf8#Default storage engine used when creating new tables default-storage-engine=INNODB#Default uses "mysql_native_password" plug-in authentication #mysql_native_passworddefault_authentication_plugin=mysql_native_password[mysql]#Set mysql client default character set default-character-set=utf8[client]#Set mysql client default port used when connecting to server port= character 3306default-character-set=utf8

4. Administrator runs command line window to configure MySQL

Enter bin directory and execute command

mysqld --install --console

re-execution

mysqld --initialize --console

Remember password: kf,aaCx: I6Rq (without the first space)

5. Start mysql service

net start mysql

Say service name is invalid

mysqld --install --console According to the prompt, the service already exists, but the service name is still invalid. Later, I removed the console parameter and executed

mysql --install

Show that the service is installed successfully, and then start

net start mysql

Initiate successfully.

(Stop service: net stop mysql)

6. Start login

mysql -u root -p

Enter the default password, which is extremely secure.

Use of database:

use mysql

It will prompt you to reset your password first. implementation

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

The password was changed to 123456.

7. Use of databases

Access denied for user 'root'@'localhost' (using password: YES)

Access denied for user 'root'@'localhost' (using password: YES)

8. Establish database and table

9. View MySQL version

use

1. Start MySQL service

net start mysql

Want the administrator to start

(Stop service: net stop mysql)

2. Start login

mysql -u root -p

3. Use of databases

show databases;use test;show tables;quitnet stop mysql

4, common operations to create a database

create database test;

create tables

create table student( -> id integer, -> name varchar(8), -> password varchar(20));

insert data

insert into student(id,name,password) -> value(1001,"xx",123456);

selection data

select * from student;

Navicat Connect MySQL

Navicat Premium(Database Administration Tool) v12.0.13

Open exe and create MySQL connection

Connection success icon is green

Excellent topic sharing:

mysql different versions installation tutorial

mysql5.7 installation tutorial

mysql5.6 installation tutorial

mysql8.0 installation tutorial

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of 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.