0

On my Ubuntu server, there are two mysql instances running at the same time.

  • A default, normal mysql instance
  • A secondary mysql instance running with mysqld_multi.

The command sudo service mysql status correctly states the mysql service is active.

I want to check the secondary instance's status so I use this command : 

sudo mysqld_multi report

...and I get :

MySQL server from group: mysqld1 is not running

which seems pretty inconsistent since I can connect to this mysql instance from my DB client.

Why does mysqld_multi tell me the instance is not running ?

Charles Okolms
  • 45
  • 1
  • 8

1 Answers1

1

Check creation mysql instance dir, confirm mysql rights and install instance in dir

mkdir -p /u01/data/mysql/mysql1 && chown mysql:mysql /u01/data/mysql /u01/data/mysql/mysql1
mysql_install_db --user=mysql --datadir=/u01/data/mysql/mysqld1
sick_delay
  • 11
  • 1