LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 01-21-2009, 11:10 PM   #1
Arty Ziff
Member
 
Registered: May 2008
Location: Tacoma, WA
Distribution: CentOS and RHEL
Posts: 94

Rep: Reputation: 15
Unable to set root password on new mysql install


I've freshly installed CentOS v 5.2.

I've freshly installed MySQL:

yum install mysql mysql-devel mysql-server php-mysql

All seems to have gone well, I see no error messages.

I then did this to make sure MySQL starts when the server powers up (and started mysql):

chkconfig --levels 235 mysqld on
/etc/init.d/mysqld start


Now, I do this to see if networking is enabled:

netstat -tap | grep mysql

It tells me this:

tcp 0 0 *:mysql *:* LISTEN 22430/mysqld

However, when I try to set the root password:

mysqladmin -u root password xxxxxxxx

I get this:

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


Any ideas? File permissions issue?
 
Old 01-22-2009, 02:03 AM   #2
bathory
Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 10,884

Rep: Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322Reputation: 1322
Try the 2nd method of this howto.

Regards
 
Old 01-22-2009, 11:17 PM   #3
Arty Ziff
Member
 
Registered: May 2008
Location: Tacoma, WA
Distribution: CentOS and RHEL
Posts: 94

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by bathory View Post
Try the 2nd method of this howto.

Regards
Thanks! I just found that exact tutorial! Thanks for your help, it works great.
 
  


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
Set mysql root password in script jakev383 Debian 1 08-14-2008 04:11 PM
Unable to reset mysql root password soylentgreen Linux - Server 5 08-02-2008 10:05 PM
didn't set root password during install/config fsuchucky3 Suse/Novell 3 08-17-2006 08:24 PM
Cannot Log into MySQL root password I just set... k41184 Linux - Software 3 07-18-2005 10:57 AM
unable to install LILO nor set root password aquilolumen Slackware - Installation 10 07-07-2005 01:15 PM


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