LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 06-26-2012, 05:04 AM   #1
in088309
LQ Newbie
 
Registered: Feb 2011
Posts: 7

Rep: Reputation: 0
Mysql configuration in linux


Hi..

I installed mysql 5.1 in my cent OS.

After that i am trying the command "mysql -u root" , I got the error message

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

Any help would be appreciable

Thanks in advance
 
Old 06-26-2012, 04:41 PM   #2
Kustom42
Senior Member
 
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,604

Rep: Reputation: 415Reputation: 415Reputation: 415Reputation: 415Reputation: 415
You must add the -p option on the end of your command so that it prompts you for the password. If you don't know the password you can start MySQL with the skip-grant-tables option and reset it:

http://www.cyberciti.biz/tips/recove...-password.html
 
  


Reply



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 configuration klemen *BSD 3 08-19-2005 12:00 AM
MySQL 4.0.13-0 Configuration Help Please Nick2k3 Linux - Software 6 07-02-2003 10:00 PM
MySQL configuration oulevon Linux - General 14 06-26-2001 11:55 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 01:40 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
Open Source Consulting | Domain Registration