Mysql Console


  • | 146 points

    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!


  • | 146 points

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


  • administrators
    | 59056 points

    @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)


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.