I set up MySQL and it works during the day but when we leave work and come in the next morning, the database does not work. I have to reboot it in order to get it working again. MySQL is not being used during the evenings and nights. During the day we can login, and it finds the user. But the next morning, if we try to login with the same user, it replies that we did not pass the login procedure. Again, when I reboot the system it works perfectly. Do you know what the issue could be?

    Requires Free Membership to View

Check the error log for clues. If that doesn't reveal anything, set up a script (using cron or Task Scheduler) to attempt to log in every few minutes during the night, to see if there is a consistent time of failure. Look for any other scheduled tasks that might occur around the same time -- DNS refresh, system backups, etc.

This was first published in September 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: