MySQL connection problem

Status
Not open for further replies.

redproly

New Member
Messages
8
Reaction score
0
Points
0
My site cannot access the mysql database and I didn't modify the settings of the connection. Is this the "localhost" thing, so than I have to change the server address to what?
 

Russ

<b>Retired *****</b>
Messages
3,168
Reaction score
2
Points
38
Yes, mysql host must be set as localhost now.
 

amcclain

New Member
Messages
14
Reaction score
0
Points
0
thats the only issue im having is trying to connect to my DBs, no cpanel issues no account panel issues everything looks good. I have changed settings back to localhost and still unable to connect
 

redproly

New Member
Messages
8
Reaction score
0
Points
0
My mysql connection was on localhost before and now, and yesterday showed me the error with the connection. I was having fun with the remote db addresses, but I restored the original state, but the error is still exists. Can u help, what went wrong?

redproletariat.pcriot.com (redproly user)

The interesting thing is that the phpmyadmin works properly. It is working with 'localhost' hosting address, I guess. But my site can't connect to the localhost. Please, view my settings and tell me what I have to do with this! I have many things to do on my site, and I can't.
 
Last edited:

Russ

<b>Retired *****</b>
Messages
3,168
Reaction score
2
Points
38
My mysql connection was on localhost before and now, and yesterday showed me the error with the connection. I was having fun with the remote db addresses, but I restored the original state, but the error is still exists. Can u help, what went wrong?

redproletariat.pcriot.com (redproly user)

The interesting thing is that the phpmyadmin works properly. It is working with 'localhost' hosting address, I guess. But my site can't connect to the localhost. Please, view my settings and tell me what I have to do with this! I have many things to do on my site, and I can't.

What exactly were you doing with the remote mysql?
 

nikolayu

Banned
Messages
8
Reaction score
0
Points
0
I set on 'localhost', but i still getting this message.
"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@arsa.x10hosting.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8b mod_mono/1.2.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at arsa.x10hosting.com Port 80"
 

mathsgeek

New Member
Messages
10
Reaction score
0
Points
0
hi nikolayu

rather than using 'localhost' in your configuration for the MySQL server, try using the IP of your host:
ie 74.86.116.187 if you're on absolute.

hopefully that should sort out your issue.
Nam
I set on 'localhost', but i still getting this message.
&quot;Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@arsa.x10hosting.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.6 (Unix) mod_ssl/2.2.6 OpenSSL/0.9.8b mod_mono/1.2.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at arsa.x10hosting.com Port 80&quot;
 
Last edited:

Smith6612

I ate all of the x10Pizza
Community Support
Messages
6,517
Reaction score
48
Points
48
That's actuallly an Internal Server Error 500. Wonder if that helps you out at all...
 

JoinedSenses

New Member
Messages
1
Reaction score
0
Points
0
I'm having this error as well.

While setting up WordPress blog I am required
to set up a mySQL database, and insert the required
information into a php file.

The blog was working just fine for me recently.

If there are currently php issues, I'm currently unaware
at the moment because it's difficult to maneuver these forums.

Could an administrator assist us?



Thanks.


Server:absolut
URL: http://www.blackstream.elementfx.com
Ad-Free
 
Last edited:

redproly

New Member
Messages
8
Reaction score
0
Points
0
Hey Guys!!

I solved my problem, and it can be helpful you too.
So I found a mysql problem in my mailbox with more detailes, than the CMS tells me. It said that the user have no rights to access the db. So I've deleted the user, and than I've created it again. After all I assign to the db with all rights, and the site is working properly. I don't know exactly, that I solved this problem, or there was some changing on the server side, but after these steps my db is useful again. Try out this!!
 

kirkesp

New Member
Messages
13
Reaction score
0
Points
0
Hey Guys!!

I solved my problem, and it can be helpful you too.
So I found a mysql problem in my mailbox with more detailes, than the CMS tells me. It said that the user have no rights to access the db. So I've deleted the user, and than I've created it again. After all I assign to the db with all rights, and the site is working properly. I don't know exactly, that I solved this problem, or there was some changing on the server side, but after these steps my db is useful again. Try out this!!
You know, I actually thought about doing this myself the other day and didn't know that you could just remove a user and reapply them to the database again. I thought you had to delete them and recreate the user with password and such, so I didn't bother at the time. It's hard to believe that this simple step was all that I needed to do. A moderator should create a post explaining this and sticky it. There's been a lot of threads posted over this issue.
 

thexsource

New Member
Messages
6
Reaction score
0
Points
0
I'll post a quick message, since I think I had the same problem!

I got a database error and I couln't find out where the problem was, but all I had to do was REASSIGN all ALL PRIVILEGES to the user in the database!

Now it works again for me too! Tnx! :)
 

Monster12

New Member
Messages
29
Reaction score
0
Points
0
My site was not coming up for last many days due to mysql prblms...and somehow i was not getting the time to work out wats wrong...

But today i just deleted all the names from remote db addresses and put the ip:74.86.116.187(for absolut) in it ..

still it didnt served the purpose so i edited my configuration file and pasted the same ip :74.86.116.187 in it... in place of localhost... and my main page came up after 15 days ...:thefinger
 
Status
Not open for further replies.
Top