Stopping, starting and connecting to a 2nd instance of MySQL on the command line

mysql

To stop the instance, you can use something like this:
mysqladmin -S /var/lib/mysql2/mysql2.sock start

When it comes to starting MySQL again, this will work:
/bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my2.cnf

To access the mysql shell on the command line:
mysql -S /var/lib/mysql2/mysql2.sock

Leave a Reply

Your email address will not be published. Required fields are marked *