Page 1 of 1
MySQL root password for LMDE
Posted: Thu Mar 17, 2011 8:41 am
by 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!
Re: MySQL root password for LMDE
Posted: Thu Mar 17, 2011 8:46 am
by kwisher
Re: MySQL root password for LMDE
Posted: Thu Mar 17, 2011 9:23 am
by leneve
Really?
Really?
http://tinyurl.com/yfeyoak
My question was intended as an easy, new-to-LMDE, and (ironically) googleable solution to this problem:
leneve wrote: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
Re: MySQL root password for LMDE
Posted: Thu Mar 17, 2011 11:26 am
by Habitual
At a terminal:
what happens?
Re: MySQL root password for LMDE
Posted: Thu Mar 17, 2011 4:31 pm
by 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
...
Re: MySQL root password for LMDE
Posted: Thu Mar 17, 2011 6:50 pm
by Habitual
this may jog your memory
Code: Select all
sudo apt-get install -y debconf-utils
sudo debconf-get-selections | grep mysql | grep password