GridPane is pleased to announce that we’ve accepted a strategic investment from Automattic Read all about it

Service Management: MySQL

1 min read

Stop/Start MySQL

These commands stop and start MySQL. Run them separately.

gp mysql -stop
gp mysql -start

Restart/Reload MySQL

The restart and reload commands both issue a STOP and then START from one command. They are effectively interchangeable.

gp mysql -restart
gp mysql -reload

Get MySQL Password

Outputs the MySQL password for a specified system user.

For root user:

gp mysql -get-pass root

For the admin user:

gp mysql -get-pass admin

 For a site db user:

gp mysql -get-pass {site.url}

( replacing {site.url} with your actual site url ) 

Login to MySQL console

Grabs the specific user password and logs in to MySQL console directly. 

Log in as root user:

gp mysql -login root

Log in as admin user:

gp mysql -login admin

Log in as a site db user:

gp mysql -login {site.url}

 ( replacing {site.url} with your actual site url )