Having problems connecting to SQL

[pbnightp]

O.k here is how its going down....
it started with a problem on my website saying its unable to access the admin php. So what I did was removed it through the cpanel. when I tried to create a new item I still got the same item. So I decided to check out Softaculous. I am currently using E-107, so I checked out the setting and tried to save my new setting but is says "The MySQL Username or Password or Database host is wrong as a connection could not be established." I checked out the username, the database and finally tried to change the password to the correct one but still no success. One thing remains in the setting and that is the last one says localhost, so is that incorrect???? what should I do to fix it????

 

[Skizzerz]

The MySQL hostname is "localhost." The username and password should be the username and password you created when creating the database (if installing manually). If you installed via Softaculous, I believe it should have created the database for you and you won't need to modify any of the settings.

If you are still having troubles, please give any detailed information you can (such as error numbers, error messages, steps you've tried, etc.). It is very difficult to determine what your issue might be just from your current post.

 

[pbnightp]

o.k let me repeat because apparently you didn't read my post
O.k here is how its going down....
it started with a problem on my website saying its unable to access the admin php. So what I did was removed it through the cpanel. when I tried to create a new item I still got the same item. So I decided to check out Softaculous. I am currently using E-107, so I checked out the setting and tried to save my new setting but is says "The MySQL Username or Password or Database host is wrong as a connection could not be established." I checked out the username, the database and finally tried to change the password to the correct one but still no success. One thing remains in the setting and that is the last one says localhost, so is that incorrect???? what should I do to fix it????

how more detailed to you want me to get???? I basically can't do anything on my site because there is a problem with the sql which is telling me I have no rights to change anything. the only way I can change anything is instead of going on my site and changing it via admin i have to do it through sql login through the cpanel. so there you have it I reworded it but saying the same thing lol get it now?????

 

[Skizzerz]

how more detailed to you want me to get????

Clear, readable English with logical sentence flow would be a good start. Next up would be following my instructions of giving the actual error codes/messages instead of summarizing them. Failing that, try screenshots of the error pages and other appropriate screens.

 

[pbnightp]

"The MySQL Username or Password or Database host is wrong as a connection could not be established." How much clearer must the error message be????? I repeated it like 3 times now, and your still asking me for the error. So are you even reading my post?

 

[Skizzerz]

Please see this knowledgebase article for how to create a MySQL database user and assign it to the database: http://x10hosting.com/support/mysql/create-database (you can skip the instructions on creating a new database, just follow the instructions for creating a user and assigning it to the "pbnightp_startrk" database with all privileges checked).

After you do that, fill in your newly-created database user and password to your e107_config.php file in your public_html folder. Right now it is filled in with your cPanel username and password, which is not a valid username/password combo for accessing the database from your PHP scripts.

 

[pbnightp]

Well I checked out all the info in cpanel and I took a look at the e107_config.php and its all correct. I guess I will no longer have access to my website.

 

[Dead-i]

Hi,

The password in your configuration file is incorrect. Please try resetting your MySQL user's password, and try again.

Thank you,

 

[pbnightp]

I changed it 2 times and its still not working. There is still a problem with the mysql file.

 

[Skizzerz]

As @Dead-i said, the password in your configuration file was incorrect. I changed the password on that user to something random and updated the config file with the new password, so that your site works now.

 

[pbnightp]

thank you, I appreciate it

 

[pbnightp]

Its still not working, when I try to edit my page it still saying the same thing.

 

[Skizzerz]

Can you please try again? It looks like mod_security was blocking your request due to tripping a false positive in a rule for an unrelated application. I disabled that rule for your account, but it is possible that other rules apply as well that need to be disabled.

 

[pbnightp]

Thank you so much.... whatever you did worked and I am now able to edit my webpage. BIG KUDOS!!!!!!