Differences between revisions 3 and 4
⇤ ← Revision 3 as of 2019-05-13 20:15:50 →
Size: 576
Editor: PieterSmit
Comment:
← Revision 4 as of 2019-05-13 20:17:04 → ⇥
Size: 662
Editor: PieterSmit
Comment:
Deletions are marked like this. Additions are marked like this.
Line 18: Line 18:
MariaDB [shopify]> show tables MariaDB [shopify]> show tables;
   }}}

 * look at fields in table {{{
MariaDB [shopify]> describe <table-name>;

mysql (mariadb) command line notes

  • login 

    $ mysql -uroot -pmypassword

  • list dbs 

    MariaDB [(none)]> show databases;

  • use a db e.g. mysql for users 

    MariaDB [(none)]> use mysql ;

  • show tables in db 

    MariaDB [shopify]> show tables;

  • look at fields in table 

    MariaDB [shopify]> describe <table-name>;

  • view users and host 

    MariaDB [mysql]> select user,Host,password from user ;

  • set password in console 

    MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO root@192.168.70.1 IDENTIFIED BY 'mypassword' ;

...

MySql (last edited 2023-05-11 20:57:01 by PieterSmit)