pense-bête de bruno sanchiz

installation de phpmyadmin

bruno — 2024-12-08T21:42:31Z

installation normale

systemctl stop apache2 && apt-get install phpmyadmin && systemctl start apache2 && a2enconf phpmyadmin && systemctl reload apache2 && systemctl stop apache2 && systemctl start apache2

marche pour trixie/deb13, on obtient ce fichier /etc/apache2/conf-available/phpmyadmin.conf :

Alias /phpmyadmin /usr/share/phpmyadmin  Options SymLinksIfOwnerMatch DirectoryIndex index.php # limit libapache2-mod-php to files and directories necessary by pma  php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp php_admin_value open_basedir /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/share/javascript/  # PHP 8+  php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp php_admin_value open_basedir /usr/share/phpmyadmin/:/usr/share/doc/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/:/usr/share/javascript/   # Disallow web access to directories that don't need it  Require all denied   Require all denied

autre installation

Si on ne peut pas l'installer normalement, le télécharger sur le site https://files.phpmyadmin.net/phpMyAdmin/ et prendre celui avec le plus grand numéro ; dans l'exemple en dessous on a le fichier phpMyAdmin-4.9.5-all-languages.zip.

7z x phpMyAdmin-4.9.5-all-languages.zip && mv phpMyAdmin-4.9.5-all-languages /usr/share/phpmyadmin && cp /usr/share/phpmyadmin/config.sample.inc.php /usr/share/phpmyadmin/config.inc.php && mkdir -p /usr/share/phpmyadmin/tmp

créer un fichier /etc/apache2/conf-available/phpmyadmin.conf :

# phpMyAdmin default Apache configuration Alias /phpmyadmin /usr/share/phpmyadmin  Options SymLinksIfOwnerMatch DirectoryIndex index.php   AddType application/x-httpd-php .php   SetHandler application/x-httpd-php  php_value include_path . php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/ php_admin_value mbstring.func_overload 0    AddType application/x-httpd-php .php   SetHandler application/x-httpd-php  php_value include_path . php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext/:/usr/share/php/php-php-gettext/:/usr/share/javascript/:/usr/share/php/tcpdf/:/usr/share/doc/phpmyadmin/:/usr/share/php/phpseclib/ php_admin_value mbstring.func_overload 0   # Disallow web access to directories that don't need it  Require all denied   Require all denied   Require all denied

PUIS a2enconf phpmyadmin.conf

Configuration de phpmyadmin

Les variables de phpmyadmin sont configurables dans un fichier config.inc.php. On peut trouver les variables dans https://docs.phpmyadmin.net/fr/latest/config.html

cp /usr/share/phpmyadmin/config.sample.inc.php /usr/share/phpmyadmin/config.inc.php

Exemple : augmenter le temps pour les exécutions de scripts ( importer par exemple )
echo -e "\$cfg['ExecTimeLimit'] = 3000;" >> /usr/share/phpmyadmin/config.inc.php

DOC

ERREUR : Access denied for user 'phpmyadmin'@'localhost

sudo mysql use mysql; CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'supersecretpassword'; SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; exit

ERREUR : phpmyadmin mal configuré : créer la base phpmyadmin

importer le fichier /usr/share/phpmyadmin/sql/create_tables.sql

ERREUR : la configuration/le site a été réinitialisée

Si c'est pendant un upload, augmenter la taille des fichiers de apache et le temps nécessaire pour le lire :

sed -e "s/max_execution_time\ =\ $[0-9]*$/max_execution_time = 30000 /" -e "s/max_input_time\ =\ $[0-9]*$/max_input_time = 60000 /" -e "s/^session.gc_maxlifetime.*/session.gc_maxlifetime=72000/" -e "s#memory_limit =.*#memory_limit = 4096M#" -e "s#post_max_size =.*#post_max_size = 800M#" -e "s#upload_max_filesize =.*#upload_max_filesize = 800M#" -i /etc/php/[0-9].[0-9]/apache2/php.ini && systemctl restart apache2

