LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-24-2006, 06:56 AM   #1
heijn@westnet.com.au
LQ Newbie
 
Registered: Jan 2006
Posts: 2

Rep: Reputation: 0
MySql password not working


Hi

I have been in the proccess of setting up a server using Fedora Core 3. I have set up MySql and phpMyAdim and set up the pma database using information from a website, very helpful.

I have used the same password for root MySql etc but now cannot get back into MySql as it says the password is incorrect. Is there a file I can go to to fix this problem? I don't feel like reloading Fedora and starting again.
Regards
Luke
 
Old 01-24-2006, 07:02 AM   #2
bulliver
Senior Member
 
Registered: Nov 2002
Location: Edmonton AB, Canada
Distribution: Gentoo x86_64; Gentoo PPC; FreeBSD; OS X 10.9.4
Posts: 3,760
Blog Entries: 4

Rep: Reputation: 78
Quote:
I have used the same password for root MySql etc
First off, terrible idea. Choose different passwords for everything that needs one. Might seem a bother now, but you will appreciate it when someone roots your box because of a php/MySQL vuln.

Quote:
Is there a file I can go to to fix this problem?
No, but the MySQL documentation will tell you how to change a lost password:
http://dev.mysql.com/doc/refman/5.0/...rmissions.html

Quote:
I don't feel like reloading Fedora and starting again.
Why would you reinstall the OS because of a lost MySQL password? This isn't windows man...
 
Old 01-24-2006, 08:42 AM   #3
Boby
Member
 
Registered: Feb 2004
Location: Sighisoara/Cluj-Napoca (Romania)
Distribution: CentOS 4, Fedora Core 6
Posts: 781

Rep: Reputation: 31
I've posted a tutorial on how to recover the MySQL root password, you can find it here.

You can setup at least anothe user will full admin permissions:
Code:
mysql --user=root -p
An then in the MySQL shell:
Code:
GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
Hope this helps.
Boby

Last edited by Boby; 01-24-2006 at 08:44 AM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL will not take my password number11 Slackware 4 04-23-2005 07:48 AM
MySQL root password. bulzbb Linux - Newbie 2 03-11-2004 10:32 AM
mySQL Not Accepting Password TastyWheat Linux - Software 6 09-01-2003 11:19 PM
MySQL Password Error psycho2000 Linux - Software 7 06-01-2003 08:26 PM
mysql + password ethanchic Linux - Software 5 02-03-2003 07:06 PM


All times are GMT -5. The time now is 04:18 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration