Install MySQL Server on Linux
Overview
In this tutorial, we’ll be going through the steps to Install MySQL Server server on the Ubuntu Linux machine. MySQL is one of the most popular open-source relational database.
In this series of installing LAMP ( Linux, Apache, MySQL server and PHP) stack components, the next step after installing Apache Webserver is to install MySQL.
Steps to install Apache:
https://www.testingdocs.com/install-apache-http-server-on-ubuntu-linux/
Environment: Ubuntu Linux Server LTS.
Install MySQL Server
To install MySQL on Linux follow the steps.
Open the terminal prompt window
Issue the following commands to install Mysql.
$ sudo apt update
$ sudo apt install mysql-server
Securing the MySQL server deployment.
Run the utility to set the root password and other security parameters for the MySQL server.
$ sudo mysql_secure_installation utility
Start the service
$ sudo service mysql start
Test MySQL server instance
Type the following command to connect to MySQL instance and run a sample test command.
$ sudo mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.20-0ubuntu0.20.04.1 (Ubuntu)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| sys |
+——————–+
Install PHP
https://www.testingdocs.com/install-php-on-ubuntu-linux/