remise normale :
sed -e "s/max_execution_time\ =\ $[0-9]*$/max_execution_time = 30 /" -e "s/max_input_time\ =\ $[0-9]*$/max_input_time = 60 /" -e "s/^session.gc_maxlifetime.*/session.gc_maxlifetime=1440/" -e "s#memory_limit =.*#memory_limit = 128M#" -e "s#post_max_size =.*#post_max_size = 8M#" -e "s#upload_max_filesize =.*#upload_max_filesize = 2M#" -i /etc/php/[0-9].[0-9]/apache2/php.ini && systemctl restart apache2

ERREUR : La limite de temps pour l'exécution du script a été atteinte

Voir au dessus #configuration

infos mariadb

bruno — 2023-09-27T16:27:55Z

d'après

https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html

exemples de résultats lorsque mariadb marche

mysqladmin --user=root --password=MotDePasse version

mysqladmin Ver 9.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu on x86_64 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Server version 10.11.3-MariaDB-1 Protocol version	10 Connection Localhost via UNIX socket UNIX socket /run/mysqld/mysqld.sock Uptime: 56 min 2 sec Threads: 3 Questions: 2479 Slow queries: 0 Opens: 56 Open tables: 44 Queries per second avg: 0.737

car
/etc/mysql/my.cnf contient socket = /run/mysqld/mysqld.sock
/etc/mysql/my.cnf contient # port = 3306

identique à :

mysqladmin --user=root --password=MotDePasse --protocol=SOCKET --socket=/run/mysqld/mysqld.sock version

mysqladmin Ver 9.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu on x86_64 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Server version 10.11.3-MariaDB-1 Protocol version	10 Connection Localhost via UNIX socket UNIX socket /run/mysqld/mysqld.sock Uptime: 1 hour 4 min 44 sec Threads: 3 Questions: 3456 Slow queries: 0 Opens: 56 Open tables: 44 Queries per second avg: 0.889

ici on force le port 3306

mysqladmin --user=root --password=MotDePasse -h 127.0.0.1 --port=3306 version

mysqladmin Ver 9.1 Distrib 10.11.3-MariaDB, for debian-linux-gnu on x86_64 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Server version 10.11.3-MariaDB-1 Protocol version	10 Connection 127.0.0.1 via TCP/IP TCP port 3306 Uptime: 1 hour 3 min 42 sec Threads: 3 Questions: 3455 Slow queries: 0 Opens: 56 Open tables: 44 Queries per second avg: 0.903

mysqladmin --user=root --password=MotDePasse variables

mysqladmin: connect to server at 'debdix' failed error: 'Can't connect to server on 'debdix' (115)' Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

mysqladmin --user=root --password=MotDePasse -h $(hostname) version variables

mysqladmin: connect to server at 'debdix' failed error: 'Can't connect to server on 'debdix' (115)' Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

mysqladmin --user=root --password=MotDePasse -h $(hostname) --port=3306 version

mysqladmin: connect to server at 'debdix' failed error: 'Can't connect to server on 'debdix' (115)' Check that mariadbd is running and that the socket: '/run/mysqld/mysqld.sock' exists!

commandes mysql

bruno — 2022-12-23T01:49:43Z

INSERT INTO customer_data (customer_id, customer_name, customer_place) VALUES(2, "Vaani","Denver") ON DUPLICATE KEY UPDATE customer_name = "Hevika", customer_place = "Denver";

UPDATE toutes SET chemin='dfkdslmfkml/dsqdsq' where no=12568

SHOW DATABASES; USE PHOTOS ; SHOW TABLES;

sqlite3

bruno — 2022-12-12T15:12:05Z

#docs

$db=new SQLite3('PHOTOS4.sqlite'); $Champs=array("NumeroPhoto","QuiDansLaSerie");

Méthode sans préparation

