Mysql Showrtcut for Linux (Ubuntu)

mysqlshortcut.txt

mysql -u root -p  //enter into mysql as root user

SHOW DATABASES; //Show available databases

DROP DATABASE database_name; //Delete a mysql database

sudo /etc/init.d/mysql.server start  //start mysql server

sudo /etc/init.d/mysql.server stop  //Stop mysql server

sudo /etc/init.d/mysql.server status  //Check status of mysql

sudo update-rc.d -f mysql.server defaults  //Enable myql on startup

sudo update-rc.d -f mysql.server remove  //Disable mysql on startup (Optional)

sudo /etc/init.d/mysql.server restart  //Restart mysql server