On Wednesday 19 December 2001 12:27 pm, Matthew Darcy wrote: > Hi, > > I am having this exact error message. I have not used mysql before and I > mailed this question before and someone answered but it didn't work. I have > compiled and installed mysql. I run the mysql_install_db script and it > tells me to change my password. I have never set a password as this is the > first time I am running it. I was told to NOT use the -p option which I > did and it prompts me for a password I enter it and I get the not > authorised use @ localhost message. > > what is the exact command line used to set the intial password. > > Thanks, > > Matt. > > On Wednesday 19 December 2001 11:24 am, Henning Sprang wrote: > > Am 18 Dec 2001 16:11:18 -0800 schrieb Jeremiah Jester: > > > Went through these steps and resetup the tables but im still unable to > > > set a new password. > > > > > > The command i used was: > > > > > > /usr/bin/mysqladmin -u root -p password mypassword > > > > > > I then was prompted for a password. But when it failed to authenticate > > > I recieved this error: > > > > > > /usr/bin/mysqladmin: connect to server at 'localhost' failed > > > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > > > > Yes, > > that's correct like this. > > > > I assume now that you want to set your initial password on the databse > > as you didn't already set one. You did not set any password until now > > and you cleaned up all your mysql Data before, dealing with a complete > > clean Mysql INstallation for now. > > > > That means you will have to use mysqadmin _without_ the -p option, > > as this option means "for the user given with -u exists a password and I > > want to be prompted for this _actual_ password". The "password" keyword > > then means that you want to set the _new_ password for the user given > > with -u to the word after the keyword password. > > > > So, for now you have to type: > > > > mysqladmin -u root password YOURNEWPASSWORD > > > > after that when you want to change it againg, you will have to type > > > > mysqladmin -u root -p password MYSECONDNEWPASSWORD > > > > you will then be asked to type your old password one last time, > > then it will be changed to MYSECONDNEWPASSWORD. > > > > > > Sorry, > > some of my answers where a bit confusing in this thread! > > > > And OT: the last mail that came from me through the list shouldn't > > normally be sent out, I am just betatesting Ximian Evolution Mailer, and > > it really fucking sucks, at least the Version that come with Suse 7.3 - > > sending mail you don't want to be sent and not sending mail you consider > > beeing sent since long time is not considered a feature! > > > > henning > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> Trouble > > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php