Install MySQL on Ubuntu

by Ismail.EL
0 comment

Contents

1- What is MySQL:

MySQL, is an open-source relational database management system (RDBMS); it is the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation.

2- Install Mysql:

This guide will introduce how to install, configure and manage MySQL on a Linode running Ubuntu 14.04 LTS:

Update your system:

  1. During the installation process, you will be prompted to set a password for the MySQL root user
  2. Now it will again ask mysql root password for confirmation. Rewrite the same mysql root password.

Once installation is complete, the MySQL server should start automatically. You can use the following command at a terminal prompt to check whether the MySQL server is running:

When you run this command, you should see the following line or something similar:

tcp 0 0 localhost:mysql *:* LISTEN 2556/mysqld

If the server does not function correctly, enter the following command to start it:

3- Using MySQL:

To log in to MySQL as the root user:

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 36
Server version: 5.5.44-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2015, 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>

4. Conclusion

In this post, i have explained the installation of MySQL on Ubuntu.
If you have any questions or feedback, feel free to leave a comment.
As always, if you found this post useful, then click like and share it 🙂

18860cookie-checkInstall MySQL on Ubuntu

Related Posts

Leave a Comment