Mysql多实例如何安置配置
发布时间：2022-01-11 13:53:25 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要为大家展示了Mysql多实例如何安装配置，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下Mysql多实例如何安装配置这篇文章吧。 1.OS用户创建/软件解压/OS权限配置 点击(此处)折叠或打开 [root@wbg so
|
这篇文章主要为大家展示了“Mysql多实例如何安装配置”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“Mysql多实例如何安装配置”这篇文章吧。 1.OS用户创建/软件解压/OS权限配置 点击(此处)折叠或打开 [root@wbg software]# groupadd mysql [root@wbg software]# useradd -r -g mysql -s /bin/false mysql [root@wbg software]# cd /usr/local [root@wbg local]# tar zxvf ~/software/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz 解压中。。。 [root@wbg local]# ln -s mysql-5.7.18-linux-glibc2.5-x86_64/ mysql [root@wbg mysql]# mkdir mysql-files [root@wbg mysql]# chmod 750 mysql-files [root@wbg mysql]# chown -R mysql . [root@wbg mysql]# chgrp -R mysql . 2.编写/etc/my.cnf 点击(此处)折叠或打开 [mysqld_multi] mysqld = /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64/bin/mysqld_safe mysqladmin = /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64/bin/mysqladmin user = root password = gg log =/root/multi.log [mysqld3306] socket = /tmp/mysql.sock3306 port = 3306 pid-file = /mydata/3306/hostname.pid.3306 datadir = /mydata/3306/ #language = /usr/local/mysql/share/mysql/english user = mysql [mysqld3308] mysqld = /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64/bin/mysqld_safe #ledir = /path/to/mysqld-binary/ mysqladmin = /usr/local/mysql-5.7.18-linux-glibc2.5-x86_64/bin/mysqladmin socket = /tmp/mysql.sock3308 port = 3308 pid-file = /mydata/3308/hostname.pid.3308 datadir = /mydata/3308/ #language = /usr/local/mysql/share/mysql/swedish user = mysql [client] #port=3306 #socket=/tmp/mysql.sock3306 #port=3308 #socket=/tmp/mysql.sock3308 我用的是官方的模板来做的，用的参数比较的少，而且我还在官方的模板基础上注释掉了几个参数。 3.为每个实力单独创建目录 点击(此处)折叠或打开 [root@wbg mysql]# mkdir /mydata [root@wbg mysql]# cd /mydata [root@wbg mydata]# mkdir 3306 [root@wbg mydata]# mkdir 3308 [root@wbg mydata]# chown -R mysql:mysql /mydata/ 4.初始化实例（2个都要做，这里只贴一个了）（前面2个是反面教程，最后一个是对的） 点击(此处)折叠或打开 [root@wbg mysql]# bin/mysqld --initialize --user=mysql defaults-file=/etc/my.cnf 2017-10-23T09:13:53.872808Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-10-23T09:13:54.385216Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-10-23T09:13:54.547668Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-10-23T09:13:54.630447Z 0 [ERROR] Too many arguments (first extra is 'defaults-file=/etc/my.cnf'). 2017-10-23T09:13:54.630493Z 0 [ERROR] Aborting 需要添加--explicit_defaults_for_timestamp这个配置，要不然有警告。 点击(此处)折叠或打开 [root@wbg mysql]# bin/mysqld --initialize --user=mysql --defaults-file=/etc/my.cnf --datadir=/mydata/3308/ --explicit_defaults_for_timestamp 2017-10-23T09:45:43.659977Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-10-23T09:45:43.806836Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-10-23T09:45:43.912638Z 0 [ERROR] unknown variable 'defaults-file=/etc/my.cnf' 2017-10-23T09:45:43.912685Z 0 [ERROR] Aborting initialize和defaults-file的顺序也要注意，我在这里耽误了很多时间。 点击(此处)折叠或打开 [root@wbg mysql]# bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --datadir=/mydata/3308/ --explicit_defaults_for_timestamp 2017-10-23T09:50:48.217054Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-10-23T09:50:48.430856Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-10-23T09:50:48.500114Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a5c39a70-b7d7-11e7-a63a-080027736559. 2017-10-23T09:50:48.510651Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-10-23T09:50:48.513336Z 1 [Note] A temporary password is generated for root@localhost: 6epfT_PyU+EG 最后的这个是正确的。 （编辑：洛阳站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