MySQL Database's disapearing

okthen

Registered
May 21, 2004
2
0
151
Ok I now have been on two differant hosting companies and each of them had a bug in there mysql databases, in the way that one monment they would all be there next they would all be gone, and you couldnt create a new one till the hosting fixed what ever went wrong in the first place.

Is there an Actual bug in the Cpanel code in that it deletes the databases every now and again?
 

mickalo

Well-Known Member
Apr 16, 2002
782
5
318
N.W. Iowa
Originally posted by okthen
Ok I now have been on two differant hosting companies and each of them had a bug in there mysql databases, in the way that one monment they would all be there next they would all be gone, and you couldnt create a new one till the hosting fixed what ever went wrong in the first place.

Is there an Actual bug in the Cpanel code in that it deletes the databases every now and again?
I have been working with MySQL and Cpanels for about 3yrs and never heard of a bug like this.... are you sure someone is not just deleteing the databases ??

In a Cpanel setup, when an account is created, you must assign them atleast one MySQL database in a "package" when the account is sent up. If no MySQL database is allowed when the account is created, they will not be able to create a database at all. Other then that, never heard of databases "disappearing".... :)

Mickalo
 

okthen

Registered
May 21, 2004
2
0
151
well, both of my hosts had the same problem.

www.hostony is one of them and every now and again all my databases would just go. then I d have to go and ask them what was going on they say we had a bug in our databases and its now working.

but now on my new host the exact same thing has happened all the databases have just gone.

is there maybe a weakness that a hacker can use to delete all databases?
 

icanectc

Well-Known Member
Mar 10, 2003
343
0
166
Well thats always a possibility but unlikely. Maybe you should change hosts.... /cough...
 

mickalo

Well-Known Member
Apr 16, 2002
782
5
318
N.W. Iowa
Originally posted by okthen
well, both of my hosts had the same problem.

www.hostony is one of them and every now and again all my databases would just go. then I d have to go and ask them what was going on they say we had a bug in our databases and its now working.

but now on my new host the exact same thing has happened all the databases have just gone.

is there maybe a weakness that a hacker can use to delete all databases?
well the first thing I would do is examine whom has global privileges to ALL the databases and if you have any user that may have remote host privileges "%" indicates any host from any where can connect.

If you have a firewall setup make sure port 3306, the common port used for MySQL, is not open.

Unless you have some 3rd party software running somewhere that is causing the problem??

Do you know what version of MySQL your running, what type of O/S it is, how it was installed ??

Mickalo
 

icanectc

Well-Known Member
Mar 10, 2003
343
0
166
he is running a virutal host account.. he is not the sys admin. Most likely he will not have any of that info.
 

rvskin

Well-Known Member
PartnerNOC
Feb 19, 2003
400
1
168
Did you changed the username of the hosting account? Did this account move from other servers?

There are few case that cause this. If it is the case, you should suggest your provider to edit Mysql table. Because now your new username doesn't have enough priviledge to access the old name. I had this issue a long time ago.