Bonjour à tous.
 
Je voudrais lancer mysql installé avec les rpm des CDs Mandrake 9.1.
 
Si je lance /etc/init.d/mysql start , il me signale ceci :
 
Starting MySQL Server [ OK ]
 
Mais si je fais ensuite ps -ef |grep mysql , je n'ai aucun process mysql.
 
Et /etc/init.d/mysql status me retourne mysqld is stopped
 
J'ai également testé ceci :
 
/usr/sbin/mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
030716 11:26:50 Aborting
 
030716 11:26:50 /usr/sbin/mysqld: Shutdown Complete
 
 
Voici ce que je retrouve comme erreur dans
/var/lib/mysql/localhost.localdomain.err
 
030717 06:39:16 mysqld started
030717 6:39:16 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
030717 6:39:16 Aborting
 
030717 6:39:16 /usr/sbin/mysqld: Shutdown Complete
 
030717 06:39:16 mysqld ended
 
 
 
Le fichier /var/lib/mysql/mysql/host.frm existe avec rw pour root.
 
 
Si quelqu'un pouvait m'aider...
 
Merci

> urpme MySQL MySQL-common
> urpmi MySQL MySQL-common
> service mysql start
 
 
je viens d'essayer et aucun pb.
Au pire lance :
> mysql_install_db
puis :
> service mysql start
 

J'ai réalisé ce que tu m'as proposé.
 
#mysql_install_db
Installing all prepared tables
030719  8:10:01  /usr/sbin/mysqld: Shutdown Complete
 
 
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
 
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.
 
NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
 
You can start the MySQL daemon with:
cd / ; /usr/bin/mysqld_safe &
 
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
 
Please report any problems with the /usr/bin/mysqlbug script!
 
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
 
************************************
 
#service mysql start
Starting MySQL Server               [ OK  ]
 
 
********************************************
# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
 
Même problème, mysqld contrairement à ce que indique mysql start [OK], ne fonctionne pas !

tu as installé/désinstallé  les packages mysql ?
peux tu faire :
> rm /var/lib/mysql/mysql.sock
> service mysql start
 
fais voir le fichier de conf de mysql