Installing MySQL Server
Here are the quick steps to download and install MySQL Server in Ubuntu through terminal.
step 1 : Installation
OpenUp a terminal and enter the following command.
sudo apt-get install mysql-server
It will install MySQL server and will ask a password during the process.
You can give a refereed password and re-enter it in the next window.
step 2 : Verification
After the above step MySQL should start automatically. To verify that enter the following command.
sudo netstat -tap | grep mysql
it will show the listening port of the Server and so on.
step 3 : Restarting in case
If the Server is not restarting properly restart the server eneringthe following command.
sudo /etc/init.d/mysql restart
Access MySQL Server
You can access the MySQL server through your terminal by entering following command.
mysql -u root -p
After entering your password the terminal switch into mysql> then you can use that interface to create databases and do other database operations.
Uninstall MySQL Server from Ubuntu
At times you may need to reinstall MySQL Server. For that you need complete removing it from the linux system. Enter the following commands one after the other to completely remove the MySQL Server from the system.
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean
These will remove the MySQL Server Completely from the system. If you have issues still after these steps remove the mysql directory in the lib folder by running following command.
sudo rm -rf /var/lib/mysql
After that if you want to re install MySQL Server you can follow the above mentioned steps again.
Ting! :)