Reinstall MySQL in Linux

MySQL always reports an error, saying that the sock file does not exist. There are several methods on the Internet to change the permissions and change the configuration file. The. sock file still cannot be generated normally. No way. Delete and reinstall.

Delete all:

Delete mysql
Sudo apt-get autoremove -- purge mysql-server-5.0
Sudo apt-get remove mysql-server
Sudo apt-get autoremove mysql-server
Sudo apt-get remove mysql-common // This is very important
Some of the above are actually redundant.

Clean residual data

Dpkg-l | grep ^ rc | awk '{print $2}' | sudo xargs dpkg-P but the created database file still exists, and can still be used after re-installation.
Install mysql

Sudo apt-get install mysql-serversudo apt-get install mysql-clientsudo apt-get install php5-mysql // The installation php5-mysql is to connect php and mysql once installation is complete, the MySQL server should be started automatically. Run the following command at the terminal prompt to check whether the MySQL server is running: sudo netstat-tap | grep mysql when you run this command, you can see lines similar to the following:

Tcp 0 0 localhost. localdomain: mysql *: * LISTEN-
If the server cannot run properly, run the following command to start it:

Sudo/etc/init. d/mysql restart
Go to mysql

$ Mysql-uroot-p administrator password

Configure the MySQL administrator password:

Sudo mysqladmin-u root password newpassword

Okay, it's done.