MySQL root password for LMDE

Archived topics about LMDE 1
Forum rules
leneve
Level 1
Level 1
Posts: 3
Joined: Thu Mar 17, 2011 8:30 am

MySQL root password for LMDE

Postby leneve » Thu Mar 17, 2011 8:41 am

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' :mrgreen:
No luck!

kwisher
Level 5
Level 5
Posts: 747
Joined: Wed Mar 05, 2008 12:54 pm
Location: Greentown, Indiana USA

Re: MySQL root password for LMDE

Postby kwisher » Thu Mar 17, 2011 8:46 am

The instructions suggested Windows XP or better, so I installed Linux :)

leneve
Level 1
Level 1
Posts: 3
Joined: Thu Mar 17, 2011 8:30 am

Re: MySQL root password for LMDE

Postby leneve » Thu Mar 17, 2011 9:23 am

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

User avatar
Habitual
Level 12
Level 12
Posts: 4203
Joined: Sun Nov 21, 2010 8:31 pm
Location: Youngstown, Ohio

Re: MySQL root password for LMDE

Postby Habitual » Thu Mar 17, 2011 11:26 am

At a terminal:

Code: Select all

sudo su -
mysql


what happens?
Windows assumes you're an idiot.
Linux demands proof of it.

User avatar
mockturtl
Level 4
Level 4
Posts: 452
Joined: Sat Oct 09, 2010 8:51 pm

Re: MySQL root password for LMDE

Postby mockturtl » Thu Mar 17, 2011 4:31 pm

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

User avatar
Habitual
Level 12
Level 12
Posts: 4203
Joined: Sun Nov 21, 2010 8:31 pm
Location: Youngstown, Ohio

Re: MySQL root password for LMDE

Postby Habitual » Thu Mar 17, 2011 6:50 pm

this may jog your memory

Code: Select all

sudo apt-get install -y debconf-utils
sudo debconf-get-selections | grep mysql | grep password
Windows assumes you're an idiot.
Linux demands proof of it.


Return to “Archive”

Who is online

Users browsing this forum: No registered users and 0 guests