LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-20-2009, 07:04 PM   #1
palisetty_suman
Member
 
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191

Rep: Reputation: 33
Thumbs up i got 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.


I also asked the same question in linux-newbie and nobody is able to answer the question and so since it is related to software, i thought it is appropriate to ask in this section.
 
Old 03-21-2009, 04:58 AM   #2
asymptote
Member
 
Registered: Mar 2008
Posts: 236

Rep: Reputation: 37
I've had a lot of trouble executing commands for mysql-admin from the command line. If you look at the Sun docs they list different ways that you can pass in the username and password, and none of them have ever worked for me except the first time I created a root password and set up the database. I know this doesn't really SOLVE the problem, but I'd like to suggest you install phpmyadmin and execute your queries that way. For some reason when I enter the username and password via phpmyadmin I don't have this issue.
 
Old 03-21-2009, 04:56 PM   #3
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 22,331

Rep: Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026Reputation: 6026
Quote:
Originally Posted by palisetty_suman View Post
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.


I also asked the same question in linux-newbie and nobody is able to answer the question and so since it is related to software, i thought it is appropriate to ask in this section.
Look at the man page for mysql. Your error says that you're not passing it a password, and it's expecting one (indicating you set root up with a password at installation time).

Check the syntax against the man page, but I think that "mysql -u root -p <password>" will work.
 
  


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
error while troubleshooting mysql palisetty_suman Linux - Newbie 8 03-21-2009 11:07 AM
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
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

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

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