$result = $db->query('SELECT '.implode(",",$Champs).' FROM toutes WHERE NumeroPhoto="00001" or NumeroPhoto="00002"; '); while ($row=$result->fetchArray()){ //echo"\n\n";print_r($row); foreach ($Champs as $Champ){ echo $row[$Champ]; } }

Méthode avec préparation

$stmt = $db->prepare('SELECT '.implode(",",$Champs).' FROM <code class='spip_code spip_code_inline' dir='ltr'>toutes</code> WHERE <code class='spip_code spip_code_inline' dir='ltr'>NumeroPhoto</code>>:id AND <code class='spip_code spip_code_inline' dir='ltr'>NumeroPhoto</code><:ie'); $stmt->bindValue(':id', 5,SQLITE3_INTEGER); $stmt->bindValue(':ie', 8,SQLITE3_INTEGER); $result = $stmt->execute();/* var_dump($result->fetchArray()); */ while ($row=$result->fetchArray()){ //echo"\n\n";print_r($row); foreach ($Champs as $Champ){ echo $row[$Champ]." "; } }

SQL vers sqlite3

Attention , certaines lignes ne passent pas par cette méthode :

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; COMMIT ALTER TABLE

essai.sql CREATE TABLE <code class='spip_code spip_code_inline' dir='ltr'>essai</code> ( <code class='spip_code spip_code_inline' dir='ltr'>dateuh</code> int(11) NOT NULL, <code class='spip_code spip_code_inline' dir='ltr'>visites</code> int(10) NOT NULL ) ; INSERT INTO <code class='spip_code spip_code_inline' dir='ltr'>essai</code> (<code class='spip_code spip_code_inline' dir='ltr'>dateuh</code>, <code class='spip_code spip_code_inline' dir='ltr'>visites</code>) VALUES (1, 12), (20200201, 5), (20200227, 11), (20200228, 21), (20200229, 21);

cat essai.sql |sqlite3 BaseSqlite.db sqlite3 BaseSqlite.db .dump > dump.sql

dump.sql PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE <code class='spip_code spip_code_inline' dir='ltr'>essai</code> ( <code class='spip_code spip_code_inline' dir='ltr'>dateuh</code> int(11) NOT NULL, <code class='spip_code spip_code_inline' dir='ltr'>visites</code> int(10) NOT NULL ); INSERT INTO essai VALUES(1,12); INSERT INTO essai VALUES(20200201,5); INSERT INTO essai VALUES(20200227,11); INSERT INTO essai VALUES(20200228,21); INSERT INTO essai VALUES(20200229,21); COMMIT;

https://linuxconfig.org/sqlite-linux-tutorial-for-beginners

erreurs mariadb/mysql

bruno — 2022-08-14T00:17:15Z

mysql ne démarre pas

Par exemple :

Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld22.sock' (2)

rm /var/lib/mysql/ib_logfile* résout beaucoup de problèmes de ce genre.

Can't connect to [local] MySQL server

un mot de passe ne marche pas

Le tester autrement
Le changer
- Si ce n'est pas le root, se logguer avec le root et changer le mot de passe.
- Si c'est root, voir changer le mot de passe root du mysql/mariadb

code d'erreurs mariab/mysql

1044 : mauvaises données de connexion
1045 : mauvais mot de passe
2002 : Can't connect

commandes mysql admin

bruno — 2018-12-22T23:03:25Z

Récupérer une base préalablement sauvegardée

mysql --user=NomDeLoginBD --password=MotDePasseBD NomDeLaBase < FichierContenantLesDonnees.sql

Sauvegarder une base de données :

MYSQL_PWD="mot_de_passe" mysqldump -u utilisateur NomDeLaBase > base.sql

Créer une base de données

mysql --user=root --password=mdp < mysqm avec mysqm:'CREATE DATABASE IF NOT EXISTSessai;'

Sauvegarder toutes les bases de données

rep="/SITES\ EN\ COURS/SauvegardesSql/$(date +"%Y%m%d-%H%M%S")" mkdir -p "$rep" cd "$rep" mysql -u00sauvegarde -p'!3?49P^nb8qkL$' -e 'SHOW DATABASES'|egrep -v "^Database$|^information_schema$|^mysql$|^performance_schema$|^user$|^sys$" > ListeDesBaseDeDonnees cat ListeDesBaseDeDonnees |while read NomDeLaBase;do echo "$NomDeLaBase"; MYSQL_PWD='!3?49P^nb8qkL$' mysqldump -u00sauvegarde "$NomDeLaBase" > "$NomDeLaBase".sql; done

Importer toutes les bases de données

cat ListeDesBaseDeDonnees |while read NomDeLaBase;do echo "$NomDeLaBase"; mysql --user=root --password=$(cat mdp) -e 'CREATE DATABASE '"$NomDeLaBase"; mysql --user=root --password=$(cat mdp) "$NomDeLaBase" < "$NomDeLaBase".sql; done

utilisation générale d'un code mysql en ligne de commande bash

mysql --user=NomDeLoginBD --password=MotDePasseBD --database=Base puis source machin.sql;

Création d'une base et d'un utilisateur associé

CREATE DATABASE IF NOT EXISTS `essai` ; CREATE USER 'essai3'@'localhost' IDENTIFIED BY 'a'; GRANT SELECT,INSERT,UPDATE ON `essai` . * TO 'essai3'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; GRANT SELECT,INSERT,UPDATE ON machin.* TO essai@localhost IDENTIFIED BY 'stupid'; GRANT ALL PRIVILEGES ON `essai3` . * TO 'essai3'@'localhost';

Augmenter la taille des packets :
se logguer puis set global max_allowed_packet=64*1024*1024;

changer le mot de passe root du mysql/mariadb

bruno — 2018-12-20T23:03:30Z

mettre un nouveau mot de passe : solution 2024/bookworm

Parfois, il est impossible de changer correctement le mot de passe comme indiqué en dessous ; une solution : nettoyer la table user

service mariadb stop ; service mysql stop ; service mysqld stop ; /etc/init.d/mysql stop ; /etc/init.d/mysqld stop service mariadb start ; service mysql start ; service mysqld start ; /etc/init.d/mysql start ; /etc/init.d/mysqld start mysql -u root use mysql; select * from user; truncate table user; flush privileges; grant all privileges on *.* to root@localhost identified by 'Motdepasse' with grant option; flush privileges; quit; service mysql stop ; service mysqld stop ; /etc/init.d/mysql stop ; /etc/init.d/mysqld stop service mysql start ; service mysqld start ; /etc/init.d/mysql start ; /etc/init.d/mysqld start

mettre un nouveau mot de passe : solution 2023/bullseye

service mysql stop ; service mysqld stop ; /etc/init.d/mysql stop ; /etc/init.d/mysqld stop service mysql start ; service mysqld start ; /etc/init.d/mysql start ; /etc/init.d/mysqld start mysql -u root ALTER USER 'root'@'localhost' IDENTIFIED BY 'Nouveau motdepasse'; flush privileges ;

mettre un nouveau mot de passe

Arrêter le serveur mysql ( erreurs normales )

service mysql stop ; service mysqld stop ; /etc/init.d/mysql stop ; /etc/init.d/mysqld stop

Démarrer le serveur mysql sans mot de passe :

mysqld_safe --skip-grant-tables &

on se connecte à mysql :

mysql -u root

Dans mysql , on va 1)choisir la base de donnée mysql, 2)mettre à jour le mot de passe root puis 3)on intègre le mot de passe à mysql ; 4) on sort

