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;
 
 
===== AlternC =====
====changer un password user====
<code mysql>
UPDATE mysql.user SET password=PASSWORD("nouveau_mdp") where User="axance_octo_WP18";
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

je ne sais plus ce que c'est…

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 '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;

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