Help with MySQL on cpanel

[Lainey]

Hello again,

 

username: lucylain

domain: lostscrolls.heliohost.org

 

I recently resetted my password, then went into the cpanel Change Password option and changed it. Since then I'm unable to access MySQL or any of my databases. I keep getting username or password invalid.

 

Did I do something wrong? Can you help me fix it?

 

Thank you in advance for your attention to this post.

[jje]

Try deleting your current MySQL user, then recreate and reassign a new user with the same credentials to your database through cPanel.

[Lainey]

Try deleting your current MySQL user, then recreate and reassign a new user with the same credentials to your database through cPanel.

 

 

Thanks for the suggestion jje. I would delete the database if I could and start over, but it's not even displaying the databses and users I already have. I could create a new one, but with a different name, same for the user, but the ones I already have would remain there since I can't even delete them.

 

It's also not allowing me to access phpmyadmin or any other tool to manage the info.

[jje]

So cPanel is saying that no databases exist? Strange - not sure why password reset would have deleted them?

 

Hmmm, better let an Admin check it out. Sorry I wasnt much help.

[Lainey]

So cPanel is saying that no databases exist? Strange - not sure why password reset would have deleted them?

 

Hmmm, better let an Admin check it out. Sorry I wasnt much help.

 

Mmm here's the weird stuff:

Cpanel says I have 0 SQL databases.

I go to the MySQL Databases icon and it says "There are no databases associated with your account." and "There are no users associated with your account."

First I thought, ok, the database got deleted. I tried creating the database again, same name, table names and all. It says

 

"Create MySQL database

 

There was a problem creating the database.. Show Details

That database name already exists. "

 

Same thing when I try to recreate the users.

 

So it's like.. the database and users are there, but I simply can't get the information.

 

Thanks for trying and for your suggestion. I'll wait for an administrator to be able to take a look at this

 

Have a nice day.

[Byron]

Since I just changed your domain name, let's give it 24 hours and let the server do a restart. Then go back and check it.

 

 

[Guest Geoff]

So it's like.. the database and users are there, but I simply can't get the information.

 

 

Have you tried using phpMyAdmin?

[jje]

Have you tried using phpMyAdmin?

She stated in her first post that phpMyAdmin was not working either.

[Lainey]

Have you tried using phpMyAdmin?

She stated in her first post that phpMyAdmin was not working either.

 

 

Like jje said, I tried it didn't work.

 

Thanks.

[Guest Geoff]

If you know the password that you used before the password reset, try running the following PHP script:

 

oldpass is the password before you reset it in cpanel

newpass is your new password

 

<?php

$oldpass = ""; // Your old password goes between the quotes
$newpass = ""; // Your new password goes between the quotes

$user = "lucylain";


//DO NOT EDIT BELOW THIS LINE

$newpass = mysql_escape_string($newpass);

mysql_connect('localhost', $user, $oldpass);

mysql_query('set password = password(".$newpass.")');

echo 'password changed';

 

If you have forgotten your old password, djbob will have to log in as the mysql root user and change your password.

 

Post back here if that is the case, and I will escalate this thread.