Các lệnh cơ bản vận hành MySQL/MariaDB

mysql -u <username> -p<password>
ex :
mysql -u root -pAbcd@1234

SHOW DATABASES;

CREATE DATABASE <database-name>;
ex
CREATE DATABASE takenotedb;
CREATE DATABASE takenotedb CHARACTER SET utf8 COLLATE utf8_general_ci;

DROP DATABASE <database-name>;
ex
DROP DATABASE takenotedb;

CREATE USER 'takenote'@'localhost' IDENTIFIED BY 'TakeNote2023';
CREATE USER 'takenote'@'10.1.11.1' IDENTIFIED BY 'TakeNote2023';
CREATE USER 'takenote'@'%' IDENTIFIED BY 'TakeNote2023';

GRANT ALL PRIVILEGES ON *.* TO 'takenote'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'takenote'@'10.1.11.1';
GRANT ALL PRIVILEGES ON *.* TO 'takenote'@'%';
flush privileges;

SELECT host, user, password from mysql.user;

SET PASSWORD FOR "takenote"@"localhost" = PASSWORD("Abcd@1234");
SET PASSWORD FOR "takenote"@"10.1.11.1" = PASSWORD("Abcd@1234");
SET PASSWORD FOR "takenote"@"%" = PASSWORD("Abcd@1234");

ALTER USER "takenote"@"localhost" IDENTIFIED BY "Abcd@1234";
ALTER USER "takenote"@"10.1.11.1" IDENTIFIED BY "Abcd@1234";
ALTER USER "takenote"@"%" IDENTIFIED BY "Abcd@1234";

UPDATE mysql.user SET Password=PASSWORD("Abcd@1234") WHERE USER="takenote" AND Host="localhost";
UPDATE mysql.user SET Password=PASSWORD("nAbcd@1234") WHERE USER="takenote" AND Host="10.1.11.1";
UPDATE mysql.user SET Password=PASSWORD("Abcd@1234") WHERE USER="takenote" AND Host="%";

mysqldump -u <username> -p<password> <database_name> > path/backup_filename.sql
ex
mysqldump -u takenote -pAbcd@1234 takenotedb > /root/backup/takenotedb.sql

mysql -u <username> -p<password> <database_name> < path/backup_filename.sql
mysql -u takenote -pAbcd@1234 takenotedb < /root/backup/takenotedb.sql

mysqldump -u <username> -p<password> <database_name> <table_name> > path/backup_filename.sql
ex
mysqldump -u takenote -pAbcd@1234 takenotedb tbusers > /root/backup/takenotedb.tbusers.sql

mysql -u <username> -p<password> <database_name> < path/backup_filename.sql
mysql -u takenote -pAbcd@1234 takenotedb < /root/backup/takenotedb.tbusers.sql

mysql -u username -p<password> -e 'sql command;'
mysql -u root -pAbcd@1234 -e 'show databases;'

mysql -u <username> -p -h remote.host database -e 'show databases;'