centos7 安装mysql8 绿色版
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了centos7 安装mysql8 绿色版,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2071字,纯文字阅读大概需要3分钟。
内容图文
wget -c https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz
xz -d mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz
tar xvf mysql-8.0.16-linux-glibc2.12-x86_64.tar
mv mysql-8.0.16-linux-glibc2.12-x86_64 /usr/local/mysql8
cd /usr/local/mysql8
mkdir data
rm /etc/my.cnf
mkdir etc
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /usr/local/mysql8
cp /usr/local/mysql8/support-files/mysql.server /etc/init.d/mysql.server
vi /etc/init.d/mysql.server
basedir=/usr/local/mysql8
datadir=/usr/local/mysql8/data
vi /usr/local/mysql8/etc/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
user = mysql
server-id = 1
port = 3306
basedir = /usr/local/mysql8
datadir = /usr/local/mysql8/data
pid-file = /usr/local/mysql8/log/mysql.pid
tmpdir = /tmp
socket = /tmp/mysql.sock
max_connections = 400
max_connect_errors = 1000
max_allowed_packet = 128M
interactive_timeout = 1800
wait_timeout = 1800
tmp_table_size = 134217728
max_heap_table_size = 134217728
log_error = /usr/local/mysql8/log/error.log
slow_query_log = 1
slow_query_log_file = /usr/local/mysql8/log/slow.log
log_queries_not_using_indexes = 1
log_throttle_queries_not_using_indexes = 5
log_slow_slave_statements = 1
long_query_time = 8
min_examined_row_limit = 100
expire_logs_days = 5
/usr/local/mysql8/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql8 --datadir=//usr/local/mysql8/data
(保存临时密码)
mv /usr/local/mysql8/etc/my.cnf /etc/
touch /usr/local/mysql8/log/error.log
touch /usr/local/mysql8/log/slow.log
touch /usr/local/mysql8/log/mysql.pid
chown -R mysql:mysql /usr/local/mysql8/log/error.log /usr/local/mysql8/log/slow.log /usr/local/mysql8/log/mysql.pid
service mysql.server start
#登录
mysql -uroot -p
#重启设置密码
ALTER USER ‘root‘@‘localhost‘ identified by ‘123456‘;
flush privileges;
centos7 安装mysql8 绿色版
标签:art base inux statement 临时 cti useradd ges tab
本文系统来源:https://blog.51cto.com/quietnight/2413039
内容总结
以上是互联网集市为您收集整理的centos7 安装mysql8 绿色版全部内容,希望文章能够帮你解决centos7 安装mysql8 绿色版所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。