I am currently trying to install a multiple instance of MySQL 5.7 on Oracle Linux 7 server and I am having issues. Here is what I have done so far

Create mysqld@.service in /usr/lib/systemd/system with contents

[Unit]
Description=MySQL Multi Server for instance %i
After=syslog.target
After=network.target

[Service]
User=mysql
Group=mysql
Type=forking
ExecStart=/usr/bin/mysqld_multi start %i
ExecStop=/usr/bin/mysqld_multi stop %i
Restart=always
PrivateTmp=true

[Install]
WantedBy=multi-user.target



Edited the /etc/my.cnf as below

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqld_multi]
mysqld = /usr/bin/mysqld_safe --basedir=/usr

[mysqld1]
port=3307
datadir=/var/lib/mysql/1/
socket=/var/lib/mysql/1/mysql.sock
pid-file=/var/run/mysqld/mysqld1.pid
log-error=/var/log/mysqld1.log
symbolic-links=0

[mysqld2]
port=3308
datadir=/var/lib/mysql/2/
socket=/var/lib/mysql/2/mysql.sock
pid-file=/var/run/mysqld/mysqld2.pid
log-error=/var/log/mysqld2.log
symbolic-links=0

ran the following commands:
mkdir /var/lib/mysql/{1,2}
chown mysql:mysql /var/lib/mysql/1
chown mysql:mysql /var/lib/mysql/2
mysql_install_db --user=mysql --datadir=/var/lib/mysql/1/
mysql_install_db --user=mysql --datadir=/var/lib/mysql/2/
touch /var/log/mysqld{1,2}.log
chmod o-r /var/log/mysqld{1,2}.log
chcon --reference=/var/log/mysqld.log /var/log/mysqld{1,2}.log
systemctl daemon-reload

Then tried to start the mysqld1 service which fails:
mysqld@1.service - MySQL Multi Server for instance 1
Loaded: loaded (/usr/lib/systemd/system/mysqld@.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since Mon 2018-12-10 14:02:42 EST; 56s ago
Process: 8790 ExecStart=/usr/bin/mysqld_multi start %i (code=exited, status=1/FAILURE)

Dec 10 14:02:41 ictmysql02 systemd[1]: Failed to start MySQL Multi Server for instance 1.
Dec 10 14:02:41 ictmysql02 systemd[1]: Unit mysqld@1.service entered failed state.
Dec 10 14:02:41 ictmysql02 systemd[1]: mysqld@1.service failed.
Dec 10 14:02:42 ictmysql02 systemd[1]: mysqld@1.service holdoff time over, scheduling restart.
Dec 10 14:02:42 ictmysql02 systemd[1]: Stopped MySQL Multi Server for instance 1.
Dec 10 14:02:42 ictmysql02 systemd[1]: start request repeated too quickly for mysqld@1.service
Dec 10 14:02:42 ictmysql02 systemd[1]: Failed to start MySQL Multi Server for instance 1.
Dec 10 14:02:42 ictmysql02 systemd[1]: Unit mysqld@1.service entered failed state.
Dec 10 14:02:42 ictmysql02 systemd[1]: mysqld@1.service failed.

I am not sure where I went wrong or what is missing. Any help is greatly appreciated.
Thank you,
Rene

Please use [code] tags for commands and output.

What's in the /var/log/mysqld1.log?

What does show?

Thanks for responding. The mysqld1.log is empty as the service cannot start and the status is

Can I ask why you think you need to do this?
You do know MySQL can have multiple schemas (ie databases) in the same instance quite safely ?
Multiple instances would also chew up the performance of your system.

It comes down to that each instance is owned by different departments who want some control over their database. I have had issues in the past where others have created problems for other schemas in the same instance. The best way I know of to ensure that it does not happen is to provide their own instance so they can connect via MySQL workbench and administer without impacting others. I currently have multiple instances on a window server but I would like to move to a Linux platform.

Thanks.
Rene

What I do in this situation is create specific mysql users with access only to the schema they need, for what it's worth. Granted, I'm not familiar with your exact limitations.

I agree with Rene; you should be able to manage limited access, etc. within a single instance of mysql.

That said, you're starting with mysql_multi which doesn't seem to have any specifics configured, so it can't start.

Have you tried starting with mysqld1 or mysqld2 ?

[and please edit your OP to put code tags around code and output. It's very difficult to read as it is]

As per urbanwks, creating specific mysql users with access only to the schema they need, is the normal way to go in the IT industry.
Only the DBA should have access to all the schemas.