Knowledge Base

308 copy-ready commands with fill-in variables, plus step-by-step installation guides.

Installation Guides 11

Categories

Installation Guides (11)

Tags

25 results

MariaDB & MySQL New

Nightly MariaDB Backup with Rotation (cron)

# crontab -e ثم أضف السطر:
#mariadb #mysql
2 views 0 copies
MariaDB & MySQL

Create a Table

CREATE TABLE IF NOT EXISTS {{table_name}} (
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Add a Column to Existing Table

ALTER TABLE {{table_name}}
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Add an Index to a Column

ALTER TABLE {{table_name}}
#mariadb #mysql
5 views 0 copies
MariaDB & MySQL

Show Running Queries

SHOW FULL PROCESSLIST;
#mariadb #mysql
4 views 0 copies
MariaDB & MySQL

Explain a Query Execution Plan

EXPLAIN SELECT * FROM {{table}} WHERE {{condition}};
#mariadb #mysql
4 views 2 copies
MariaDB & MySQL

Truncate (Empty) a Table

TRUNCATE TABLE {{table_name}};
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Check Table Sizes in Database

SELECT table_name,
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Grant Remote Access to User

GRANT ALL PRIVILEGES ON {{database}}.* TO '{{username}}'@'{{host}}';
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Revoke All Privileges from User

REVOKE ALL PRIVILEGES ON *.* FROM '{{username}}'@'{{host}}';
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Import SQL File into Database

mysql -u {{username}} -p {{database}} < {{sql_file}}
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Count Rows with Condition

SELECT COUNT(*) AS total
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

JOIN Two Tables

SELECT a.{{a_columns}}, b.{{b_columns}}
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Update Rows with Condition

UPDATE {{table}}
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

Delete Rows with Condition

DELETE FROM {{table}}
#mariadb #mysql
5 views 0 copies
MariaDB & MySQL

Install MariaDB server

sudo apt install -y mariadb-server && sudo systemctl enable mariadb && sudo syst...
#mariadb #mysql
3 views 0 copies
MariaDB & MySQL

MariaDB secure installation

sudo mysql_secure_installation
#mariadb #security
3 views 0 copies
MariaDB & MySQL

Create MariaDB database, user, and grants

CREATE DATABASE {{db_name}} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
#mariadb #database
13 views 2 copies
MariaDB & MySQL

Backup MariaDB database to .sql file

sudo mysqldump -u root -p --single-transaction --routines --triggers {{db_name}}...
#mariadb #backup
3 views 0 copies
MariaDB & MySQL

Restore MariaDB database from .sql file

sudo mysql -u root -p {{db_name}} < {{sql_file}}
#mariadb #restore
3 views 0 copies
MariaDB & MySQL

Show all MariaDB users and hosts

SELECT User, Host, plugin FROM mysql.user;
#mariadb #users
4 views 0 copies
MariaDB & MySQL

Change MariaDB user password

ALTER USER '{{db_user}}'@'{{db_host}}' IDENTIFIED BY '{{new_password}}';
#mariadb #password
3 views 0 copies
MariaDB & MySQL

Dump All MariaDB Databases

mysqldump -u root -p --all-databases | gzip > /backups/all-dbs-$(date +%Y%m%d).s...
#mariadb #mysql
4 views 0 copies
MariaDB & MySQL

Enable MariaDB Slow Query Log

SET GLOBAL slow_query_log = 'ON';
#mariadb #mysql
3 views 0 copies