thomasbnt · October 27, 2025 10:51 · Sep 16, 2022 · Jan 27, 2022 · Jan 16, 2022 · Sep 10, 2020
diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -11,6 +11,20 @@ CREATE DATABASE database;
 DROP DATABASE database;
 ```
 
+## Manage tables
+
+### Create table
+
+```sql
+CREATE TABLE table_name;
+```
+
+### Delete table
+
+```sql
+DROP TABLE table_name;
+```
+
 ## Manage users
 
 ### Create user

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -106,4 +106,27 @@ if (!empty($dbname)) {
 +  $cfg['Servers'][$i]['AllowRoot'] = false;   
 
 }
+```
+____
+## Allow remote connection 
+
+```bash
+nano /etc/mysql/my.cnf
+```
+Or other files who MariaDB/MySQL is registered.
+
+```diff
+- bind-address = 127.0.0.1
++ bind-address = 0.0.0.0
+```
+After that, restart the service.
+
+```bash
+systemctl restart mariadb
+```
+
+You can verify if the process listening to the good IP and port with **netstat** : 
+
+```bash
+netstat -ant | grep 3306
 ```
diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -90,4 +90,20 @@ SHOW GRANTS username;
 
 ```sql
 FLUSH PRIVILEGES;
+```
+
+
+
+_____ 
+
+## Disable root login on Phpmyadmin
+
+Edit `/etc/phpmyadmin/config.inc.php` 
+
+```diff
+if (!empty($dbname)) {
+   $cfg['Servers'][$i]['auth_type'] = 'cookie';
++  $cfg['Servers'][$i]['AllowRoot'] = false;   
+
+}
 ```
diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -22,7 +22,8 @@ CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 ### Edit a password for a user
 
 ```sql
-ALTER USER 'user-name'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
+ALTER USER 'username'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
+FLUSH PRIVILEGES;
 ```
 
 ### Delete user

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -19,6 +19,12 @@ DROP DATABASE database;
 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 ```
 
+### Edit a password for a user
+
+```sql
+ALTER USER 'user-name'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
+```
+
 ### Delete user
 
 ```sql

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -35,6 +35,10 @@ select host, user, password from mysql.user;
 ```sql
  mysqladmin -u root -p password [NewPassword]
 ```
+or 
+```sql
+sudo mysqladmin -u root password -p
+```
 
 ## Permissions
 

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -24,6 +24,12 @@ CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 ```sql
 DROP USER ‘username’@‘localhost’;
 ```
+
+### Show users
+
+```sql
+select host, user, password from mysql.user;
+```
 ### Edit user password
 
 ```sql

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -26,7 +26,7 @@ DROP USER ‘username’@‘localhost’;
 ```
 ### Edit user password
 
-```bash
+```sql
  mysqladmin -u root -p password [NewPassword]
 ```
 
@@ -45,32 +45,32 @@ DROP USER ‘username’@‘localhost’;
 
 ### Grant permissions
 
-```bash
+```sql
 GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
 ```
 
-```bash
+```sql
 GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;
 ```
 
-```bash
+```sql
 GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
 ```
 
 ### Revoke permissions
 
-```bash
+```sql
 REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;
 ```
 
 ### Show permissions
 
-```bash
+```sql
 SHOW GRANTS username;
 ```
 
 ## Flush privileges
 
-```bash
+```sql
 FLUSH PRIVILEGES;
 ```
diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -45,32 +45,32 @@ DROP USER ‘username’@‘localhost’;
 
 ### Grant permissions
 
-```sql
+```bash
 GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
 ```
 
-```sql
+```bash
 GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;
 ```
 
-```sql
+```bash
 GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
 ```
 
 ### Revoke permissions
 
-```sql
+```bash
 REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;
 ```
 
 ### Show permissions
 
-```sql
+```bash
 SHOW GRANTS username;
 ```
 
 ## Flush privileges
 
-```sql
+```bash
 FLUSH PRIVILEGES;
 ```
diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -53,6 +53,10 @@ GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
 GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;
 ```
 
+```sql
+GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';
+```
+
 ### Revoke permissions
 
 ```sql

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -24,6 +24,11 @@ CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 ```sql
 DROP USER ‘username’@‘localhost’;
 ```
+### Edit user password
+
+```bash
+ mysqladmin -u root -p password [NewPassword]
+```
 
 ## Permissions
 

diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -2,26 +2,26 @@
 
 ### Create database
 
-```
+```sql
 CREATE DATABASE database;
 ```
 ### Delete database
 
-```
+```sql
 DROP DATABASE database;
 ```
 
 ## Manage users
 
 ### Create user
 
-```
+```sql
 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
 ```
 
 ### Delete user
 
-```
+```sql
 DROP USER ‘username’@‘localhost’;
 ```
 
@@ -40,7 +40,7 @@ DROP USER ‘username’@‘localhost’;
 
 ### Grant permissions
 
-```
+```sql
 GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
 ```
 
@@ -50,18 +50,18 @@ GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhos
 
 ### Revoke permissions
 
-```
+```sql
 REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;
 ```
 
 ### Show permissions
 
-```
+```sql
 SHOW GRANTS username;
 ```
 
 ## Flush privileges
 
-```
+```sql
 FLUSH PRIVILEGES;
 ```
diff --git a/mysql-cheatsheet.md b/mysql-cheatsheet.md
@@ -0,0 +1,67 @@
+## Manage databases
+
+### Create database
+
+```
+CREATE DATABASE database;
+```
+### Delete database
+
+```
+DROP DATABASE database;
+```
+
+## Manage users
+
+### Create user
+
+```
+CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
+```
+
+### Delete user
+
+```
+DROP USER ‘username’@‘localhost’;
+```
+
+## Permissions
+
+### Types of permissions
+
+* ALL PRIVILEGES
+* CREATE
+* DROP
+* DELETE
+* INSERT
+* SELECT
+* UPDATE
+* GRANT OPTION
+
+### Grant permissions
+
+```
+GRANT ALL PRIVILEGES ON database.* TO 'username'@'localhost';
+```
+
+```sql
+GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;
+```
+
+### Revoke permissions
+
+```
+REVOKE type_of_permission ON database_name.table_name FROM ‘username’@‘localhost’;
+```
+
+### Show permissions
+
+```
+SHOW GRANTS username;
+```
+
+## Flush privileges
+
+```
+FLUSH PRIVILEGES;
+```
No results found