MySQL Problem after Ubuntu 10.04 Update

Asked By 30 points N/A Posted on -
qa-featured

Everything except mysql is working well after updating my server to Ubuntu 10.04. The previous version was 8.04. Since updating, I am not able to access myspl from local network. I have tried a number of options. First is setting the server to ‘’listen to all’’ to sensitize to all IP addresses. Secondly, I have used netstat to find the port it senses. All these seem not work for me. Is there anything that needs to be done that I have missed. Please assist.

SHARE
Answered By 0 points N/A #116491

MySQL Problem after Ubuntu 10.04 Update

qa-featured

Try the following workaround to solve that issue:

  • You will first of all need to create a backup of your data directories for MySQL, and that data should include the actual databases that you have created, so that anything you do can be able to be recovered back by just copying these back into their correct locations.
  • Once you  created the backup, you will need to reinstall MySQL, and you will have to make sure it reinstalls completely using the following command:

    'sudo apt-get install mysqlserver –fix-missing –fix-broken –assume-yes'

  • The above will allow you to download and re-install the server. And when it has finished that, you will need to run through the initial mysql configuration whereby you will need to add your users and other details. After you have done that, you will need to stop the server, and then you will have to copy over your data files to the old location and thereafter you will restart MySQL.

-Chalk Talk

 

Login/Register to Answer

Related Questions