Linux 安装 MySQL 8.0
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Linux 安装 MySQL 8.0,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2886字,纯文字阅读大概需要5分钟。
内容图文
![Linux 安装 MySQL 8.0](/upload/InfoBanner/zyjiaocheng/521/5d3a0c079fdf4c7a97c7a0b4241dee55.jpg)
Linux 安装 MySQL 8.0
MySQL 官网
Docker 安装 MySQL 8.0
-
安装 Docker
# yum install -y yum-utils device-mapper-persistent-data lvm2 # yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo # yum install -y docker-ce docker-ce-cli containerd.io # systemctl start docker # systemctl enable docker
-
拉取 MySQL 镜像
# docker pull mysql/mysql-server # docker images REPOSITORY TAG IMAGE ID CREATED SIZE mysql/mysql-server latest a7a39f15d42d 2 months ago 381MB
-
启动 MySQL 服务器实例
# groupadd mysql # useradd -r -g mysql -s /bin/false mysql # mkdir -p /data/mysql/{data,etc,lib} # chown -R mysql:mysql /data/mysql # vim /data/mysql/etc/my.cnf [mysql] default-character-set=utf8 socket=/var/lib/mysql/mysql.sock [mysqld] skip-name-resolve port = 3306 socket=/var/lib/mysql/mysql.sock basedir=/usr/local/mysql datadir=/var/lib/mysql/data max_connections=200 character-set-server=utf8 default-storage-engine=INNODB max_allowed_packet=16M # docker run -p 3306:3306 --name mysql -v /data/mysql/:/usr/local/mysql -v /data/mysql/etc:/etc/mysql -v /data/mysql/data:/var/lib/mysql/data -e MYSQL_ROOT_PASSWORD=123456 -d mysql/mysql-server:latest # docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES f62fe1f82601 mysql/mysql-server:latest "/entrypoint.sh mysq…" 8 seconds ago Up 7 seconds (health: starting) 0.0.0.0:3306->3306/tcp, 33060/tcp mysql
-
进入 mysql,并访问
# docker exec -it mysql /bin/bash # mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 8.0.19 MySQL Community Server - GPL Copyright (c) 2000, 2020, 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> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec) mysql>
-
添加远程登录用户 mysql 并访问 docker 实例 mysql
mysql> CREATE USER ‘mysql‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘asdf1234‘; mysql> GRANT ALL PRIVILEGES ON *.* TO ‘mysql‘@‘%‘; mysql> flush privileges; mysql> exit # exit # mysql -h 172.40.0.31 -u mysql -p
Linux 安装 MySQL 8.0
标签:word https exit eal run inux 安装 mysql oca utils
本文系统来源:https://www.cnblogs.com/littermonster/p/12580358.html
内容总结
以上是互联网集市为您收集整理的Linux 安装 MySQL 8.0全部内容,希望文章能够帮你解决Linux 安装 MySQL 8.0所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。