MYSQL is one of the most popular database management system - others RDBMS include SQL server, Oracle, Firebird, Postgres etc. just like any relational database management system it is responsible for saving the data that flows in and out of our application in the form records in a table. it is the third mix in the LEMP stack implementation and very important as well. installing mysql server is a straight forward process using the following command: sudo apt install mysql-server this will install the mysql database server on the ubutu instance created earlier. see image below:
we can enter the mysql mode to further execute other mysql command : using the command sudo mysql as shown below:
Because of the sensitive nature of databases it is important to set security credentials for the mysql-server installed using the following command : ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Password_for_the_database-server';
other credentials can then be set on the database server, subsequent login to the database will require password so we start with the following sudo mysql -p where the -p flag allow for password be provided.
finally you can quit the mysql mode by typing exit
MYSQL is one of the most popular database management system - others RDBMS include SQL server, Oracle, Firebird, Postgres etc. just like any relational database management system it is responsible for saving the data that flows in and out of our application in the form records in a table. it is the third mix in the LEMP stack implementation and very important as well. installing mysql server is a straight forward process using the following command: sudo apt install mysql-server this will install the mysql database server on the ubutu instance created earlier. see image below:
we can enter the mysql mode to further execute other mysql command : using the command sudo mysql as shown below:
Because of the sensitive nature of databases it is important to set security credentials for the mysql-server installed using the following command : ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Password_for_the_database-server';
other credentials can then be set on the database server, subsequent login to the database will require password so we start with the following sudo mysql -p where the -p flag allow for password be provided.
finally you can quit the mysql mode by typing exit