linux安装mysql8.0全过程

1

uname-m

1

tar-xvf mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz

1

mvmysql-8.0.27-linux-glibc2.12-x86_64 mysql

1

2

3

groupadd mysql

sudouseradd-r -g mysql mysql

1

2

3

mkdir-p/data/mysql

chownmysql:mysql -R/data/mysql

1

vim/etc/my.cnf

1

2

3

4

5

6

7

8

9

10

11

12

13

[mysqld]

bind-address=0.0.0.0

port=3306

user=mysql

basedir=/usr/local/mysql

datadir=/data/mysql

socket=/tmp/mysql.sock

log-error=/data/mysql/mysql.err

pid-file=/data/mysql/mysql.pid

character_set_server=utf8mb4

symbolic-links=0

explicit_defaults_for_timestamp=true

lower_case_table_names=1

1

cd/usr/local/mysql/bin/

1

./mysqld--defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/--datadir=/data/mysql/--user=mysql --initialize

1

cat/data/mysql/mysql.err

1

cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysql

1

service mysql start

1

./mysql-u root -p

1

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

1

flush privileges;

1

2

3

4

5

use mysql;

update usersethost='%'where user='root';

flush privileges;