hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Web Hosting Talk Tutorials : Web Hosting Tutorials : Lost mysql password, how to change in WHM/cpanel?
Reply

Forum Jump

Lost mysql password, how to change in WHM/cpanel?

Reply Post New Thread In Web Hosting Tutorials Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #16  
Old 01-02-2011, 08:44 AM
gendjik gendjik is offline
Newbie
 
Join Date: Sep 2010
Posts: 24
just create another user for that database from mysql tab, then you should adjust the connection properties with that new user on your script/software

Sponsored Links
  #17  
Old 01-02-2011, 10:18 AM
linux7802 linux7802 is offline
Junior Guru Wannabe
 
Join Date: Sep 2007
Location: In ur heart
Posts: 60
Solution

Hi,

If you are having your server root login details then follow following steps carefully from shell.

1st login in to shell as root user now run command( For example I am using site/domain name as test.com and user test.

/scripts/whoowns test.com

It will give you user name, now switch to user account.

cd ~test/public_html
or
cd /home/test/public_htm
l

Now you are in test user home directory under which all hosting files are present.

Run command to search database user and password.

grep test_ * -R -l

Above command will show you all files under which database name/user name is defined.

Now you have to open config file, you have received after running above command.

One config file open search for database user name and password.

login in to cPanel select mysql database feature and add database user with the password which you have found out in config files and reassigned privilege for newly added database user to existing database.

<<snipped>>

Awaiting for your reply.


Last edited by bear; 01-02-2011 at 10:44 AM.
  #18  
Old 02-23-2011, 12:37 PM
qtriangle qtriangle is offline
Web Hosting Master
 
Join Date: Aug 2009
Location: New Delhi
Posts: 610
It is strange that you can not reset the mysql password from cpanel.
Why shouldn't I be able to do that if I have created the user through cpanel?
Looks like a feature suggestion for cpanel.

__________________
Qtriangle - Website development and web hosting solutions
The very best of PHP/MySQL development services


Sponsored Links
  #19  
Old 06-19-2011, 02:42 PM
RadicalBro-Dylan RadicalBro-Dylan is offline
Newbie
 
Join Date: Jun 2011
Posts: 10
Hi,
If you lost your root SQL password there is an option in WHM to change it.

Dylan,

  #20  
Old 06-30-2011, 01:39 AM
somasarkar somasarkar is offline
New Member
 
Join Date: Jun 2011
Location: India
Posts: 1
Can anyone please tell me what happens if I REMOVE those two passwords from that file? What apps on the system actually use or rely on them?

  #21  
Old 06-30-2011, 01:45 AM
MannDude MannDude is offline
Just passing through
 
Join Date: Jan 2002
Location: USA
Posts: 4,449
Is the database being used by any active scripts?

Could you not, I don't know... just look into the configuration (config.php) of said script to obtain current MySQL password?

Example, if you lost your database details for a Wordpress blog, just look up the details in the config.php and save yourself the hassle of having to change that exact same line of information after you've made the update.

__________________
vpsBoard - A fast growing, no BS forum for the VPS industry. Over 2,000 members and industry professionals. Come join the discussion!
Daily Server Deals - A brand new VPS or Dedicated Server deal posted each day at noon! Not owned by a provider or datacenter!

  #22  
Old 07-03-2011, 09:58 PM
Sparrow-Sean Sparrow-Sean is offline
Web Hosting Master
 
Join Date: May 2008
Location: Melbourne, Australia
Posts: 10,437
The database does not physically have a password, it is the user assigned to the database that uses the password, if you are using cPanel simply remove the user from the database and then re-create that user with another password.

You can change the passwords as required within phpMyAdmin or view the config.php as recommended.

__________________
l Spiral Hosting Limited Shared Reseller Cloud VPS Since 2003
l Leading UK and Ireland Hosting Provider Multiple locations - around the globe!
l cPanel/WHM R1Soft Backups 24/7/365 Support 99.9% Uptime Guarantee
l www.spiralhosting.com Chief Technical Officer Superior Service Guarantee

  #23  
Old 08-10-2011, 07:36 AM
bstephe bstephe is offline
New Member
 
Join Date: Aug 2011
Location: USA
Posts: 4
How to login to mySql

Simply log into WHM and scroll down and find SQL Services. In that section you will find a link to reset your root password for MySQL.

Kindly,

If you dont have access to cpanel and you're just trying to reset a passwod for a a local dbuser. Log into cpanel and go to databases. From there you can just change the password for the db user.

  #24  
Old 08-22-2011, 12:40 PM
chetansoni chetansoni is offline
Newbie
 
Join Date: Aug 2011
Posts: 9
Simply log into WHM and scroll down and find SQL Services. In that section you will find a link to reset your root password for MySQL.

  #25  
Old 09-11-2011, 04:20 AM
magucr magucr is offline
Newbie
 
Join Date: Jul 2011
Posts: 15
so if users need to reset their mysql password trough their cpanel they need to know the old password? this is just plain stupid.

  #26  
Old 09-11-2011, 06:03 AM
bear bear is offline
Community Leader
 
Join Date: Oct 2002
Location: Mayberry
Posts: 19,707
Quote:
Originally Posted by magucr View Post
so if users need to reset their mysql password trough their cpanel they need to know the old password? this is just plain stupid.
Cpanel/WHM password is not the same as the mysql root pass.

__________________
Having problems, or maybe questions about WHT? Head over to the help desk!



  #27  
Old 09-11-2011, 07:32 AM
magucr magucr is offline
Newbie
 
Join Date: Jul 2011
Posts: 15
Quote:
Originally Posted by bear View Post
Cpanel/WHM password is not the same as the mysql root pass.
huh? and whos saying that?

  #28  
Old 09-11-2011, 07:43 AM
whfm whfm is online now
WHT Addict
 
Join Date: Jul 2011
Posts: 143
When you click on change password, there is a buttom called sync passwords with mysql, click that and then job done,

OR

You can do what another user has said and make a new user in mysql.

  #29  
Old 09-11-2011, 09:33 AM
magucr magucr is offline
Newbie
 
Join Date: Jul 2011
Posts: 15
I know that, thanks but I am not asking for help, I am just criticizing the fact that you have to know the old password in order to reset it. It does not make any sense.

Also, It is not a good idea to have both cpanel and mysql passwords synchronized, It's actually a documented security issue.

  #30  
Old 09-28-2011, 12:06 PM
unique-links unique-links is offline
Disabled
 
Join Date: Sep 2011
Posts: 53
login to cpanel and from there change the pass word easily, of your db username, you can change all the passwords, if you can solve it, re create the mysql database..

Reply

Related posts from TheWhir.com
Title Type Date Posted
What's New at cPanel: IPv6 and 1:1 NAT Support Web Hosting News 2013-10-01 18:12:07
SSHD Rootkit in the Wild Blog 2013-02-22 16:44:08
cPanel Security Updates Address Perl Module Vulnerabilities Web Hosting News 2012-12-06 12:55:54
cPanel Conference 2012: Branding and How to Do it Better with Felipe Gasper Web Hosting News 2012-10-09 18:00:02
cPanel Conference 2012: What's New with cPanel and WHM with Ken Power Web Hosting News 2012-11-12 13:54:56


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

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

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?