On Thu, Jul 10, 2003 at 12:57:36PM +0000, Alain LIEFOOGHE wrote:
> Manuel Bouyer wrote:
> 
> >I guess you need
> >/usr/pkg/bin/mysqladmin -u root -p
> >and once connected, type
> >password 'new-password'
> >
> > 
> >
> Hello manuel, no not exactly, i type all the line :
> "/usr/pkg/bin/mysqladmin -u root -p password 'new-password'".

You're right, what I suggested doesn't work

> i have tryed three times but it's allways the same message.
> is the user who type the command must not be root ?

mysql doesn't care

> i have tryed with a normal user, but it's the same message.
> an other thing very strange, when i start phpmyadmin (i am an normal 
> user with  secondary-group wheel) it say's to me :
> "Erreur MySQL a répondu : Acces denied for user: 'root@localhost' (Using 
> password: NO)"
> i have tryed your solution but it always print all the possible commands.
> is ther an order in the installation of the client and the server ?

No, but did you initialise the base ? Maybe it didn't get properly
initialised.
stop mysqld, remove the content of /var/mysql (but keep the directory itself)
and run
mysql_install_db --force
then restart mysqld
the mysqladmin command should now work.

--
Manuel Bouyer, LIP6, Universite Paris VI.           Manuel.Bouyer@lip6.fr
     NetBSD: 24 ans d'experience feront toujours la difference
--