Topic: mysql connection lost [SOLVED]

[jreijsenbach]

Hi all,

Maybe someone can help with the following:
I have 3 external sites running (2 wordpress and one simple html) all running in their own i-Bay one in primary.
I also have an internal page (wordpress initially now joomla)

The problem is that since I replaced the primary page which was a joomla page with wordpress I get mysql connection problems for either the internal or the Primary (external page)

What I did to repair the lost connection is use commandline and went into mysql and did the grant all command and flush privileges command for the database that could not be accessed. Result: the page works flawlessly again. Just ... the otherpage drops out same error.

I first thought it was connected to wordpress so I replaced one page with joomla ... dropped the old wordpress database made a new one and installed all ... worked .. but now the wordpress page is gone again.

I am thinking it may be mysql problem but am at a loss on how to fix this.

Any suggestions are very welcome!

With kind regards,

Jan

[lancelott2]

Hello,

have you checkt the rights and users for each database and tooked the "granded" user and password in the configfiles of the cmses you use?

Greetings,

Lance

[jreijsenbach]

Hi Lance,

Yes, both have different databases and have not been changed. Once I do the Grant all command for one database the page using the other database cannot connect. If I do the grant all command on the other database the first database cannot be accessed.

I've no ideawhat can cause this... have been running severeal pages mostly joomla on this server for years and never experienced this error.

If you have any further ideas please let me know.

Kind regards,

Jan

[cactus]

Hi Lance,

Yes, both have different databases and have not been changed. Once I do the Grant all command for one database the page using the other database cannot connect. If I do the grant all command on the other database the first database cannot be accessed.

I've no ideawhat can cause this... have been running severeal pages mostly joomla on this server for years and never experienced this error.

If you have any further ideas please let me know.

Kind regards,

Jan

That is strange granting privileges should not revoke this, are you sure your applications are not using the same username but with different passwords?

[jreijsenbach]

ehhmm ...  well not sure.. checking. You are right! Changed it. Now both sites are running fine.

Never realised it'd be so simple. Thanks!

Kind regards,

Jan

[cactus]

ehhmm ...  well not sure.. checking. You are right! Changed it. Now both sites are running fine.

Nice to see you sorted things out.

Never realised it'd be so simple. Thanks!

You're welcome, it was the only thing that came across my mind other than you would have hit a bug, which seemed highly unlikely to me.