MySQL-安装mysql8

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MySQL-安装mysql8，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2304字，纯文字阅读大概需要4分钟。

内容图文

1. 安装配置

# 解压
tar -xf mysql-8.0.18-el7-x86_64.tar.gz -C /ups/app/mysql/
cd /ups/app/mysql/
mv mysql-8.0.18-el7-x86_64 mysql8

cd mysql8
mkdir -p {config,logs}
mkdir -p /ups/data/mydata/mysql8
chown -R mysql:mysql .
chown -R mysql:mysql /ups/data/mydata/mysql8
chmod 700 /ups/data/mydata/mysql8

cat> config/my.cnf <<-EOF
[mysqld]
basedir                     = /ups/app/mysql/mysql8
datadir                     = /ups/data/mydata/mysql8
log-error                   = /ups/app/mysql/mysql8/logs/mysql6033.err
pid-file                    = /ups/app/mysql/mysql8/logs/mysql6033.pid
socket                      = /ups/app/mysql/mysql8/logs/mysql6033.sock
port                        = 6033
default-storage-engine      = INNODB
character-set-server        = utf8mb4
collation-server            = utf8mb4_general_ci

# connect limits
max_connect_errors          = 5
max_connections             = 1000
max_user_connections        = 100
wait_timeout                = 100

open_files_limit            = 1024

# 限制将系统文件读到数据库(/etc/passwd)
local-infile                = 0

skip_name_resolve           = ON

server_id                   = 6033001

# error log、genera log timestamp
log_timestamps=SYSTEM

# 在关闭是将热数据dump到本地磁盘
innodb_buffer_pool_dump_at_shutdown = 1

# 在启动时将热数据加载到内存
innodb_buffer_pool_load_at_startup = 1
EOF

# 初始化MySQL
/ups/app/mysql/mysql8/bin/mysqld --defaults-file=/ups/app/mysql/mysql8/config/my.cnf --user=mysql --basedir=/ups/app/mysql/mysql8 --datadir=/ups/data/mydata/mysql8 --initialize 

# 启动服务
/ups/app/mysql/mysql8/bin/mysqld_safe --defaults-file=/ups/app/mysql/mysql8/config/my.cnf &

2. 配置账号

# mysql8 默认使用caching_sha2_password算法
# 修改root账号密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘root‘;
# 远程登录
create user root@‘192.168.10.%‘ IDENTIFIED WITH mysql_native_password BY ‘root‘ ;
grant all privileges on *.* to ‘root‘@‘192.168.10.%‘ with grant option;
flush privileges;

# 检查确认
select host,user, authentication_string, plugin from mysql.user;

MySQL-安装mysql8

标签：默认   size   The   conf   first   数据库   auth   too   chmod   

本文系统来源：https://www.cnblogs.com/binliubiao/p/12586651.html

内容总结

以上是互联网集市为您收集整理的MySQL-安装mysql8全部内容，希望文章能够帮你解决MySQL-安装mysql8所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端