centos7 mysql8安装更改默认目录

最新推荐文章于 2023-12-26 21:57:58 发布

是夜色太荒芜

最新推荐文章于 2023-12-26 21:57:58 发布

阅读量1.3k

点赞数 1

分类专栏： mysql 文章标签： mysql 数据库 linux

本文链接：https://blog.csdn.net/qichangleixin/article/details/118445882

版权

mysql 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

卸载系统自带

rpm -qa | grep mysql
rpm -qa | grep mariadb
rpm -e --nodeps `rpm -qa | grep mysql`
rpm -e --nodeps `rpm -qa | grep mariadb`

上传安装包

mkdir -p /apps/tools

解压安装

cd /apps/tools
tar xf mysql-8.0.19-linux-glibc2.12-x86_64.tar
tar xf mysql-8.0.19-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.19-linux-glibc2.12-x86_64 /apps/
mv /apps/mysql-8.0.19-linux-glibc2.12-x86_64/ /apps/mysql

创建数据目录

mkdir -p /apps/mysql/data 
mkdir -p /apps/mysql/logs

设置用户

groupadd mysql
useradd -r -g mysql mysql -d /apps/mysql -s /bin/false
chown -R mysql.mysql /apps/mysql

创建配置文件/etc/my.cnf

如果你要设置mysql不区分大小写，则配置文件必须提前创建
设置lower_case_table_names=1。

[mysql]
default-character-set=utf8
[mysqld]
port=2190
user=mysql
skip-name-resolve
basedir=/apps/mysql
datadir=/apps/mysql/data
log_bin=on
binlog_expire_logs_seconds=604800
max_connections=400
character-set-server=utf8mb4
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=32M
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
[client]
port=2190
default-character-set=utf8mb4

安装mysql

/apps/mysql/bin/mysqld --initialize --user=mysql --lower-case-table-names=1 --basedir=/apps/mysql/ --datadir=/apps/mysql/data --lc_messages_dir=/apps/mysql/share --lc_messages=en_US

记住初始密码
在这里插入图片描述

修改mysql.server文件

修改basedir datadir目录

vim /apps/mysql/support-files/mysql.server

在这里插入图片描述

将mysql加入服务

cp /apps/mysql/support-files/mysql.server /etc/init.d/mysqld

启动mysql

service mysqld status
service mysqld start

设置环境变量

vim /etc/profile
export MYSQL_HOME=/apps/mysql
export PATH=$PATH:$MYSQL_HOME/bin

生效

source /etc/profile

设置密码

mysqladmin -uroot -p’初始密码’ password ‘新密码’

允许远程连接

mysql -uroot -p
mysql> use mysql;
mysql> update user set host = ‘%’ where user = ‘root’;
mysql> flush privileges;
mysql> exit;

开机自启

chkconfig mysqld on
chkconfig --list mysqld

端口开放

firewall-cmd --zone=public --add-port=2190/tcp --permanent
systemctl restart firewalld