Category: MySQL

To log in to certain instance:

mysql -u (username) -p -P(port) -h127.0.0.1
example: mysql -u root -p -P3307 -h127.0.0.1

Administer instances:

mysqld_multi report -> To show which instances are running
mysqld_multi start -> To start all instances
mysqld_mutli stop -> To stop all instances
mysqld_multi start / stop (instance) -> To start or stop a certain instance 

Log for mysqld_multi:

/usr/share/mysql/mysqld_multi.log

Tags:

mySQL

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: