mysql_secure_installation

Howdy,

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

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

@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.

:roll:

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.

@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 ~~[http://library.linode.com/databases/mysql/ubuntu-10.04-lucid" target="blank">](http://library.linode.com/databases/mys … 0.04-lucid">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 mysqlsecure_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 mysqlsecureinstallation 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.

@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

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct