LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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 03-20-2009, 05:33 PM   #1
palisetty_suman
Member
 
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191

Rep: Reputation: 33
Thumbs up error while troubleshooting mysql


Hi All,
I installed mysql and i got the results exactly as showed in the document for installation of mysql but while troubleshooting, i am gettign an error.It is like

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


Can you please help whats wrong. When i went to /etc/init.d and run
mysql start
i am getting same error . Please help.
 
Old 03-20-2009, 06:22 PM   #2
systemaddict
LQ Newbie
 
Registered: Nov 2008
Location: Edgware, Middlesex, England
Distribution: Debian Lenny
Posts: 11

Rep: Reputation: 1
Did you set a root password during installation?

If so you would start mysql like this:

linux$ mysql -u root -p
Enter password:

If you don't use the -p, the mysql server thinks you want to load mysql without a password, and it won't let you do that if you are root (won't let you do it as anyone else either, unles root has created your user to login without a password).

S
 
Old 03-20-2009, 06:30 PM   #3
palisetty_suman
Member
 
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191

Original Poster
Rep: Reputation: 33
Thumbs up hi

Hi system addict,
I tried to do as you said and now its giving different error
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

PLEASE HELP
 
Old 03-20-2009, 07:44 PM   #4
systemaddict
LQ Newbie
 
Registered: Nov 2008
Location: Edgware, Middlesex, England
Distribution: Debian Lenny
Posts: 11

Rep: Reputation: 1
Did you get the 'Enter password:' prompt?

S
 
Old 03-20-2009, 08:24 PM   #5
palisetty_suman
Member
 
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191

Original Poster
Rep: Reputation: 33
Thumbs up HI

ye i got it and then that message.
 
Old 03-20-2009, 11:12 PM   #6
palisetty_suman
Member
 
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191

Original Poster
Rep: Reputation: 33
Thumbs up HI

Hi help me out please.
 
Old 03-21-2009, 04:57 AM   #7
systemaddict
LQ Newbie
 
Registered: Nov 2008
Location: Edgware, Middlesex, England
Distribution: Debian Lenny
Posts: 11

Rep: Reputation: 1
Did you enter a password at the password prompt?

S
 
Old 03-21-2009, 10:52 AM   #8
systemaddict
LQ Newbie
 
Registered: Nov 2008
Location: Edgware, Middlesex, England
Distribution: Debian Lenny
Posts: 11

Rep: Reputation: 1
You might want to check out how to reset the root password: http://dev.mysql.com/doc/refman/5.0/...rmissions.html (I've never had to try this myself).

S
 
Old 03-21-2009, 11:07 AM   #9
palisetty_suman
Member
 
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191

Original Poster
Rep: Reputation: 33
Thumbs up HI

Ya i entered the password and got that different error. Thanks. I don't know what to do.
 
  


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 error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 04:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Postfix w/ mysql troubleshooting Sapient Linux - Networking 0 01-18-2006 11:35 PM
Troubleshooting apache, php, and mysql. IssacT Slackware 21 08-20-2005 02:58 AM


All times are GMT -5. The time now is 07:01 AM.

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