Re: mysql ne démarre pas
Le Wednesday 18 January 2012 21:29:05 Jean-Yves F. Barbier, vous avez écrit :
> On Wed, 18 Jan 2012 21:17:43 +0100
>
> ajh.valmer@free.fr wrote:
> > Jan 18 21:14:39 mysqld: 120118 21:14:39 [ERROR] Column count of mysql.db
> > is wrong. Expected 22, found 20. Created with MySQL 50051, now running
> > 50149. Please use mysql_upgrade to fix this error.
> Le log parle de lui-même :
# mysql_upgrade
-------------------------
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection
arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using
password: NO) when trying to connect
FATAL ERROR: Upgrade failed
-------------------------
Pourtant, j'ai remis le mot de passe root.
> > and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
> > resulted in Jan 18 21:14:53 /etc/init.d/mysql[3650]: /usr/bin/mysqladmin:
> > unknown variable 'root=debian-sys-maint'
> Là aussi il-y-a un parm qui n'est plus reconnu; ça peut être
> dans /etc/mysql ou dans ~/.my.cnf :
/erc/mysql/debian.cnf :
-------------------------
host = localhost
root = debian-sys-maint
password = XXXXX
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
root = debian-sys-maint
password = XXXXX
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
-------------------------
Quelle serait l'erreur ?
Merci.
ajh
Reply to: