grimoire

personal wiki
git clone git://git.pyratebeard.net/grimoire.git
Log | Files | Refs

mariadb.md (381B)

      1 # mariadb
      2 [knowledgebase](https://mariadb.com/kb/en/)
      3 
      4 ```bash
      5 dnf install mariadb mariadb-server
      6 systemctl start mariadb.service
      7 /usr/bin/mysql_secure_installation
      8 mysql -u root -p
      9 ```
     10 
     11 ```sql
     12 show databases;
     13 show tables;
     14 show columns from table;
     15 show columns from database.table;
     16 ```
     17 
     18 ## user
     19 ```sql
     20 select user from USER;
     21 create USER username;
     22 drop USER if exists username;
     23 ```