mysql_secure_installation - Access denied for user 'root'@'localhost'
-
Bob Builder
MemberJust thought I'd make a note here, when initially installing mysql server I used a (hardcore?) password, for example: 8mO\!<a]3l6.&D/Os-Bd#;eCnQ\lHI
When it came to do 'mysql_secure_installation' it just wouldn't let me in, even when trying a different extreme password.
Just re-did the whole thing with a stupid simple password like 'letmein' and bingo it works!
I'm guessing mysql can't properly save certain characters in the password maybe?? If I find out more I'll post info here (less someone else beats me to it).
Posted 2 years ago # -
Bob Builder
MemberTip1: MySQL doesn't seem to be able to use the hash # character in passwords. There maybe more but it was the hash character that caused the problem for me.
Tip2: If like me you want to uninstall mysql then reinstall to reset password on ubuntu (yes there's probably a better way) use 'aptitude purge' instead of 'aptitude remove'.
You'll also need to uninstall and reinstall twice to get the password config screen to popup, least I did anyway.
Posted 2 years ago # -
hey Bob .. guess the horse already bolted but:-
LOST a MySQL Password? How to RESET it
I think you're right about certain characters with MySQL .. I've had that too, but some other special characters are fine
.. you can always \e\s\c\a\p\e them??
Posted 2 years ago # -
Bob Builder
MemberHorse not needed :o) still keeping server in an experimental state at the mo' (good time to test your new stack script?).
BTW since you're loving new kids on the block (not the boy band), take a look at https://launchpad.net/drizzle , think I've mentioned it before but the exciting thing is that it's near its first stable release.
At the moment it's now ready for public testing (but not production), as it's ment to be a lightweight alternative to MySQL ideal for web apps thought you might wanna play around with it.
Is that a the first drizzle v1.00 tutorial waiting in the wings?? (wink wink)
Posted 2 years ago # -
cheers Bob .. yeah I've looked at Drizzle in the past and it looks great, a new gen relational db sys
.. and seeing as Larry Ellison's Oracle just gobbled up mySQL (er, I think that's correct), depending on what he deigns to do with the world and his database, we may be just need the alternatives quite badly?
Posted 2 years ago #
Reply
You must log in to post.
Want HTML?
a blockquote code em strong ul ol liPlace code between backticks `codeHere`
You've got it.