Mysql Console

[GaDo]

Hi

How i can open the MYSQL console on the cmd? (I want the mysql original console. Not MariaDB because i want to learn mysql from the beginning).

Thanks!

[GaDo]

Oh. is mariadb and not mysql. Sorry for the question.

[leokhoa]

@GaDo MariaDB is just MySQL improved. You can think they are just different in the name.
So, after clicking Start button, open the Terminal, you can connect to MySQL Server by typing:

mysql -u root -p

Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.8-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

SHOW DATABASES;

+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)

[jafarpagerjaya]

@leokhoa why i can't find my database in cmd using mysql.exe? i can find it only when it use cmder.