MySQL Problem after Ubuntu 10.04 Update

Asked By Bubbles Jade 30 points N/A Posted on - 01/14/2012

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.

• Status: Open
• Question Views: 1058
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: OS

Answered By Chalk Talk 5 points N/A #116491

MySQL Problem after Ubuntu 10.04 Update

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

 

About Chalk Talk

Questions
0

Answers
99

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 01/16/2012
• Question Category: OS