problems with mysql instance
Posted by:
AO SH
Date: August 06, 2019 06:35AM
Hi every one,
I was trying to create another mysql instance but I faced a problem.
----------
My OS VERSION is:
REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.6
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.6"
----------
My MySQL version is: mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
-----------
These are the steps I followed:
# mkdir /var/lib/mysql2
# chown -R mysql:mysql /var/lib/mysql2/
# cp /etc/my.cnf /etc/my2.cnf
# vim /etc/my2.cnf
# I added these configurations to my2.cnf:
port=3307
datadir=/var/lib/mysql2
socket=/var/lib/mysql2/mysql.sock
log-error=/var/log/mysqld2.log
pid-file=/var/run/mysqld/mysqld2.pid
----------
* Finally we need to initialize the default dbs:
# mysql_install_db --user=mysql --datadir=/var/lib/mysql2/
* now we need to start our new mysql instance:
# mysqld_safe --defaults-file=/etc/my2.cnf &
off course, since red hat does not have the command mysqld_safe, I used mysqld instead as follows:
# sudo mysqld --defaults-file=/etc/my2.cnf
but I got this Error:
###########################
2019-08-06T12:30:33.186698Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-06T12:30:33.188932Z 0 [Note] mysqld (mysqld 5.7.25) starting as process 3017 ...
2019-08-06T12:30:33.190869Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
2019-08-06T12:30:33.190906Z 0 [ERROR] Aborting
2019-08-06T12:30:33.190932Z 0 [Note] Binlog end
2019-08-06T12:30:33.191009Z 0 [Note] mysqld: Shutdown complete
###########################
please, your support regarding this matter
Subject
Written By
Posted
problems with mysql instance
August 06, 2019 06:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.