Re: #1045 - Access denied (phpmyadmin)
Kevin Hinault a écrit :
J'ai sensiblement la même chose -hormis le password bien sur- sauf
celle ligne "FLUSH PRIVILEGES;"
A quoi sert elle ?
je ne sais pas bien mais hier soir en tentant de changer le mdp en
suivant un tuto il y avait:
mysql -u root
#On modifie le mot de passe ROOT
Mysql > UPDATE mysql.user SET Password = PASSWORD('motdepasse') WHERE
User = 'root';
Mysql > FLUSH PRIVILEGES;
et comme le mdp ne fonctionnait pas (babar1 histoire d'etre simple)
je l'ai efface directement dans la table user root de mysql
sinon lorsque je tape:
debian:/home/jmarc# tail -f /var/log/syslog
Sep 22 08:37:29 localhost /etc/init.d/mysql[5515]:
Sep 22 08:39:01 localhost /USR/SBIN/CRON[5526]: (root) CMD ( [ -d
/var/lib/php4 ] && find /var/lib/php4/ -type f -cmin
+$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm)
Sep 22 08:43:38 localhost mysqld_safe[5612]: started
Sep 22 08:43:38 localhost mysqld[5615]: 080922 8:43:38 [Warning]
Setting lower_case_table_names=2 because file system for
/mnt/pingouin/00sites/10-03-2008-data/data/ is case insensitiveSep 22
08:43:38 localhost mysqld[5615]: 080922 8:43:38 InnoDB: Started; log
sequence number 0 43634
Sep 22 08:43:39 localhost mysqld[5615]: 080922 8:43:39 [Note]
/usr/sbin/mysqld: ready for connections.
Sep 22 08:43:39 localhost mysqld[5615]: Version:
'5.0.32-Debian_7etch6-log' socket: '/var/run/mysqld/mysqld.sock' port:
3306 Debian etch distribution
Sep 22 08:43:54 localhost /etc/init.d/mysql[5789]: 1 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 22 08:43:54 localhost /etc/init.d/mysql[5789]: /usr/bin/mysqladmin:
unknown option '--FLUSH PRIVILEGES;'
Sep 22 08:43:54 localhost /etc/init.d/mysql[5789]:
---> ce "--FLUSH PRIVILEGES;" doit poser un probleme.
amicalement,
jmd
Reply to: