How to do in Linux

Install MySQL Server To install the MySQL server, you must update your Linux packages system first, type: sudo apt update Then install the MySQL Server package: sudo apt-get install mysql-server MySQL prompt asking you to proceed install, then type: Y Set Password on Root User Please note that the MySQL root user is unsecured you need to provide a secure password for the root user once you deployed on production. To do this, run this command on your terminal: $ sudo mysql Next, we need to check which authentication method of each MySQL user, type command: mysql> SELECT user,authentication_string,plugin,host FROM mysql.user; You can see that the root user doesn’t have authentication_string using the auth_socket plugin. To configure the root account to authenticate with a password, run the following ALTER USER command: mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' ; Please note, make sure...