linux mysql开发包_linux 安装多个mysql实例，压缩包安装

我就是我 2022-10-27 01:54 213阅读 0赞

linux 安装多个mysql实例：

压缩安装：

1.下载mysql源码：

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.22-linux-glibc2.12-x86\_64.tar.xz

解压文件：

tar -xvf mysql-8.0.22-linux-glibc2.12-x86\_64.tar.xz

重命名

mv mysql-8.0.22-linux-glibc2.12-x86\_64 mysql3306

复制一份

cp -r mysql3306 mysql80

2.创建mysql实例用户及文件

a.  useradd mysql -r -s /sbin/nologin

b、 mkdir -p /usr/local/mysql/mysql\_files

c、 创建多实例数据目录： mkdir -p /data/mysql\_data\{1..3\}

d. 修改mysql目录的属组及用户： chown root.mysql -R /usr/local/mysql

e、修改专用目录的属主及属组：sudo chown mysql.mysql -R /usr/local/mysql/mysql\_files  /usr/local/mysql/data/mysql\_data\{1..3\}

3.修改mysql配置文件

由于我是多实例，所以指定了my.cnf 的路径，/usr/local/mysql/mysql3306/conf/my.cnf

4.初始化实例

/usr/local/mysql/mysql3306/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql3306 --datadir=/usr/local/mysql/data/mysql\_data1

出现错误：

The designated data directory /usr/local/mysql/data/mysql\_data1/ is unusable. You can remove all files that the server added to it.

https://blog.csdn.net/qq\_17229141/article/details/108524242

因为/usr/local/mysql/data/mysql\_data1  目录已经存在，删掉这个目录，初始化时会自动创建这个目录。

\[Server\] A temporary password is generated for root@localhost: S&%o8XxlUhki

记住初始化的密码：S&%o8XxlUhki

5.开启各实例的SSL连接

/usr/local/mysql/mysql3306/bin/mysql\_ssl\_rsa\_setup --user=mysql --basedir=/usr/local/mysql/mysql3306 --datadir=/usr/local/mysql/data/mysql\_data1

\--defaults-file=/usr/local/mysql/mysql3306/conf/my.cnf

https://www.cnblogs.com/kevingrace/p/10228694.html

6.启动mysql

\--defaults-file 指定配置文件路径

/usr/local/mysql/mysql3306/bin/mysqld --defaults-file=/usr/local/mysql/mysql3306/conf/my.cnf --user=root

报错：Multiple files found for the same tablespace ID

修改/usr/local/mysql/mysql3306/support-files/mysqld\_multi.server 中的路径为安装路径

报错：Failed to set datadir to '/usr/local/mysql/mysql3306/data/' (OS errno: 2 - No such file or directory)

指定 启动时指定datadir的目录

启动脚本：

/usr/local/mysql/mysql3306/bin/mysqld\_safe --defaults-file=/usr/local/mysql/mysql3306/conf/my.cnf --datadir=/usr/local/mysql/data/mysql\_data1 --user=root &

mysqld\_safe与mysqld区别(转载)

https://www.cnblogs.com/benwu/articles/9061345.html

https://blog.csdn.net/weixin\_38898423/article/details/103473895

7.客户端登录

mysql -uroot  -p

初始化密码：S&%o8XxlUhki

修改初始化密码：

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

8.允许远程登录

use mysql;

GRANT ALL PRIVILEGES ON \*.\* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES;

或者update user set host = ’%’ where user = ’root’;

https://www.cnblogs.com/weifeng1463/p/7941625.html

9.安装另一个mysql实例

同上bu'zou

linux mysql开发包_linux 安装多个mysql实例，压缩包安装

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 linux环境上使用压缩包安装mysql数据库

相关 Linux安装jdk（压缩包安装）

相关 linux安装mysql(tar包)

相关 linux mysql 多个实例_linux+安装多个MYSQL实例

相关 linux mysql开发包_linux 安装多个mysql实例，压缩包安装

相关 Windows安装MySQL(压缩包)

相关 linux下mysql二进制包安装

相关 linux 安装 mysql 的 glibc 包

相关 linux二进制通用包安装mysql

相关 mysql压缩包安装