mysql装载数据_mysql8安装记录

1.下载官方打包好的二进制安装包：

#wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

可以看到这个版本采用了tar.xz的打包压缩方式，文件只有350M左右，下载还是满方便的。

du -sh mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

339M mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

2.解压文件：

#tar -xJvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

mv /usr/local/mysql-8.0.12-linux-glibc2.12-x86_64/ /usr/local/mysql

3.配置参数文件：

cat /etc/my.cnf

[mysqld]

server-id = 1

port = 3306

mysqlx_port = 33060

mysqlx_socket = /tmp/mysqlx.sock

datadir = /data/mysql

socket = /tmp/mysql.sock

pid-file = /tmp/mysqld.pid

log-error = error.log

slow-query-log = 1

slow-query-log-file = slow.log

long_query_time = 0.2

log-bin = bin.log

relay-log = relay.log

binlog_format =ROW

relay_log_recovery = 1

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect =‘SET NAMES utf8mb4‘

innodb_buffer_pool_size = 1G

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

log_timestamps = SYSTEM

lower_case_table_names = 1

default-authentication-plugin =mysql_native_password

4.创建目录授权等：

groupadd mysql

useradd mysql

mkdir -p /data/mysql

chown -R mysql:mysql /data/mysql/

chmod -R 775 /data/mysql/

5.初始化数据库：

#/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize-insecure

官方推荐使用--initialize，会在错误日志中生成难以输入的临时密码，我这里使用的免密码的方式。

cat /data/mysql/error.log | grep -i password

2018-07-29T02:06:41.253856+08:00 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: wquR3-Kxlg1d

6.设置启动文件和环境变量：

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

--启动数据库：

/etc/init.d/mysql start

Starting MySQL.Logging to ‘/data/mysql/error.log‘.

SUCCESS!

vim /etc/profile.d/mysql.sh

cat /etc/profile.d/mysql.sh

export PATH=$PATH:/usr/local/mysql/bin

source /etc/profile.d/mysql.sh

mysqld --version

mysqld Ver 8.0.12 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

[root@node4 mysql]# /usr/local/mysql/bin/mysql -p -S /tmp/mysql.sock

Enter password:

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 7

Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘h‘ for help. Type ‘c‘ to clear the current input statement.

mysql> select version();

+-----------+

| version() |

+-----------+

| 8.0.12 |

+-----------+

1 row in set (0.00 sec)

7.设置可以远程登录的账号：

mysql> show variables like ‘%valid%pass%‘;

Empty set (0.00 sec)

mysql> create user root@‘%‘ identified by ‘oracle‘;

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

mysql> show variables like ‘%valid%pass%‘;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> alter user root@‘localhost‘ identified by ‘oracle‘;

Query OK, 0 rows affected (0.07 sec)

mysql> show variables like ‘%valid%pass%‘;

Empty set (0.01 sec)

--创建可以远程登录的用户：

mysql> create user root@‘%‘ identified by ‘oracle‘;

Query OK, 0 rows affected (0.06 sec)

mysql> grant all privileges on . to root@‘%‘ with grant option;

Query OK, 0 rows affected (0.07 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

记录

解压

用量 930616

-rw-r--r--. 1 root root 50345454 6月 5 18:44 grafana-4.5.2-1.x86_64.rpm

-rw-r--r--. 1 root root 17067970 6月 5 18:41 influxdb-1.2.0.x86_64.rpm

-rw-r--r--. 1 root root 185646832 8月 24 22:57 jdk-8u181-linux-x64.tar.gz

-rw-r--r--. 1 root root 344964868 8月 1 19:44 mysql-8.0.12-linux-glibc2.12-i686.tar.xz

-rw-r--r--. 1 root root 354913940 8月 25 10:01 mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

[root@localhost home]#

[root@localhost home]# tar -xJvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

复制到

root@localhost home]# mv /usr/local/mysql-8.0.12-linux-glibc2.12-x86_64/ /usr/local/mysql

[root@localhost home]#

配置文件:

[root@localhost mysql]#

[root@localhost mysql]#

[root@localhost mysql]# cd /etc/

[root@localhost etc]# mv my.cnf my.cnf.bak

[root@localhost etc]# vim my.cnf

[mysqld]

server-id = 1

port = 3306

mysqlx_port = 33060

mysqlx_socket = /tmp/mysqlx.sock

datadir = /data/mysql

socket = /tmp/mysql.sock

pid-file = /tmp/mysqld.pid

log-error = error.log

slow-query-log = 1

slow-query-log-file = slow.log

long_query_time = 0.2

log-bin = bin.log

relay-log = relay.log

binlog_format =ROW

relay_log_recovery = 1

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect =‘SET NAMES utf8mb4‘

innodb_buffer_pool_size = 1G

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

log_timestamps = SYSTEM

lower_case_table_names = 1

default-authentication-plugin =mysql_native_password

~

"my.cnf" [新] 27L, 1083C 已写入

[root@localhost etc]#

[root@localhost etc]#

[root@localhost etc]#

[root@localhost etc]#

[root@localhost etc]# mkdir -p /data/mysql

[root@localhost etc]# chown -R mysql:mysql /data/mysql/

[root@localhost etc]# chmod -R 775 /data/mysql/

[root@localhost etc]#

/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --initialize-insecure

[root@localhost etc]# cat /data/mysql/error.log | grep -i password

2018-08-25T21:10:11.470522+08:00 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

~

"profile.d/mysql.sh" [新] 2L, 69C 已写入

[root@localhost etc]#

[root@localhost etc]# source /etc/profile.d/mysql.sh

[root@localhost etc]#

[root@localhost etc]# mysqld --version

mysqld Ver 8.0.12 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)

[root@localhost etc]# /usr/local/mysql/bin/mysql -p -S /tmp/mysql.sock

Enter password:

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 8

Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘h‘ for help. Type ‘c‘ to clear the current input statement.

mysql> select version();

+-----------+

| version() |

+-----------+

| 8.0.12 |

+-----------+

1 row in set (0.00 sec)

mysql> show variables like ‘%valid%pass%‘;

Empty set (0.02 sec)

mysql> show variables like ‘%valid%pass%‘;

Empty set (0.02 sec)

mysql> create user root@‘%‘ identified by ‘admin‘;

Query OK, 0 rows affected (0.10 sec)

mysql> alter user root@‘localhost‘ identified by ‘admin‘;

Query OK, 0 rows affected (0.05 sec)

mysql> show variables like ‘%valid%pass%‘;

Empty set (0.01 sec)

mysql> create user root@‘%‘ identified by ‘admin‘;

ERROR 1396 (HY000): Operation CREATE USER failed for ‘root‘@‘%‘

mysql> grant all privileges on . to root@‘%‘ with grant option;

Query OK, 0 rows affected (0.08 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql>