MyBB Community Forums

Full Version: Lost sql password
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi
I made a backup of my forum and sql data base i.e.   sql.gz

Now I am trying to reinstall it but have forgot the sql data base password
is there a folder I can look in to find the password I used?

The error I get is


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'lottopos_admin'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server
Please contact the MyBB Group for support.


Many thanks for any help!
You need to reset your database user password from cPanel.
Hi
How do I do that?

Only at the moment it's asking for the password I used when I made the backup?
You have to do that in your hosting provider's control panel, not MyBB's Admin panel.
Something like this:
https://www.liquidweb.com/kb/how-to-chan...in-cpanel/
(2018-03-17, 04:20 PM)effone Wrote: [ -> ]You have to do that in your hosting provider's control panel, not MyBB's Admin panel.
Something like this:
https://www.liquidweb.com/kb/how-to-chan...in-cpanel/

Hi
I have tried what you have said but no luck
I've done a reinstall in the past with no problems
The only problem at the moment is I can't remember is the password for the sql data-base sql.gz
Who is your host? What Hosting Control Panel they provide?
(2018-03-17, 06:01 PM)effone Wrote: [ -> ]Who is your host? What Hosting Control Panel they provide?

Hi
Cpanel 11

https://www.galaxywebsolutions.com/
Create a new database user in cPanel or change the password of existing one.
open .inc/config.php file in an editor and change new database username / password in it .
Save the file and reupload (overwrite) to your hosted MyBB directory using FTP.
(2018-03-17, 03:57 PM)len Wrote: [ -> ]Hi
I made a backup of my forum and sql data base i.e.   sql.gz

Now I am trying to reinstall it but have forgot the sql data base password
is there a folder I can look in to find the password I used?

The error I get is


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'lottopos_admin'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server


 Do you have the backup files of MyBB?
Remember in file inc/config.php. setting with pass of DataBase Configuration
(2018-03-17, 06:28 PM)DiegoPino Wrote: [ -> ]
(2018-03-17, 03:57 PM)len Wrote: [ -> ]Hi
I made a backup of my forum and sql data base i.e.   sql.gz

Now I am trying to reinstall it but have forgot the sql data base password
is there a folder I can look in to find the password I used?

The error I get is


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'lottopos_admin'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server


 Do you have the backup files of MyBB?
Remember in file inc/config.php. setting with pass of DataBase Configuration

Hi Guys
Many thanks for all your help it's much appreciated!
I got it all sorted once I changed the password in the  inc/config.php
when I made the backup cpanel would not let me use the old password as it was to weak
once I changed the password in the "  inc/config.php " and used the same password in the data base all work's perfectly!  thanks again for all your help!!!

[/b]