LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 08-01-2010, 12:16 PM   #1
DarkSlayer
Member
 
Registered: Apr 2008
Location: Tbilisi , Georgia
Distribution: Fedora, CentOS
Posts: 65

Rep: Reputation: 19
Question can't setup MySQL root password


Following guide for CentOS 5.5 i've installed mysql server on my box.
Next step was setting up password for root user.
As you undestood, it failed.

output:
Code:
# rpm -qa | grep mysql
mysql-devel-5.0.77-4.el5_5.3
php-mysql-5.1.6-27.el5
mysql-5.0.77-4.el5_5.3
mysql-server-5.0.77-4.el5_5.3
Code:
# hostname
cent55.denhome.ge
Code:
# service mysqld status
mysqld (pid 2818) is running...
Code:
# netstat -tap | grep mysql
tcp        0      0 *:mysql                     *:*                         LIST

AND HERE ARE COMMANDS FOR PASSWORD CHANGE


Code:
# mysqladmin -u root password xxxxxx
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

# mysqladmin -h cent55.denhome.ge -u root password xxxxxx
mysqladmin: connect to server at 'cent55.denhome.ge' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Code:
# mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
It's output from second try. During first try i didn't get error on first line command but did on second. In all tries after i got same errors on both lines

everything done under root
/etc/hosts is ok
iptables off

Please any suggestions
 
Old 08-01-2010, 01:04 PM   #2
DarkSlayer
Member
 
Registered: Apr 2008
Location: Tbilisi , Georgia
Distribution: Fedora, CentOS
Posts: 65

Original Poster
Rep: Reputation: 19
Post

I think first try put my password somewhere.
because i can do next:

Code:
# mysql -u root -p
Enter password:     <=== Entering my password from first try and i'm in mysql shell

but i still can't login into phpmyadmin, same error:
Quote:
Error
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
 
  


Reply

Tags
mysql, mysqld, password, root


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
[SOLVED] mysql root password yewint Linux - Newbie 17 06-22-2010 11:18 AM
mysql root password lost nazir Linux - Software 6 10-09-2007 10:18 AM
mysql root password gabsik Linux - Networking 6 06-03-2006 10:58 AM
MySQL root password. bulzbb Linux - Newbie 2 03-11-2004 09:32 AM
Mysql root password spintrance7 Linux - Software 7 11-29-2003 04:20 PM


All times are GMT -5. The time now is 03:39 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration