Skip to content

MySQL Workbench and Server on Ubuntu

Shamik-07 edited this page May 22, 2022 · 1 revision

Installation of MySQL server

https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

Installation of MySQL Workbench

https://dev.mysql.com/doc/workbench/en/wb-installing-linux.html#:~:text=Enterprise%20Backup%20binary.-,Installing%20DEB%20Packages,-On%20Ubuntu%2C%20and

Starting MySQL Server

systemctl start mysql

Stopping MySQL Server

systemctl stop mysql

Monitoring MySQL Server status

systemctl status mysql

Troubleshoot connection error to server

If you are facing an error similar to ERROR 1698 (28000): Access denied for user ‘root’@’localhost’ Follow the steps in this blog https://phoenixnap.com/kb/access-denied-for-user-root-localhost

Once MySQL server is running and you are connected to it via the Workbench, you will be able to view the below. image