CentOS 安装 MySQL8
2024-09-05 10:44:25
@Linux
官网:https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html
个人博客:https://www.xingchenw.cn/article/179
博客园:http://www.cnblogs.com/guanshanmao/p/9233898.html
CSDN:https://blog.csdn.net/xintingandzhouyang/article/details/80956348
yum安装
- wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
- rpm -ivh mysql80-community-release-el7-1.noarch.rpm
- yum install mysql-server -y
- grep "temporary password" /var/log/mysqld.log
- mysql -u root -p
- alter user 'root'@'localhost' identified by '新密码';
Generic Binaries安装
下载地址:https://dev.mysql.com/downloads/mysql/
Select Operating System:Linux-Generic
Select OS Version:Linux - Generic (glibc 2.12) (x86, 64-bit)
Select Package:Compressed TAR Archive
上传目录:/usr/local/src
安装目录:/usr/local/mysql
//卸载centos7中自带的mariadb
rpm -qa|grep mariadb
rpm -e --nodeps 文件名
//添加用户组
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
//安装依赖
yum install libaio-devel numactl-devel -y
//修改配置
vim /etc/my.cnf [mysqld]
datadir = /usr/local/mysql/data
socket = /tmp/mysql.sock [mysqld_safe]
log-error = /usr/local/mysql/error.log
pid-file = /usr/local/mysql/mysql.pid
//修改权限,不然MySQL会忽略配置文件
chmod 644 /etc/my.cnf
//下载,解压
//进入压缩包目录
cd /usr/local/src
tar xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz //拷贝到工作区
mv mysql-8.0.13-linux-glibc2.12-x86_64 /usr/local/mysql
cd /usr/local/mysql
//创建文件
//(明明设置了所有权,但还是报错,只好提前创建好)
log-error set to '/usr/local/mysql/error.log', however file don't exists. Create writable for user 'mysql'.
touch error.log
//安装
chown -R mysql:mysql /usr/local/mysql
bin/mysqld --initialize --user=mysql #记录随机密码root@localhost: qe#hwXNF(49u
chown -R mysql:mysql /usr/local/mysql
bin/mysql_ssl_rsa_setup
bin/mysqld_safe --user=mysql &
//启动
support-files/mysql.server start
//肯定会报错的,搞不懂
//Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/data/VM_0_13_centos.pid). ps aux|grep mysql
#mysql 20267 0.4 19.2 1368908 369860 pts/2 Sl 11:07 2:20 /usr/local/mysql/bin/mysqld
kill 20267
//登录,修改密码
bin/mysql -u root -p
alter user 'root'@'localhost' identified by '新密码';
最新文章
- 30 分钟快快乐乐学 SQL Performance Tuning
- OpenCV之响应鼠标(四):在图像上绘制出矩形并标出起点的坐标
- android正在运行进程和后台缓存进程的区别
- [POJ] 3468 A Simple Problem with Integers [线段树区间更新求和]
- Web-----》》》 一般处理程序 ashx
- bad interpreter: No such file or directory解决
- AMQP(Advanced Message Queuing Protocol)
- echarts用法
- 动态主机配置协议DHCP
- Docker入门之--基础知识
- sql servse 查询当前库内表索引值
- 【原创】运维基础之Docker(3)搭建私有仓库
- OrCAD Capture CIS 16.6 修改原理图的页面大小
- linux 硬盘分区与格式化挂载
- 通用triggerEvent方法
- 通过DHCP动态管理IP地址
- 手机调试 --- 通过chrome测试手机网站
- Vue2.0原理-模板解析
- redission 分布式锁
- MySQL INFORMATION_SCHEMA 使用