MySQL is a database management system that allows you to manage relational databases. It is open source software backed by Oracle. It means you can use MySQL without paying a dime. Also, if you want, you can change its source code to suit your needs.
Posted by chris on: 2020-12-28, Category: MySQL
2020-12-28
Important MySQL Commands
To login (from unix shell) use -h only if needed.
[mysql dir]/bin/mysql -h hostname -u username -p password
To login (from windows)
[mysql dir]/bin/mysql.exe -h hostname -u username -p password
Create a database.
mysql> create database [databasename];
List all databases on the server.
mysql> show databases;
Switch to a database.
mysql> use [db name];