Install and Uninstall mysql server and workbench in Ubuntu(linux)

If you have a problem in mysql server to set new password and anything just backup your current database schema and run following commands in terminal to uninstall and install again in ubuntu.

first you have to uninstall all mysql client, mysql server, mysql server core and mysql workbench.

$ sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-5.7 mysql-client-core-5.7
$ sudo rm -rf /etc/mysql /var/lib/mysql
$ sudo apt-get autoremove
$ sudo apt-get autoclean

Now you have to install , new mysql server in your machine,

$ sudo apt-get install mysql-server

Here you set carefully root password in this step and click ok , by using tab.

Note: In this case, you do not have to run sudo apt-get update prior to the command. This is because we recently ran it in the commands above to install Apache. The package index on our computer should already be up-to-date.

and now instal mysql workbench,

Installing mysql-workbench package on Ubuntu 16.04 (Xenial Xerus) is as easy as running the following command on terminal:

$ sudo apt-get update
$ sudo apt-get install mysql-workbench

Now. go to search application, mysql and you can see mysql workbench and go to database and click for new database.
now you have to fill up your mysql server password , that you already set during installation of mysql server.

Happy coding!!! Happy Ubuntu!!!


Post a Comment