mysql8安装记录

运行环境：centos6.6+mysql8.0.12#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#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/mysqlcat /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_passwordgroupadd mysql
useradd mysql
mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql/
chmod -R 775 /data/mysql/#/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#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)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 – GPLCopyright (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>

相关推荐: 怎么创建sql数据库触发器

本篇文章给大家分享的是有关怎么创建sql数据库触发器，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。创建sql数据库触发器的方法是：【create trigger trigger_name on t…