9. For verification once again fire SHOW DATABASES command.
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| uxtechno |
+--------------------+
4 rows in set (0.00 sec)
mysql>
10. To use a database:
mysql> USE uxtechno Database changed mysql>
11. To check if uxtechno database is selected:
mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | uxtechno | +------------+ 1 row in set (0.00 sec) mysql>
Jouni "rautamiekka" Järvinen says
Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.