mysql_secure_installation
I'm trying to run mysqlsecureinstallation on an Ubuntu 10.04 32 bit instance. mysqlsecureinstallation 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!
7 Replies
@TheHeartSmasher:
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">http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.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.
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.
@Internat:
out of interest.. what was mysqlsecureinstallation 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.
I was using this entry from the Linode library
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!
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.
Google for mysql reset password, then reset the password to one without any hashes, and then you should be good.
@abkbrn:
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