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.

1. Important MySQL Commands

Posted by chris on: 2020-12-28, Category: MySQL

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];
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];
Read more »