commandes mysql

Tags:

mysql -u root -p
show databases
;
CREATE 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