TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

MySQL

Install MySQL Server on Linux

TestLink Tutorials

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

 

Mysql Server Install Linux

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 |
+——————–+

 

Mysql Server instance Linux

 

Install PHP

https://www.testingdocs.com/install-php-on-ubuntu-linux/

More Information on MySQL:

https://www.mysql.com/

Related Posts

DataGrip Desktop Shortcut

MySQL /

Launch DataGrip on Windows

DataGrip Download

MySQL /

Install DataGrip IDE on Windows 11

MySQL Workbench Windows 11

MySQL /

New MySQL Connection in Workbench

MySQL Command-line Client

MySQL /

Command-Line MySQL Client

Start MySQL Client

MySQL /

Start MySQL Client on Windows 11

‹ Working with MySQL Command Line› Database Users

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version