nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

mysql connect failed for root

This is a discussion on mysql connect failed for root within the Databases servers forums, part of the Mastering Servers category; Hi vivek, when I do #mysqladmin -u root -p[list=1] <NEWPASSWD> i get the following error: mysqladmin: connect to server at ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 15-02-2007, 10:17 AM
Junior Member
User
 
Join Date: Feb 2007
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
raghuram
Default mysql connect failed for root

Hi vivek,

when I do #mysqladmin -u root -p[list=1] <NEWPASSWD> i get the following error:

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

I get the above error with password: No also!!

What has happened is this: I run moodle content management server on an FC5 box. Y'day, for some reason I cannot login to moodle anymore, neither as admin or as a student. I assumed mysql tables are corrupted, so, to repair the tables I tried to access mysql. Whenever I do so, I get the above error. Can you help here?

Will post how the squid installation went over the weekend.

Thanks

/raghuram
Reply With Quote
  #2 (permalink)  
Old 15-02-2007, 11:06 AM
kasimani's Avatar
Senior Member
User
 
Join Date: Jul 2006
Location: India, Delhi
OS: CentOS, RedHat, Fedora, Ubuntu
Posts: 151
Thanks: 3
Thanked 1 Time in 1 Post
Rep Power: 4
kasimani is on a distinguished road
Send a message via Yahoo to kasimani
Default may be this will help u

try with blank password insteed of oldpasswd and delete rest.

try this
#mysqladmin -u root

or mysqladmin -u root -p
it will ask for the password, press only enter key here.


i mean to say that accidently ur password set to blank (Nothing)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
Connect mysql in c raj Databases servers 1 10-08-2007 08:10 PM
cdrom: open failed piggy Linux hardware 1 02-08-2007 10:25 PM
Change root password MySQL 5 chiku Databases servers 1 16-01-2007 08:46 PM
Mysql set root password howto Databases servers 1 04-01-2007 11:45 PM
Failed in mysql_real_connect(): Can't connect to local MySQL Linux software 1 17-07-2006 02:05 AM


All times are GMT +5.5. The time now is 01:49 AM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38