MySQL root password for LMDE

[leneve]

What is it?

I've installed, uninstalled, purged, reinstalled and it didn't prompt for an initial password.
/usr/bin/mysqladmin -u root password 'newpassword' gets access denied.

Tried logging in without a password, with my usual local mysql passwords, my user/login/sudo password, and 'password'
No luck!

[kwisher]

http://tinyurl.com/387od2q

[leneve]

Really? Really?

http://tinyurl.com/yfeyoak

My question was intended as an easy, new-to-LMDE, and (ironically) googleable solution to this problem:

installed and it didn't prompt for an initial password.

...as all other distros I've used do.
I didn't know if LMDE actually did have a default MySQL root password, or reasons for not prompting for one on install.

And yeah, I reset manually. Here's a direct link to skip the snark:
http://dev.mysql.com/doc/refman/5.0/en/ ... sions-unix

[Habitual]

At a terminal:

Code: Select all

sudo su -
mysql

what happens?

[mockturtl]

MySQL is upstream, and installing mysql-server from mintmenu immediately produces a password prompt:

http://twitpic.com/4af9pu

Your syntax:

Code: Select all

/usr/bin/mysqladmin -u root password 'newpassword'

does not provide a password for the root user, so the 'password newpassword' command does not execute. Use -p, followed by your password (no space!), or leave blank to be prompted.

To verify your credentials, just run the version command:

Code: Select all

$ mysqladmin -u root -p version
Enter password: 
mysqladmin  Ver 8.42 Distrib 5.1.49, for debian-linux-gnu on i486
...

[Habitual]

this may jog your memory

Code: Select all

sudo apt-get install -y debconf-utils
sudo debconf-get-selections | grep mysql | grep password