MariaDB
Diverse info
MariaDB on Windows (Intall instructions and general operation info)
How to setup MariaDB SSL and secure connections from clients (Ubuntu/Debian Linux)
MariaDB documentation
MariaDB Basics
CREATE DATABASE
Setting Character Sets and Collations
Supported Character Sets and Collations
Unicode
CREATE USER
SHOW GRANTS
Secure Connections Overview
Skapa en databas
CREATE DATABASE databasnamn CHARACTER SET = "teckenuppsättning" COLLATE = "collate-namn";
Exempel: CREATE DATABASE testdb CHARACTER SET = "utf8" COLLATE = "utf8_general_ci";
Lista databaser med information om teckenuppsättning och collate
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
Exempel:
+--------------+--------------------+----------------------------+------------------------+----------+ | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | +--------------+--------------------+----------------------------+------------------------+----------+ | def | czech_slovak_names | keybcs2 | keybcs2_general_ci | NULL | | def | information_schema | utf8 | utf8_general_ci | NULL | | def | mysql | latin1 | latin1_swedish_ci | NULL | | def | performance_schema | utf8 | utf8_general_ci | NULL | | def | test | latin1 | latin1_swedish_ci | NULL | +--------------+--------------------+----------------------------+------------------------+----------+
Alt 2:
SELECT SCHEMA_NAME 'database', DEFAULT_CHARACTER_SET_NAME 'charset', DEFAULT_COLLATION_NAME 'collation' FROM INFORMATION_SCHEMA.SCHEMATA;
Exempel:
+--------------------+---------+-------------------+ | database | charset | collation | +--------------------+---------+-------------------+ | information_schema | utf8 | utf8_general_ci | | mysql | latin1 | latin1_swedish_ci | | performance_schema | utf8 | utf8_general_ci | | test | latin1 | latin1_swedish_ci | | exdb | utf8 | utf8_general_ci | +--------------------+---------+-------------------+
In the "Get info for a specific database" examples below, replace database name with the name of the database you want to check.
Get info for a specific database (1)
use database name;
SELECT @@character_set_database, @@collation_database;
Get info for a specific database (2)
default_character_set_name, default_collation_name
FROM information_schema.schemata
WHERE schema_name = 'database name';
Get info for all databases on server
FROM information_schema.schemata;
Mer info:
How to Show the Collation of a Database in MySQL
How do I see what character set a MySQL database / table / column is?
Visa privilegier för användare
Visa privilegier för en enskild användare:
SHOW GRANTS FOR 'user'@'localhost';
Visa privilegier för alla användare:
SELECT * from information_schema.user_privileges;
Tillåt / återkalla alla privilegier gällande en databas för en enskild användare
Tillåt alla privilegier:
GRANT ALL PRIVILEGES ON database.* TO 'user'@'%' IDENTIFIED BY 'password';
Återkalla alla privilegier:
REVOKE ALL PRIVILEGES ON database.* FROM 'user'@'%';
database - Namnet på databasen
user - Användarnamnet
Importera & exportera data
Exportera data
mysqldump -u username -p database_name > data_dump.sql
Detta exporterar databasen database_name till sql-filen data_dump.sql.
Efter att du exporterat databasen till en sql-fil kan du kontrollera att det är en korrekt sql-fil med följande kommando:
head -n 5 data_dump.sql
Importera data
Logga in i databasservern, skapa databasen new_database:
create database new_database character set ='utf8' collate = 'utf8_general_ci';
Logga ut med kommandot exit; och kör sedan följande kommando:
mysql -u username -p new_database < data_dump.sql
eller (i Windows): Logga in i databasservern, ladda databasen du vill använda med kommandot use new_database;
Kör sedan följande kommando:
source C:/path/to/data_dump.sql;
Mer info:
How can I import a database with MySQL from terminal?
How To Import and Export Databases in MySQL or MariaDB
Importing Data into MariaDB
Setting Character Sets and Collations