• MySql

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' ;

• Example count by email

  SELECT LastCreated,Email FROM User 
  WHERE Email LIKE "%@tenable.com" 
  and LastCreated >= CAST('2023-05-09' as Date) 
  ORDER BY LastCreated desc;

...