use mysql; update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; flush privileges; quit

on redémarre

service mysql start ; service mysqld start ; /etc/init.d/mysql start ; /etc/init.d/mysqld start

test : mot de passe changé et accepté

mysql -u root doit donner
ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password : NO)

mot de passe changé mais non accepté

Parfois le mot de passe est bon mais tout est comme si le mot de passe n'était pas accepté :
solution rapide : sur debian l'option 1 marche,donc

$ sudo mysql -u root # I had to use "sudo" since is new installation mysql> USE mysql; UPDATE user SET plugin='mysql_native_password' WHERE User='root'; FLUSH PRIVILEGES; exit;

https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost :
Some systems like Ubuntu, mysql is using by default the UNIX auth_socket plugin.

Basically means that : db_users using it, will be "auth" by the system user credentias. You can see if your root user is set up like this by doing the following :

non essayé : mysqladmin -u root -p"mdp_root" password "nouveau_mdp";

recherche de solution

mysql -u root mysql> USE mysql; SELECT User, Host, plugin FROM mysql.user;

User	plugin
root	unix_socket ( ou auth_socket )
mysql.sys	mysql_native_password
debian-sys-maint	mysql_native_password

As you can see in the query, the root user is using the auth_socket plugin

There are 2 ways to solve this :

You can set the root user to use the mysql_native_password plugin
You can create a new db_user with you system_user (recommended)

