江苏龙网

  1. 主页 > 生活百科 > >

MySQL不同版本多实例部署( 二 )

mysql

3.2 启动各版本数据库启动MySQL5616/usr/local/mysql5616/bin/mysqld_safe --defaults-file=/data/5616/my.cnf &启动MySQL5733/usr/local/bin/mysqld_safe --defaults-file=/data/5733/my.cnf &启动MySQL8021/usr/local/bin/mysqld_safe --defaults-file=/data/8021/my.cnf &查看多实例启动情况[root@db01 mysql8021]# netstat -lntpActive Internet connections (only servers)Proto Recv-Q Send-Q Local AddressForeign AddressStatePID/Program nametcp00 0.0.0.0:220.0.0.0:*LISTEN6694/sshdtcp600 :::3306:::*LISTEN11099/./bin/mysqldtcp600 :::3307:::*LISTEN9767/mysqldtcp600 :::3308:::*LISTEN11408/mysqldtcp600 :::22:::*LISTEN6694/sshdtcp600 :::33060:::*LISTEN11408/mysqld3.3 启动过程错误解决[root@db01 opt]# /usr/local/mysql5733/bin/mysqld 2021-07-04T06:50:33.162662Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2021-07-04T06:50:33.162787Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2021-07-04T06:50:33.162827Z 0 [Note] /usr/local/mysql5733/bin/mysqld (mysqld 5.7.33) starting as process 8912 ...2021-07-04T06:50:33.162871Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.2021-07-04T06:50:33.164529Z 0 [Warning] Can't create test file /usr/local/mysql/data/db01.lower-test2021-07-04T06:50:33.164560Z 0 [Warning] Can't create test file /usr/local/mysql/data/db01.lower-test2021-07-04T06:50:33.164596Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!2021-07-04T06:50:33.164629Z 0 [ERROR] Aborting2021-07-04T06:50:33.164662Z 0 [Note] Binlog end2021-07-04T06:50:33.164732Z 0 [Note] 这个错误是配置文件中有空格导致的.检查是否有空格
【MySQL不同版本多实例部署】


推荐阅读


上一篇：CDN和中心性

下一篇：陈皮鉴别要点,柑普茶的分类有何特殊功效如何鉴别它的好坏(转载