$ wget https://repo.mysql.com//mysql-apt-config_0.8.14-1_all.deb
$ sudo dpkg -i mysql-apt-config_0.8.14-1_all.deb
Upgrade MySQL from 5.7 to 8 on Ubuntu 18.04
Upasana | December 20, 2019 | 2 min read | 36 views
In this article we will upgrade MySQL on Ubuntu 18.04 LTS from version 5.2.27 to 8.x using command line.
Step 1. Add MySQL APT repository
We will download and add the MySQL APT repository to system’s software repository list.
Download and Add APT repository
The latest version of APT config can be found at https://dev.mysql.com/downloads/repo/apt/
The below screen will appear:
Select the MySQL Server & Cluster option and hit enter:
Now choose MySQL 8 option and press OK
Click Ok to finish the setup.
Step 2. Update APT index and install MySQL server
Now we will update thr APT index and install the latest version of MySQL server using the following commands.
$ sudo apt-get update
$ sudo apt-get install mysql-server
Confirm installation:
$ sudo apt policy mysql-server
Step 3. Manage mysql.service
You can use the following commands to manage mysql instance.
Start the service
$ sudo systemctl start mysql.service
Stop the service
$ sudo systemctl stop mysql.service
Status of service
$ sudo systemctl status mysql.service
Top articles in this category:
- MySql 8 installation on Ubuntu 20
- Upgrade Jenkins on Ubuntu 18.04 LTS
- Install OpenJDK 11 on Ubuntu 18.04 LTS
- Install ElasticSearch 7 on Ubuntu 20.04
- Install Cassandra 4 on Ubuntu 20.04
- Install & configure Redis on Ubuntu
- Install RabbitMQ and Erlang 23 on Ubuntu 20
Recommended books for interview preparation:
Book you may be interested in..
Book you may be interested in..