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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
03-20-2009, 06:04 PM
|
#1
|
Member
Registered: Feb 2007
Location: TX, USA
Distribution: fedora
Posts: 191
Rep:
|
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.
|
|
|
03-21-2009, 03:58 AM
|
#2
|
Member
Registered: Mar 2008
Posts: 236
Rep:
|
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.
|
|
|
03-21-2009, 03:56 PM
|
#3
|
LQ Guru
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 27,712
|
Quote:
Originally Posted by palisetty_suman
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.
|
|
|
All times are GMT -5. The time now is 06:16 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|