MYSQL on windows

console

• mysqld -u root to start server, make sure mysql\bin folder is added to the path
• mysql -u root to start interactive console
• show databases; to display all databases for the logged-in user
• create schema <DB_NAME> to create a new database.
• use <DB> to select a database.