commandes mysql
mysql -u root -p
;
show databasesCREATE DATABASE IF NOT EXISTS
nom-base;
CREATE USER drupaluser
IDENTIFIED BY PASSWORD 'motpasse';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON nom-base
.* TO 'drupaluser'@'localhost' IDENTIFIED BY 'motpasse';
FLUSH PRIVILEGES;
\q
Pour drupal 7 : CREATE DATABASE IF NOT EXISTS db7 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Exports
Exporter une table mysqldump -u root -p TUTORIALS tutorials_tbl > dump_table.txt
Exporter la db mysqldump -u root -p TUTORIALS > database_dump.txt
toutes les db mysqldump -u root -p --all-databases > database_dump.txt
Importer avec mysql -u root -p database_name < dump.txt
Ajout des droits sur base db7 (user db) import dans db7 d'un .sql :
mysql> GRANT ALL PRIVILEGES ON `db7`.* TO 'db'@'%'; FLUSH PRIVILEGES; show grants for 'db'@'%';
mysql> use db7;
mysql> source ../transferts/mig1.sql;
Users
select user,host from mysql.user;
show grants for 'root'@'%';
ALL [PRIVILEGES]
Grant all privileges at specified access level except GRANT OPTION
grant all on *.* to 'uweb'@'192.168.0.3' with grant option;
Donc pour créer un user puissant:
shell> mysql --user=root mysql mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' WITH GRANT OPTION; mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
WITH GRANT OPTION;
mysql> CREATE USER 'admin'@'localhost'; mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> CREATE USER 'dummy'@'localhost'; mysql> FLUSH PRIVILEGES;
plus sur Grant : http://dev.mysql.com/doc/refman/5.6/en/grant.html