Différences

Ci-dessous, les différences entre deux révisions de la page.

--- cherry:mysql_notes [2021/11/26 15:48] – pierre
+++ cherry:mysql_notes [2021/12/20 17:01] (Version actuelle) – supprimée pierre
@@ Ligne 1: / Ligne 1: @@
-====== NOTES SQL ======
-===== Vrac =====
-<code mysql>
-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';
-</code>
-===== Création d'un utilisateur et d'un DB =====
-<code mysql>
-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;
-</code>
-===== Creation d'un utilisateur non-root mais root quand même =====
-<code mysql>
-use mysql;
-GRANT ALL PRIVILEGES ON *.* TO adminmysql@localhost
-IDENTIFIED BY 'lemotdepasse' WITH GRANT OPTION;
-FLUSH PRIVILEGES;
-</code>
-===== Mesurer la taille des bases de données =====
-<code mysql>
-SELECT
-  table_schema AS NomBaseDeDonnees,
-  ROUND(SUM( data_length + index_length ) / 1024 / 1024, 2) AS BaseDonneesMo
-FROM information_schema.TABLES
-GROUP BY TABLE_SCHEMA;
-</code>
-===== ISPConfig =====
-     * Changer le password d'un compte :
-<code mysql>
-use dbispconfig;
-UPDATE sys_user SET passwort = md5('Admin123') WHERE username = 'admin';
-</code>

Pi3rrot.net

Outils pour utilisateurs

Outils du site

Différences

Outils de la page