Howdy,

I'm trying to run mysql_secure_installation on an Ubuntu 10.04 32 bit instance. mysql_secure_installation is not accepting my root mysql password but I can use the mysql client program without any problem using the same mysql root password.



Did I miss something setting up mysql? Any help would be appreciated.

Thanks!

You will probably want to reset the password if the one you are using is not working:

http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html

Thank you kindly for the reply. I ended up just torching the entire Ubuntu install and doing it all over. I finally got it all working - which is good. But I did not ever learn why this was not working - which is not so good. So I have nothing to share with any souls that find themselves in the same fix.

out of interest.. what was mysql_secure_installation connecting to?
localhost?
127.0.0.1?
or
your public ip?


Chances are whatever password for root you had set was only bound to localhost.. and the other app wasnt connecting via localhost

for reference, LOCALHOST uses unix sockets rather then tcp/ip
so localhost != 127.0.0.1 they are different..
Atleast as far as i can remember they are.

_________________
ServerAdmin - www.our-lan.com
"Diplomacy is the art of saying nice doggy whilst looking for a really big stick"
"In my experiece, any attempt to make any system idiot proof will only challenge God to make a better idiot"

I was using this entry from the Linode library http://library.linode.com/databases/mysql/ubuntu-10.04-lucid that says that MySQL will bind to localhost (127.0.0.1) by default. I made no modifications to the mysql configuration. I have no idea what mysql_secure_installation was trying to connect to.

I had this happen on at least 3 different Ubuntu 10.04 installation attempts. It's working just dandy now. If I re-do my VPS again and I have the same issue, I'll look into the points that you brought up here.

Thanks!

Following that guide there's two opportunities to change the MySQL root password: (1) in the package configuration when the blue background graphic comes up and (2) in the mysql_secure_installation execution

In my case I entered the same password both times. I'm not sure what would happen if you didn't enter a password either time or entered different passwords. I assume the password entered in the second step would replace the earlier one.

I had the same problem, and Googling around, found it can be solved by removing hashes (#) from the password (at least, that did it for me)

Google for mysql reset password, then reset the password to one without any hashes, and then you should be good.

Wow, this answered my question, I was wondering why I was so stumped, guess I need to find a new way to do this.

Thanks

_________________
~A. J. Smith