Option 1 :

mysql -u root mysql> USE mysql; UPDATE user SET plugin='unix_socket' WHERE User='root'; FLUSH PRIVILEGES; exit; service mysql restart

Option 2 : (replace YOUR_SYSTEM_USER with the username you have)

mysql -u root mysql> USE mysql; CREATE USER 'YOUR_SYSTEM_USER'@'localhost' IDENTIFIED BY ''; GRANT ALL PRIVILEGES ON *.* TO 'YOUR_SYSTEM_USER'@'localhost'; UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER'; FLUSH PRIVILEGES; exit; service mysql restart

Remember that if you use option #2 you'll have to connect to mysql as your system username (mysql -u YOUR_SYSTEM_USER)

Note : On some systems (e.g., Debian stretch) 'auth_socket' plugin is called 'unix_socket', so the corresponding SQL command should be : UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';

voir aussi /usr/bin/mysql_secure_installation

https://memo-linux.com/reinitialiser-le-mot-de-passe-root-oublie-pour-mariadb-ou-mysql-serveur-en-5-etapes/

liste de sites

bruno — 2018-11-04T00:12:48Z

https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

probleme chez free

requetes mysql

bruno — 2018-04-23T23:52:36Z

sélectionner les permissiosn des utilisateurs

select * from information_schema.user_privileges;

GRANTEE	TABLE_CATALOG	PRIVILEGE_TYPE	IS_GRANTABLE
user1@%	def	USAGE	NO
user2@%	def	USAGE	NO
user3@%	def	USAGE	NO

fonctions

https://mariadb.com/kb/fr/concat/
concat ( chaine1, chaine2)
- ex : update photos set groupe=concat(groupe,'animaux')

concat_ws ( separateur,chaine1, chaine2)

ex :

update essai set visites=concat_ws(",",visites,'animaux');

https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html

INSERT
- INSERT [INTO] table [(colonne1,colonne2,colonne3,...)] VALUES (valeur1,valeur2,valeur3,...)
- on peut rajouter ON DUPLICATE KEY UPDATE
SELECT
- SELECT [options] items [INTO file_details] FROM tables [ WHERE conditions ] [ GROUPS BY group_type ] [ HAVING where_condition ] [ ORDER BY order_type DESC|ASC] [ LIMIT limit_criteria ] [ PROCEDURE proc_name(arguments)] [lock_options]
UPDATE
- UPDATE [LOW_PRIORITY] [IGNORE] nomtable SET colonne1=expression1,colonne2=expression2,... [WHERE condition] [ORDER BY critères de tri] [LIMITE nombre]
ALTER TABLE
CREATE DATABASE
CREATE USER / GRANT

SELECT

