MySQL root password for LMDE

All Gurus once were Newbies
Forum rules
There are no such things as "stupid" questions. However if you think your question is a bit stupid, then this is the right place for you to post it. Please stick to easy to-the-point questions that you feel people can answer fast. For long and complicated questions prefer the other forums within the support section.
Before you post please read how to get help

MySQL root password for LMDE

Postby leneve on 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!
leneve
Level 1
Level 1
 
Posts: 3
Joined: Thu Mar 17, 2011 8:30 am

Linux Mint is funded by ads and donations.
 

Re: MySQL root password for LMDE

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

The instructions suggested Windows XP or better, so I installed Linux :)
User avatar
kwisher
Level 5
Level 5
 
Posts: 643
Joined: Wed Mar 05, 2008 12:54 pm
Location: Greentown, Indiana USA

Re: MySQL root password for LMDE

Postby leneve on 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
leneve
Level 1
Level 1
 
Posts: 3
Joined: Thu Mar 17, 2011 8:30 am

Re: MySQL root password for LMDE

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

At a terminal:
Code: Select all
sudo su -
mysql


what happens?
What's a landing but a take off in reverse?
User avatar
Habitual
Level 8
Level 8
 
Posts: 2254
Joined: Sun Nov 21, 2010 8:31 pm
Location: LM17Q-Xfce

Re: MySQL root password for LMDE

Postby mockturtl on 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
mockturtl
Level 4
Level 4
 
Posts: 442
Joined: Sat Oct 09, 2010 8:51 pm

Re: MySQL root password for LMDE

Postby Habitual on 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
What's a landing but a take off in reverse?
User avatar
Habitual
Level 8
Level 8
 
Posts: 2254
Joined: Sun Nov 21, 2010 8:31 pm
Location: LM17Q-Xfce


Return to Newbie Questions

Who is online

Users browsing this forum: No registered users and 3 guests