Problème phpmyadmin
Access denied ---> phpmyadmin.conf
Système et matériels / Réseau Internet Wi-Fi
xunil2003 Membre non connecté
-
- Voir le profil du membre xunil2003
- Inscrit le : 17/02/2011
- Groupes :
J'ai installé Mageia 2.
lorsque je tape dans le navigateur "http://192.168.0.2/phpmyadmin"
j'ai ce message qui s'affiche dans le navigateur
Access denied per /etc/httpd/conf/webapps.d/phpmyadmin.conf
Alors qu'avec "http://127.0.0.1/phpmyadmin " ca marche.
Quand je tape "http://192.168.0.2/" j'ai bien
It works!
qui s'affiche.1/ Que faut il faire pour avoir access a phpadmin sur l'url "http://192.168.0.2/phpmyadmin" ?
2/ Je ne me rappel plus du nom d'utilisateur et dumot de passe de phpadmin, comment puis je le changer ?
Edité le 15/07/12 à 15:59
Ok avec nano j'ai edité le fichier "/etc/httpd/conf/webapps.d/phpmyadmin.conf" puis j'ai remplacé la ligne "Allow from 127.0.0.1" par "Allow from 127.0.0.1 192.168" ca marche.
Mais Je ne me rappel plus du nom d'utilisateur et du mot de passe de phpadmin, comment puis je le changer ?
Merci
Édité par xunil2003 Le 15/07/2012 à 16h44
xuo Membre non connecté
-
- Voir le profil du membre xuo
- Inscrit le : 23/10/2011
- Groupes :
Je rebondis sur ce sujet car dans mon cas, le message d'erreur est différent. J'ai :
Redirecting... (error: Error: Permission denied to access property 'document'
Après avoir fait "OK", j'ai la page qui s'affiche et comme je connais mon mot de passe, je n'ai pas de problème
.Par contre, savez-vous comment me débarrasser de ce message ? Je me connecte avec mon adresse IP externe (pas en 192).
Merci.
Xuo.
Adrien.D Membre non connecté
-
- Voir le profil du membre Adrien.D
- Inscrit le : 30/05/2011
- Site internet
- Groupes :
Tu te connectes en root en console via la commande mysql -u root (autorisé sans mot de passe sur 127.0.0.1)
Puis exécutes ces commandes :
Code SQL :
USE mysql; UPDATE USER SET password=PASSWORD('unmotdepasse') WHERE USER='tonutilisateur'; FLUSH PRIVILEGES;
La première commande te permet de sélectionner la base mysql.
La deuxième te permet de recrééer un nouveau mot de passe à ton utilisateur de base de données.
La troisième commande te permet de rafraichir les privilèges et ainsi que ton mot de passe soit effectif.
Tu peux tester en console alors de te reconnecter via mysql -u tonsuer -ptonmotdepasse.
A+
Config : PC Fixe : X470 GAMING PRO- AMD Ryzen 5 2600X - 16Go RAM - Radeon RX 560 (Pilote libre) - Gentoo Linux - GNOME Desktop - Kernel 5.10 LTS
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
xunil2003 Membre non connecté
-
- Voir le profil du membre xunil2003
- Inscrit le : 17/02/2011
- Groupes :
Pour la premiere commande il me rèpond
[root@localhost laurent]# mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost laurent]#
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost laurent]#
Merci.
Édité par xunil2003 Le 15/07/2012 à 18h45
Adrien.D Membre non connecté
-
- Voir le profil du membre Adrien.D
- Inscrit le : 30/05/2011
- Site internet
- Groupes :
MySQL est démarré ?
Code BASH :
/etc/init.d/mysqld status
A+
Config : PC Fixe : X470 GAMING PRO- AMD Ryzen 5 2600X - 16Go RAM - Radeon RX 560 (Pilote libre) - Gentoo Linux - GNOME Desktop - Kernel 5.10 LTS
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
xunil2003 Membre non connecté
-
- Voir le profil du membre xunil2003
- Inscrit le : 17/02/2011
- Groupes :
Je m'aperçois que mysql ne démarre pas
[root@localhost laurent]# /etc/init.d/mysqld status
[ÉCHEC ]
[root@localhost laurent]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job failed. See system journal and 'systemctl status' for details.
[ÉCHEC ]
[root@localhost laurent]#
[ÉCHEC ]
[root@localhost laurent]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job failed. See system journal and 'systemctl status' for details.
[ÉCHEC ]
[root@localhost laurent]#
Merci.
Adrien.D Membre non connecté
-
- Voir le profil du membre Adrien.D
- Inscrit le : 30/05/2011
- Site internet
- Groupes :
Ouvres deux consoles; une ou tu fais :
Code BASH :
tail -f /var/log/messages
laisses la console active puis sur une autre console, effectues ceci:
Code BASH :
/etc/init.d/mysqld stop /etc/init.d/mysqld start
Puis postes nous ce qui s'est affiché dans la première console (avec la commande tail -f) pour savoir et essayer de comprendre pourquoi mysql ne démarre pas.
Merci
Édité par Adrien.D Le 15/07/2012 à 19h09
Config : PC Fixe : X470 GAMING PRO- AMD Ryzen 5 2600X - 16Go RAM - Radeon RX 560 (Pilote libre) - Gentoo Linux - GNOME Desktop - Kernel 5.10 LTS
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
xunil2003 Membre non connecté
-
- Voir le profil du membre xunil2003
- Inscrit le : 17/02/2011
- Groupes :
Quand je fait
[root@localhost laurent]# /etc/init.d/mysqld stop
Stopping mysqld (via systemctl): [ OK ]
[root@localhost laurent]#
Stopping mysqld (via systemctl): [ OK ]
[root@localhost laurent]#
dans le premier terminal il saffiche
[root@localhost laurent]# tail -f /var/log/messages
Jul 15 19:13:17 localhost smbd[3403]: [2012/07/15 19:13:17.629244, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:13:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:14:17 localhost smbd[18934]: [2012/07/15 19:14:17.691307, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:14:17 localhost smbd[18934]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:14:17 localhost smbd[3403]: [2012/07/15 19:14:17.691574, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:14:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:15:17 localhost smbd[19008]: [2012/07/15 19:15:17.747890, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:15:17 localhost smbd[19008]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:15:17 localhost smbd[3403]: [2012/07/15 19:15:17.748090, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:15:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:16:17 localhost smbd[19102]: [2012/07/15 19:16:17.806516, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:16:17 localhost smbd[19102]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:16:17 localhost smbd[3403]: [2012/07/15 19:16:17.806643, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:16:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:13:17 localhost smbd[3403]: [2012/07/15 19:13:17.629244, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:13:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:14:17 localhost smbd[18934]: [2012/07/15 19:14:17.691307, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:14:17 localhost smbd[18934]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:14:17 localhost smbd[3403]: [2012/07/15 19:14:17.691574, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:14:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:15:17 localhost smbd[19008]: [2012/07/15 19:15:17.747890, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:15:17 localhost smbd[19008]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:15:17 localhost smbd[3403]: [2012/07/15 19:15:17.748090, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:15:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:16:17 localhost smbd[19102]: [2012/07/15 19:16:17.806516, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:16:17 localhost smbd[19102]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:16:17 localhost smbd[3403]: [2012/07/15 19:16:17.806643, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:16:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
puis quand je tape
[root@localhost laurent]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): Job failed. See system journal and 'systemctl status' for details.
[ÉCHEC ]
[root@localhost laurent]#
Starting mysqld (via systemctl): Job failed. See system journal and 'systemctl status' for details.
[ÉCHEC ]
[root@localhost laurent]#
il s'affiche de le premier terminal
Jul 15 19:17:43 localhost sensord: MB Temperature: 50.0 C
Jul 15 19:17:43 localhost sensord: NB Temperature: 63.0 C
Jul 15 19:18:17 localhost smbd[19247]: [2012/07/15 19:18:17.909940, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:18:17 localhost smbd[19247]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:18:17 localhost smbd[3403]: [2012/07/15 19:18:17.910209, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:18:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:19:17 localhost smbd[19319]: [2012/07/15 19:19:17.922355, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:19:17 localhost smbd[19319]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:19:17 localhost smbd[3403]: [2012/07/15 19:19:17.922624, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:19:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:19:51 localhost mysqld_safe[19401]: 120715 19:19:51 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:51 localhost mysqld_safe[19401]: 120715 19:19:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:51 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:52 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:52 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:52 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:52 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:53 localhost mysqld_safe[19828]: 120715 19:19:53 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:53 localhost mysqld_safe[19828]: 120715 19:19:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:53 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:54 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:54 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:54 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:54 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:54 localhost mysqld_safe[20249]: 120715 19:19:54 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:54 localhost mysqld_safe[20249]: 120715 19:19:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:54 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:55 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:55 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:55 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:55 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:56 localhost mysqld_safe[20671]: 120715 19:19:56 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:56 localhost mysqld_safe[20671]: 120715 19:19:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:56 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:57 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:57 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:57 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:57 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:57 localhost mysqld_safe[21105]: 120715 19:19:57 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:57 localhost mysqld_safe[21105]: 120715 19:19:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:57 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:58 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:58 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:58 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:58 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:58 localhost mysqld_safe[21525]: 120715 19:19:58 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:58 localhost mysqld_safe[21525]: 120715 19:19:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:58 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:59 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:20:00 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:20:00 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:20:00 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:20:00 localhost systemd[1]: mysqld.service start request repeated too quickly, refusing to start.
Jul 15 19:20:17 localhost smbd[21942]: [2012/07/15 19:20:17.979513, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:20:17 localhost smbd[21942]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:20:17 localhost smbd[3403]: [2012/07/15 19:20:17.979762, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:20:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:17:43 localhost sensord: NB Temperature: 63.0 C
Jul 15 19:18:17 localhost smbd[19247]: [2012/07/15 19:18:17.909940, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:18:17 localhost smbd[19247]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:18:17 localhost smbd[3403]: [2012/07/15 19:18:17.910209, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:18:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:19:17 localhost smbd[19319]: [2012/07/15 19:19:17.922355, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:19:17 localhost smbd[19319]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:19:17 localhost smbd[3403]: [2012/07/15 19:19:17.922624, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:19:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
Jul 15 19:19:51 localhost mysqld_safe[19401]: 120715 19:19:51 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:51 localhost mysqld_safe[19401]: 120715 19:19:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:51 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:52 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:52 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:52 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:52 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:53 localhost mysqld_safe[19828]: 120715 19:19:53 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:53 localhost mysqld_safe[19828]: 120715 19:19:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:53 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:54 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:54 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:54 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:54 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:54 localhost mysqld_safe[20249]: 120715 19:19:54 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:54 localhost mysqld_safe[20249]: 120715 19:19:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:54 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:55 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:55 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:55 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:55 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:56 localhost mysqld_safe[20671]: 120715 19:19:56 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:56 localhost mysqld_safe[20671]: 120715 19:19:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:56 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:57 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:57 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:57 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:57 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:57 localhost mysqld_safe[21105]: 120715 19:19:57 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:57 localhost mysqld_safe[21105]: 120715 19:19:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:57 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:58 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:19:58 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:19:58 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:19:58 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:19:58 localhost mysqld_safe[21525]: 120715 19:19:58 mysqld_safe Logging to '/var/log/mysqld/mysqld.log'.
Jul 15 19:19:58 localhost mysqld_safe[21525]: 120715 19:19:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Jul 15 19:19:58 localhost systemd[1]: mysqld.service: main process exited, code=exited, status=1
Jul 15 19:19:59 localhost systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 15 19:20:00 localhost systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 15 19:20:00 localhost systemd[1]: Job pending for unit, delaying automatic restart.
Jul 15 19:20:00 localhost systemd[1]: Unit mysqld.service entered failed state.
Jul 15 19:20:00 localhost systemd[1]: mysqld.service start request repeated too quickly, refusing to start.
Jul 15 19:20:17 localhost smbd[21942]: [2012/07/15 19:20:17.979513, 0] printing/print_cups.c:110(cups_connect)
Jul 15 19:20:17 localhost smbd[21942]: Unable to connect to CUPS server localhost:631 - Connexion refusée
Jul 15 19:20:17 localhost smbd[3403]: [2012/07/15 19:20:17.979762, 0] printing/print_cups.c:487(cups_async_callback)
Jul 15 19:20:17 localhost smbd[3403]: failed to retrieve printer list: NT_STATUS_UNSUCCESSFUL
cat /var/log/mysqld/mysqld.log
I[root@localhost laurent]# cat /var/log/mysqld/mysqld.log
nnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120715 19:19:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120715 19:19:57 InnoDB: The InnoDB memory heap is disabled
120715 19:19:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120715 19:19:57 InnoDB: Compressed tables use zlib 1.2.6
120715 19:19:57 InnoDB: Using Linux native AIO
120715 19:19:57 InnoDB: Initializing buffer pool, size = 128.0M
120715 19:19:57 InnoDB: Completed initialization of buffer pool
120715 19:19:57 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120715 19:19:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120715 19:19:58 InnoDB: The InnoDB memory heap is disabled
120715 19:19:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120715 19:19:58 InnoDB: Compressed tables use zlib 1.2.6
120715 19:19:58 InnoDB: Using Linux native AIO
120715 19:19:58 InnoDB: Initializing buffer pool, size = 128.0M
120715 19:19:58 InnoDB: Completed initialization of buffer pool
120715 19:19:58 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
[root@localhost laurent]#
nnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120715 19:19:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120715 19:19:57 InnoDB: The InnoDB memory heap is disabled
120715 19:19:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120715 19:19:57 InnoDB: Compressed tables use zlib 1.2.6
120715 19:19:57 InnoDB: Using Linux native AIO
120715 19:19:57 InnoDB: Initializing buffer pool, size = 128.0M
120715 19:19:57 InnoDB: Completed initialization of buffer pool
120715 19:19:57 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
120715 19:19:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120715 19:19:58 InnoDB: The InnoDB memory heap is disabled
120715 19:19:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120715 19:19:58 InnoDB: Compressed tables use zlib 1.2.6
120715 19:19:58 InnoDB: Using Linux native AIO
120715 19:19:58 InnoDB: Initializing buffer pool, size = 128.0M
120715 19:19:58 InnoDB: Completed initialization of buffer pool
120715 19:19:58 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
[root@localhost laurent]#
Merci.
Adrien.D Membre non connecté
-
- Voir le profil du membre Adrien.D
- Inscrit le : 30/05/2011
- Site internet
- Groupes :
Citation :
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: the directory.
Quelles sont les permissions du dossier mysql ? Est-ce bien mysql le propriétaire du dossier ?
Lorsque tu as installé Mageia2, tu as fait une migration ?
Code BASH :
ls -l /var/lib/ | grep mysql
Voici pour ma part:
Code BASH :
9 [SERVER] [19:32:37] root@valiona: /var/lib # ls -l /var/lib/ | grep mysql drwxr-xr-x 10 mysql mysql 4096 juil. 11 19:08 mysql/
A+
Édité par Adrien.D Le 15/07/2012 à 19h35
Config : PC Fixe : X470 GAMING PRO- AMD Ryzen 5 2600X - 16Go RAM - Radeon RX 560 (Pilote libre) - Gentoo Linux - GNOME Desktop - Kernel 5.10 LTS
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
xunil2003 Membre non connecté
-
- Voir le profil du membre xunil2003
- Inscrit le : 17/02/2011
- Groupes :
Voila les permissions
[root@localhost laurent]# ls -l /var/lib/ | grep mysql
drwxr-xr-x 5 mysql mysql 4096 juil. 15 19:19 mysql/
[root@localhost laurent]#
drwxr-xr-x 5 mysql mysql 4096 juil. 15 19:19 mysql/
[root@localhost laurent]#
Merci
Fopossum Membre non connecté
-
- Voir le profil du membre Fopossum
- Inscrit le : 15/07/2012
xunil2003 :
Merci
Bonsoir,
Voila les permissions
Voila les permissions
[root@localhost laurent]# ls -l /var/lib/ | grep mysql
drwxr-xr-x 5 mysql mysql 4096 juil. 15 19:19 mysql/
[root@localhost laurent]#
drwxr-xr-x 5 mysql mysql 4096 juil. 15 19:19 mysql/
[root@localhost laurent]#
Merci
Tout d'abord, tout le contenu du répertoire doit appaternir à l'utilisateur:groupe mysql:mysql et on remets les droits qui vont bien :
Donc, on commence par un gros :
Code :
root@machine # chown -R mysql:mysql /var/lib/mysql
root@machine # find /var/lib/mysql/ -type f -exec chmod 660 {} ;
root@machine # find /var/lib/mysql/ -type d -exec chmod 700 {} ;
Le problème de permission se situe sur un autre fichier que le répertoire en lui même. Les logs disent :
les logs :
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
Ensuite, tu peux relancer mysql et ça devrait rouler.
Petit truc les gars, ça, c'est saaaaaaale :
Code BASH :
ls -l /var/lib/ | grep mysql
Ca, c'est bien mieux :
Code BASH :
ls -ld /var/lib/mysql
xunil2003 Membre non connecté
-
- Voir le profil du membre xunil2003
- Inscrit le : 17/02/2011
- Groupes :
Voila ce que j'ai fait
[laurent@localhost ~]$ su
Mot de passe :
[root@localhost laurent]# chown -R mysql:mysql /var/lib/mysql
[root@localhost laurent]# find /var/lib/mysql/ -type f -exec chmod 660 {} ;
[root@localhost laurent]# find /var/lib/mysql/ -type d -exec chmod 700 {} ;
[root@localhost laurent]#
Mot de passe :
[root@localhost laurent]# chown -R mysql:mysql /var/lib/mysql
[root@localhost laurent]# find /var/lib/mysql/ -type f -exec chmod 660 {} ;
[root@localhost laurent]# find /var/lib/mysql/ -type d -exec chmod 700 {} ;
[root@localhost laurent]#
[root@localhost laurent]# ls -ld /var/lib/mysql
drwx------ 5 mysql mysql 4096 juil. 16 14:09 /var/lib/mysql/
[root@localhost laurent]#
drwx------ 5 mysql mysql 4096 juil. 16 14:09 /var/lib/mysql/
[root@localhost laurent]#
[root@localhost laurent]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): [ OK ]
[root@localhost laurent]#
Starting mysqld (via systemctl): [ OK ]
[root@localhost laurent]#
[root@localhost laurent]# mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MariaDB connection id is 2
Server version: 5.5.23-MariaDB Mageia - MariaDB Community Edition (GPL)
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
MariaDB [(none)]> USE mysql;
Database changed
MariaDB [mysql]> UPDATE user SET password=PASSWORD('xxxxxx') WHERE user='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit
Bye
[root@localhost laurent]#
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MariaDB connection id is 2
Server version: 5.5.23-MariaDB Mageia - MariaDB Community Edition (GPL)
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
MariaDB [(none)]> USE mysql;
Database changed
MariaDB [mysql]> UPDATE user SET password=PASSWORD('xxxxxx') WHERE user='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit
Bye
[root@localhost laurent]#
Mais quand je tape dans le navigateur http://192.168.0.2/phpmyadmin/index.php il refuse de ce connecter avec le nouveau identifiant et mot de passe ??
Merci.
Adrien.D Membre non connecté
-
- Voir le profil du membre Adrien.D
- Inscrit le : 30/05/2011
- Site internet
- Groupes :
OK, ton utilisateur mysql nommé admin, est-il autorisé à se connecter ailleurs que depuis localhost ? (Remplacer adrien par ton nom d'utilisateur)
L'hôte '%' est équivalent à dire de n'importe où.
Code SQL :
MariaDB [(NONE)]> USE mysql; DATABASE changed MariaDB [mysql]> SELECT host, USER FROM USER WHERE USER='adrien'; +-----------+--------+ | host | USER | +-----------+--------+ | % | adrien | | localhost | adrien | +-----------+--------+ 2 ROWS IN SET (0.02 sec)
Et désolé, j'ai pas reçu de mail pour la réponse d'hier soir à 19h38
Merci
Édité par Adrien.D Le 16/07/2012 à 15h39
Config : PC Fixe : X470 GAMING PRO- AMD Ryzen 5 2600X - 16Go RAM - Radeon RX 560 (Pilote libre) - Gentoo Linux - GNOME Desktop - Kernel 5.10 LTS
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Fopossum Membre non connecté
-
- Voir le profil du membre Fopossum
- Inscrit le : 15/07/2012
xunil2003 :
Bonjour,
[root@localhost laurent]# /etc/init.d/mysqld start
Starting mysqld (via systemctl): [ OK ]
[root@localhost laurent]#
Starting mysqld (via systemctl): [ OK ]
[root@localhost laurent]#
Magique hein, ça démarre :p
xunil2003 :
(...) Coupure de l'inutile pour la résolution au problème
MariaDB [mysql]> UPDATE user SET password=PASSWORD('xxxxxx') WHERE user='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Mais quand je tape dans le navigateur http://192.168.0.2/phpmyadmin/index.php il refuse de ce connecter avec le nouveau identifiant et mot de passe ??
Merci.
(...) Coupure de l'inutile pour la résolution au problème
MariaDB [mysql]> UPDATE user SET password=PASSWORD('xxxxxx') WHERE user='admin';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Mais quand je tape dans le navigateur http://192.168.0.2/phpmyadmin/index.php il refuse de ce connecter avec le nouveau identifiant et mot de passe ??
Merci.
Simple.
Tu viens de mettre à jour le mot de passe de l'utilisateur admin.
Or, l'admin de MySQL, MariaDB s'appelle root
Donc, on reprend ce que nous avait dit plus haut Adrien.D
Adrien.D :
La première commande te permet de sélectionner la base mysql.
La deuxième te permet de recrééer un nouveau mot de passe à ton utilisateur de base de données.
La troisième commande te permet de rafraichir les privilèges et ainsi que ton mot de passe soit effectif.
Tu peux tester en console alors de te reconnecter via mysql -u tonsuer -ptonmotdepasse.
La première commande te permet de sélectionner la base mysql.
La deuxième te permet de recrééer un nouveau mot de passe à ton utilisateur de base de données.
La troisième commande te permet de rafraichir les privilèges et ainsi que ton mot de passe soit effectif.
Tu peux tester en console alors de te reconnecter via mysql -u tonsuer -ptonmotdepasse.
Si tu changes le mdp de l'utilisateur, disons, toto, il ne pourra voir que les bases qui lui appartiennent via phpmyadmin.
Pour voir toutes les bases, c'est le mdp de l'utilisateur root, mdp que tu as dû normalement fixer au premier démarrage de MySQL / MariaDB.
Je ne saurrais trop te conseiller de lire un peu ce qu'il y a dans La documentation officielle de phpyadmin, cela devrait répondre à une bonne partie des questions que tu te poses.
N'oublie pas de passer le sujet en [Résolu] lorsque tout fonctionnera.
Adrien.D Membre non connecté
-
- Voir le profil du membre Adrien.D
- Inscrit le : 30/05/2011
- Site internet
- Groupes :
il me semble que tu avais créé un autre utilisateur, cf: http://www.mageialinux-online.org/forum/topic-11787+lamp.php#m116875
Si tu ne t'en souvient plus; une fois connecté à MySQL en console, tapes ceci:
Code SQL :
SELECT host, USER FROM mysql.USER;
Avec ceci tu as tous les utilisateurs de MySQL.
A+
Édité par Adrien.D Le 16/07/2012 à 15h52
Config : PC Fixe : X470 GAMING PRO- AMD Ryzen 5 2600X - 16Go RAM - Radeon RX 560 (Pilote libre) - Gentoo Linux - GNOME Desktop - Kernel 5.10 LTS
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Ancien Webmaster de MageiaLinuxOnline. Les remplaçants assurent !
Répondre
Vous n'êtes pas autorisé à écrire dans cette catégorie