show databases;
show databases like 'test%' #wild apres test
show full processlist;
 
create database testpierre;
create TABLE user ( id INT PRIMARY KEY NOT NULL, nom VARCHAR(64), prenom VARCHAR(64), birth_date DATE );
show columns from user;
 
rename table user to user2;
rename table user2 to user;
 
INSERT user VALUES('1','Pierre','Bourdin','1987-08-05');
select * from user;
 
ALTER TABLE user MODIFY id INTEGER NOT NULL AUTO_INCREMENT;
 
delete  from power where mdate = "2021-05-26 11:51:48";
 
SELECT user,host,password FROM mysql.user;
 
UPDATE mysql.user SET password=PASSWORD("nouveau_mdp") where User="axance_octo_WP18";
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
FLUSH PRIVILEGES;
 
UPDATE oc_share SET uid_owner="Clementine" where token="MT5PxYfx3APHdKH";
 
INSERT INTO address (domain_id, address, password, enabled, expire_date, update_date, mail_action)
VALUES ('2', 'pierre', '$1$DMrhukof$I9nzULanQwo/33K6r2l93.', '1', NULL, '2021-06-22 09:41:27', 'OK');
 
 
 
 
CREATE USER 'username' IDENTIFIED BY 'password';
CREATE USER 'jo2020' IDENTIFIED BY 'ru8Aigeboa3IicaeGo7oquee0ohn3Ere';

CREATE USER 'boaconcept_wp' IDENTIFIED BY 'SxV1iTs9J5nZtRPL';
CREATE DATABASE boaconcept_wp;
GRANT ALL PRIVILEGES ON boaconcept_wp.* TO "boaconcept_wp"@"localhost" IDENTIFIED BY "SxV1iTs9J5nZtRPL";
FLUSH PRIVILEGES;

use mysql;
GRANT ALL PRIVILEGES ON *.* TO adminmysql@localhost
IDENTIFIED BY 'lemotdepasse' WITH GRANT OPTION;
FLUSH PRIVILEGES;

SELECT
  table_schema AS NomBaseDeDonnees, 
  ROUND(SUM( data_length + index_length ) / 1024 / 1024, 2) AS BaseDonneesMo 
FROM information_schema.TABLES
GROUP BY TABLE_SCHEMA;

• Changer le password d'un compte :

use dbispconfig;
UPDATE sys_user SET passwort = md5('Admin123') WHERE username = 'admin';