暂无图片
关于centos7 RPM方式安装mysql8.4的问题
我来答
分享
暂无图片 匿名用户
关于centos7 RPM方式安装mysql8.4的问题

软件安装完成后为啥不能自定义数据路径

配置文件/etc/my.cnf默认配置如下,初始化,启动服务一切正常

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

为啥改成下面路径后就无法启动?

datadir=/mysql/data
socket=/mysql/data/mysql.sock

log-error=/mysql/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

/mysql目录权限是正常的,
chown -R mysql:mysql /mysql

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
virvle

可以更改的,确认下报错是什么,以及是否有将数据目录迁移过去,可以参考文档:
https://blog.csdn.net/y19910825/article/details/123414006

暂无图片 评论
暂无图片 有用 2
骆加坤


二进制模式安装mysql

Mysql5.7初始化前要评估是否独立的undo文件

tar -xvf mysql-5.7.34-linux-glibc2.12-x86_64.tar

 

mkdir -p /usr/local/mysql

mkdir -p /usr/local/mysql/data

groupadd mysql

useradd -r -g mysql mysql

chown -R mysql:mysql /usr/local/mysql

 

 

 

yum remove mariadb-libs-5.5.56-2.el7.x86_64

tar -zxvf mysql-5.7.34-linux-glibc2.12-x86_64.tar.gz -C /usr/local/mysql/

 

cd /usr/local/mysql/mysql-5.7.34-linux-glibc2.12-x86_64/

mv * ../

chown -R mysql:mysql /usr/local/mysql

 

 

 

[root@localhost support-files]# cp mysql.server /etc/init.d/mysqld

[root@localhost support-files]# pwd

/usr/local/mysql/support-files

chkconfig --add mysqld

chkconfig mysqld on

 

新建/etc/my.cnf,内容如下:

[mysqld]

port = 3306

socket = /usr/local/mysql/mysql.sock

user = mysql

basedir = /usr/local/mysql

datadir = /usr/local/mysql/data

pid-file = /usr/local/mysql/data/mysql.pid

#sql_mode='ONLY_FULL_GROUP_BY'

log_error = /usr/local/mysql/mysql-error.log

!includedir /etc/my.cnf.d

skip-grant-tables

 

 

mkdir /etc/my.cnf.d

mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data  --该初始化方式被不建议,应该使用如下方式:

mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

 

5.6还是需要mysql_install_db初始化,5.7及有以上就建议mysqld初始化了

密码为空的初始化方式:

./mysqld --defaults-file=/usr/local/mysql/my.cnf --initialize-insecure

 

密码保存在错误日志中的初始化方式:

 /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf --initialize

 

安装后启动参考:

./bin/mysqld --defaults-file=/oradata/mysql8/my.cnf

 

mysql -uroot -h127.0.0.1

mysql> update user set Host='%' where user='root';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 0

 

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

quit

 

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

 

mysql> alter user 'root'@'%' identified by 'Mysql88!';

Query OK, 0 rows affected (0.00 sec

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