SELECT [options] items [INTO file_details] FROM tables [ WHERE conditions ] [ GROUPS BY group_type ] [ HAVING where_condition ] [ ORDER BY order_type DESC|ASC] [ LIMIT limit_criteria ] [ PROCEDURE proc_name(arguments)] [lock_options] SELECT id FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A WHERE 1 limit 0,25 SELECT id FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A WHERE A.id<10 limit 0,25 SELECT A.id,B.id FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A,<code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS B WHERE A.md5=B.md5 limit 0,25 SELECT A.id,B.id FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A,<code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS B WHERE A.id!= B.id and A.md5=B.md5 limit 0,25 SELECT A.*,B.* FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A,<code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS B WHERE A.id!= B.id and A.md5=B.md5 limit 0,25 Q: SELECT A.id FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A WHERE A.id>= ALL ( select id FROM PYTHONS) limit 0,25 R: 1 réponse Q: SELECT A.id FROM <code class='spip_code spip_code_inline' dir='ltr'>PYTHONS</code> AS A WHERE A.id> ANY ( select id FROM PYTHONS) limit 0,25 R: TOTAL - 1 réponses SELECT x,y,z FROM Points1 WHERE (x,y,z) in (SELECT x,y,z FROM Points2)

INSERT

INSERT [INTO] table [(colonne1,colonne2,colonne3,...)] VALUES (valeur1,valeur2,valeur3,...) INSERT INTO points (x,y,z) VALUES (8.5,5.6,-5.6)

UPDATE

UPDATE [LOW_PRIORITY] [IGNORE] nomtable SET colonne1=expression1,colonne2=expression2,... [WHERE condition] [ORDER BY critères de tri] [LIMITE nombre] UPDATE homothetie set longueur=longueur * 1.5 UPDATE homothetie set longueur=longueur * 1.5 where id=5 UPDATE <code class='spip_code spip_code_inline' dir='ltr'>BLENDERSpoub</code> SET <code class='spip_code spip_code_inline' dir='ltr'>NomLong</code> = REPLACE(<code class='spip_code spip_code_inline' dir='ltr'>NomLong</code>, '/media/a/Elements', '/media/a/E2/Elements') WHERE <code class='spip_code spip_code_inline' dir='ltr'>NomLong</code> LIKE '%/media/a/Elements%' COLLATE utf8mb4_bin

CREATE DATABASE

CREATE DATABASE IF NOT EXISTS <code class='spip_code spip_code_inline' dir='ltr'>basededonnee</code> ; mysql --user=root --password=mdp < mysqm avec mysqm:'CREATE DATABASE IF NOT EXISTS <code class='spip_code spip_code_inline' dir='ltr'>basededonnee</code> ;'

CREATE USER

CREATE USER 'nom'@'localhost' IDENTIFIED BY 'mdp'; GRANT SELECT,INSERT,UPDATE ON <code class='spip_code spip_code_inline' dir='ltr'>basededonnee</code> . * TO 'nom'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; GRANT SELECT,INSERT,UPDATE ON micalaur.* TO basededonnee@localhost IDENTIFIED BY 'mdp'; GRANT ALL PRIVILEGES ON <code class='spip_code spip_code_inline' dir='ltr'>nom</code> . * TO 'nom'@'localhost'; CREATE USER 'a09.gfsd'@'localhost' IDENTIFIED BY 'gfd456456j'; GRANT SELECT,INSERT,UPDATE ON <code class='spip_code spip_code_inline' dir='ltr'>wind04.5</code> . * TO 'a04.5gfsd'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE USER 'nom'@'localhost' IDENTIFIED BY 'mdp'; GRANT SELECT,INSERT,UPDATE ON <code class='spip_code spip_code_inline' dir='ltr'>basededonnee</code> . * TO 'nom'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE USER 'a09.gfsd'@'localhost' IDENTIFIED BY 'ljkljklhj';# MySQL a retourné un résultat vide (aucune ligne). GRANT SELECT,INSERT,UPDATE ON <code class='spip_code spip_code_inline' dir='ltr'>wind09</code> . * TO 'a09.gfsd'@'localhost' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;# MySQL a retourné un résultat vide (aucune ligne).

chiffrage des données

INSERT INTO dossiersSecrets(titre, contenu) VALUES ('$titre', AES_ENCRYPT('AA','BB')); SELECT titre, AES_DECRYPT(contenu,'motdepasse') AS contenu FROM dossiersSecrets;