Discussion :

[surfeur22]

Bonjour,

J'utilise XAMPP avec apache et mysql.

Cela fait quelques jours que j'ai les problèmes suivants :

Lorsque j'effectue des tâches simples il y a beaucoup de messages d'erreurs !

Par exemple j'ai crée une simple table avec le formulaire, une table avec 4 champs, j'appuie sur exécuter et là plein d'erreurs. ?

Cela a fini quand même par créer la table mais je ne peux pas la voir, si je fais editer sur l'erreur j'ai ceci :

Impossible d'enregistrer les tables récentes !

#1142 - INSERT, DELETE command denied to user 'pma'@'localhost' for table 'pma__recent'

Puis plus bas le code sql :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
SELECT `prefs` FROM `phpmyadmin`.`pma__table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'don' AND `table_name` = 'ventes'

merci d'avance !

[Artemus24]

Salut surfeur22.

Lorsque j'effectue des tâches simples il y a beaucoup de messages d'erreurs !

Quelles sont les messages qui vous obtenez ?

#1142 - INSERT, DELETE command denied to user 'pma'@'localhost' for table 'pma__recent'

Avec le compte mpa, vous n'êtes pas autorisé à insérer ou supprimer quoi que ce soit dans la table 'pma__recent'.
Vous devez modifier les privilèges du compte 'pma' avec votre compte administrateur 'root'.

@+

[surfeur22]

je me connecte en modifiant l'adresse url, comme ceci : http://localhost:8090/phpmyadmin

Je ne vois pas un bouton de déconnexion ou de connexion ?

[surfeur22]

J'ai essayé de changer les droits de l'utilisateur pma à l'aide de la console de XAmPP.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
MariaDB[(none)]>
 
grant all privileges on don.* to pma@localhost;

et j'ai ce message :

Error 1034(HY000): Index for table 'db' is corrupt; try to repair it.

j'ai tapé la commande

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

mysql -V

et j'ai cette réponse :

mysql ver 15.1 Distrib 10.4.19 - MariaDB

-----------------------------

Plus rien ne fonctionne aujourd'hui sij'essaye de lance mysql, il ne démarre pas et il n'affiche plus les informations sur mon site

SQLSTATE[HY000] [2002] Aucune connexion n�a pu �tre �tablie car l�ordinateur cible l�a express�ment refus�e.

-----------------

Voila ce que me dit mysql :

6:04:29 [mysql] Status change detected: stopped
06:04:29 [mysql] Error: MySQL shutdown unexpectedly.
06:04:29 [mysql] This may be due to a blocked port, missing dependencies,
06:04:29 [mysql] improper privileges, a crash, or a shutdown by another method.
06:04:29 [mysql] Press the Logs button to view error logs and check
06:04:29 [mysql] the Windows Event Viewer for more clues
06:04:29 [mysql] If you need more help, copy and post this
06:04:29 [mysql] entire log window on the forums


-----------------

Log :

***WARNING: .\mysql\db could not be opened: Error: 126
61% 72% 85% 98% 100% (0.1 seconds); tables to flush: 1 0
(0.1 seconds);

0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-13 6:56:46 0 [Note] Server socket created on IP: '::'.
2021-07-13 6:56:53 0 [ERROR] InnoDB: Operating system error number 32 in a file operation.
2021-07-13 6:56:53 0 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.
2021-07-13 6:57:03 0 [ERROR] InnoDB: Operating system error number 32 in a file operation.
2021-07-13 6:57:03 0 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.
2021-07-13 6:57:13 0 [ERROR] InnoDB: Operating system error number 32 in a file operation.
2021-07-13 6:57:13 0 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.


----------------

2021-07-24 6:00:15 0 [Note] mysqld.exe: Aria engine: recovery done
2021-07-24 6:00:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:00:15 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:00:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:00:15 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:00:15 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:00:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:00:15 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:00:15 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3965569
2021-07-24 6:00:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:00:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-07-24 6:00:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:00:16 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:00:16 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:00:16 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:00:16 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965578; transaction id 7881
2021-07-24 6:00:16 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:00:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:00:16 0 [Note] Server socket created on IP: '::'.
2021-07-24 6:00:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:00:37 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:00:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:00:37 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:00:37 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:00:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:00:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:00:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:00:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:00:38 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:00:38 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:00:38 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:00:38 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965587; transaction id 7881
2021-07-24 6:00:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:00:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:00:38 0 [Note] Server socket created on IP: '::'.
2021-07-24 6:00:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:00:57 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:00:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:00:57 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:00:57 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:00:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:00:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:00:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:00:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:00:58 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:00:58 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:00:58 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:00:58 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965596; transaction id 7881
2021-07-24 6:00:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:00:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:00:58 0 [Note] Server socket created on IP: '::'.
2021-07-24 6:01:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:01:30 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:01:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:01:30 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:01:30 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:01:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:01:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:01:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:01:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:01:30 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:01:30 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:01:30 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:01:30 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965605; transaction id 7881
2021-07-24 6:01:30 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:01:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:01:30 0 [Note] Server socket created on IP: '::'.
2021-07-24 6:04:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:04:06 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:04:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:04:06 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:04:06 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:04:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:04:06 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:04:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:04:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:04:07 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:04:07 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:04:07 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:04:07 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965614; transaction id 7881
2021-07-24 6:04:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:04:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:04:07 0 [Note] Server socket created on IP: '::'.
2021-07-24 6:04:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:04:26 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:04:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:04:26 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:04:26 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:04:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:04:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:04:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:04:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:04:27 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:04:27 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:04:27 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:04:27 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965623; transaction id 7881
2021-07-24 6:04:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:04:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:04:27 0 [Note] Server socket created on IP: '::'.
2021-07-24 6:09:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-07-24 6:09:02 0 [Note] InnoDB: Uses event mutexes
2021-07-24 6:09:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-07-24 6:09:02 0 [Note] InnoDB: Number of pools: 1
2021-07-24 6:09:02 0 [Note] InnoDB: Using generic crc32 instructions
2021-07-24 6:09:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-07-24 6:09:02 0 [Note] InnoDB: Completed initialization of buffer pool
2021-07-24 6:09:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-07-24 6:09:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-07-24 6:09:02 0 [Note] InnoDB: Setting file 'C:\xampp\Dev\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-07-24 6:09:02 0 [Note] InnoDB: File 'C:\xampp\Dev\mysql\data\ibtmp1' size is now 12 MB.
2021-07-24 6:09:02 0 [Note] InnoDB: Waiting for purge to start
2021-07-24 6:09:03 0 [Note] InnoDB: 10.4.19 started; log sequence number 3965632; transaction id 7881
2021-07-24 6:09:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\Dev\mysql\data\ib_buffer_pool
2021-07-24 6:09:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-07-24 6:09:03 0 [Note] Server socket created on IP: '::'.

[surfeur22]

J'ai réinstallé xampp !