LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
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 05-07-2008, 10:48 PM   #1
qwerty_tele
Member
 
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.

Thanks!
 
Old 05-08-2008, 03:01 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,520

Rep: Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502Reputation: 1502
Use the "-p" option and just press <enter> when asked for a password, if you have not set a password:
Code:
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:
Code:
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.

Regards
 
Old 05-08-2008, 04:10 AM   #3
qwerty_tele
Member
 
Registered: Oct 2007
Posts: 32

Original Poster
Rep: Reputation: 15
Thanks!

Thank you! I have conquered the password realm of mysql, now I am onto phpmyadmin!
 
Old 06-13-2008, 08:00 PM   #4
kissfreeman
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://rpm.livna.org/livna-release-9.rpm

and i m looking for more
 
Old 06-13-2008, 08:28 PM   #5
grizly
Member
 
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.
 
  


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


All times are GMT -5. The time now is 10:00 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