Differences between revisions 1 and 2
⇤ ← Revision 1 as of 2018-07-20 04:19:26 →
Size: 216
Editor: PieterSmit
Comment:
← Revision 2 as of 2018-07-20 04:22:01 → ⇥
Size: 446
Editor: PieterSmit
Comment:
Deletions are marked like this. Additions are marked like this.
Line 5: Line 5:
 * login {{{
$ mysql -uroot -pmypassword
   }}}

 * use a db e.g. mysql for users {{{
MariaDB [(none)]> use mysql ;
   }}}

 * view users and host {{{
MariaDB [mysql]> select user,Host,password from user ;
   }}}
Line 6: Line 19:
MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO root@192.168.70.1 IDENTIFIED BY 'mypassword' MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO root@192.168.70.1 IDENTIFIED BY 'mypassword' ;

mysql (mariadb) command line notes

  • login 

    $ mysql -uroot -pmypassword

  • use a db e.g. mysql for users 

    MariaDB [(none)]> use mysql ;

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