Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 05-07-2008, 09:48 PM   #1
Registered: Oct 2007
Posts: 32

Rep: Reputation: 15
MYSQL Password Issues

All right, here's where I am at with my first php/Mysql install. I am trying to use php myadmin to work on a database via Apache. I have everything installed (i.e. my info.php file is working and I can start and stop mysqld on the server). Here is what happens when I try to log into mysql:

[]# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[root]# mysqladmin --no-defaults -u root version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I am completely baffled (as I don't even remember typing in a password, but anything is possible) and I could use your expertise.

Old 05-08-2008, 02:01 AM   #2
LQ Guru
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,843

Rep: Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596Reputation: 1596
Use the "-p" option and just press <enter> when asked for a password, if you have not set a password:
mysqladmin --no-defaults -u root -p version
If you have set a password but you've forgotten it, then you need to stop mysqld and then restart it, using:
mysqld_safe --skip-grant-tables -u root
You can then set a new password. I suggest you to read this to see how to secure your installation of mysql.

Old 05-08-2008, 03:10 AM   #3
Registered: Oct 2007
Posts: 32

Original Poster
Rep: Reputation: 15

Thank you! I have conquered the password realm of mysql, now I am onto phpmyadmin!
Old 06-13-2008, 07:00 PM   #4
LQ Newbie
Registered: Aug 2007
Posts: 8

Rep: Reputation: 0
Question Fedora respitories

Where can i find more of fedora respitories?
I got this one
rpm -ivh hxxp://

and i m looking for more
Old 06-13-2008, 07:28 PM   #5
Registered: Nov 2006
Location: Melbourne Australia
Distribution: Centos, RHEL, Debian, Ubuntu, Mint
Posts: 128

Rep: Reputation: 16
You should start a new thread dude.. or search.


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
Recover MySQL password wwnexc Linux - Security 2 10-16-2005 01:08 PM
MYSQL will not take my password number11 Slackware 4 04-23-2005 06:48 AM
mysql password problem varala_kanth Linux - Newbie 1 06-10-2004 03:19 AM
Password issues. n00dles Linux - Newbie 7 07-14-2003 10:59 PM
mysql + password ethanchic Linux - Software 5 02-03-2003 06:06 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 07:20 PM.

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