Saturday, March 28, 2020

Connect to MySQL MariaDB

Connect to MariaDB:

1.
mysql

Following prompt is to appear:
MariaDB [(none)]>

2.
show databases;

3.
use databasename;
E.g.
use dtech;

3.
show tables;


E.g.
MariaDB [dtech]> show tables;
+-----------------+
| Tables_in_dtech |
+-----------------+
| bins            |
+-----------------+
1 row in set (0.000 sec)

4.
select * from bins;

5.
exit;