To run mysql, the following commands will be frequently used [1]:
Resources
- Show Databases
mysql>show databases; - Show Tables
mysql> show tables; - Show Procedures
mysql> show procedure status; - Drop Database
mysql> drop database <target_dataabse_name>; - Show MySQL Port
mysql>show variables where variable_name = 'port'; - Show Binlog Status
- mysql> show variables like 'log_bin';
- Show Binlog directory
- mysql>show variables like 'datadir';
Resources
Created: 2/9/2015 Last Updated: 8/2/2016