7. To check the current databases give below command in mysql prompt.
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec) mysql>
8. For creating new database give below command.
mysql> CREATE DATABASE uxtechno; Query OK, 1 row affected (0.00 sec)
Jouni "rautamiekka" Järvinen says
Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.