{"id":392,"date":"2025-05-15T08:50:15","date_gmt":"2025-05-15T06:50:15","guid":{"rendered":"https:\/\/www.24x7serverguard.com\/blog\/?p=392"},"modified":"2025-05-15T09:19:31","modified_gmt":"2025-05-15T07:19:31","slug":"how-to-install-mysql-on-ubuntu-latest-version-22-04-24-04","status":"publish","type":"post","link":"https:\/\/www.24x7serverguard.com\/blog\/installation\/how-to-install-mysql-on-ubuntu-latest-version-22-04-24-04\/","title":{"rendered":"How to Install MySQL on Ubuntu (Latest Version \u2013 22.04\/24.04)"},"content":{"rendered":"\n

MySQL is a widely used open-source relational database. In this guide, you\u2019ll learn how to install the latest MySQL version (currently MySQL 8.0<\/strong>) on Ubuntu.<\/p>\n\n\n\n

\n\n\n\n

\u2705 Step 1: Update Your System<\/h3>\n\n\n\n

Start by updating your system packages to ensure everything is up to date:<\/p>\n\n\n\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n\n\n\n
\u2705 Step 2: Add MySQL APT Repository (Optional but Recommended)<\/h3>\n\n\n\n
Ubuntu\u2019s default repo may not have the latest MySQL version. You can add the official MySQL APT repository to ensure you’re installing the latest release:<\/p>\n\n\n\n
wget https:\/\/dev.mysql.com\/get\/mysql-apt-config_0.8.29-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.29-1_all.deb<\/code><\/pre>\n\n\n\n
\n
During the setup, select the MySQL version (default is 8.0), then choose “OK” to proceed.<\/p>\n<\/blockquote>\n\n\n\n
Update package info again after adding the repo:<\/p>\n\n\n\n
sudo apt update<\/code><\/pre>\n\n\n\n
\u2705 Step 3: Install MySQL Server<\/h3>\n\n\n\n
Now install MySQL server:<\/p>\n\n\n\n
sudo apt install mysql-server -y<\/code><\/pre>\n\n\n\n
The installer will automatically configure and start MySQL.<\/p>\n\n\n\n
\n\n\n\n
\u2705 Step 4: Secure MySQL Installation<\/h3>\n\n\n\n
Run the included security script to harden your MySQL server:<\/p>\n\n\n\n
sudo mysql_secure_installation<\/code><\/pre>\n\n\n\n
You’ll be prompted to:<\/p>\n\n\n\n
    \n
  • Set root password<\/li>\n\n\n\n
  • Remove anonymous users<\/li>\n\n\n\n
  • Disallow root login remotely<\/li>\n\n\n\n
  • Remove test database<\/li>\n\n\n\n
  • Reload privilege tables<\/li>\n<\/ul>\n\n\n\n
    Recommended:<\/strong> Answer Y<\/code> to all prompts for maximum security.<\/p>\n\n\n\n
    \n\n\n\n
    \u2705 Step 5: Check MySQL Status<\/h3>\n\n\n\n
    Verify that MySQL is active and running:<\/p>\n\n\n\n
    sudo systemctl status mysql<\/code><\/pre>\n\n\n\n
    You should see: active (running)<\/code>. Press q<\/code> to exit.<\/p>\n\n\n\n
    \n\n\n\n
    \u2705 Step 6: Log In to MySQL<\/h3>\n\n\n\n
    To access MySQL shell:<\/p>\n\n\n\n
    sudo mysql<\/code><\/pre>\n\n\n\n
    This logs in as the root user using socket authentication.<\/p>\n\n\n\n
    \n\n\n\n
    \ud83d\udd04 Optional: Enable Password Authentication for Root<\/h3>\n\n\n\n
    If you want to use mysql -u root -p<\/code> with a password:<\/p>\n\n\n\n
    ALTER USER<\/mark> 'root'@'localhost<\/mark>' IDENTIFIED WITH <\/mark>mysql_native_password BY <\/mark>'YourStrongPassword<\/mark>';
    FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n
    \ud83d\udd27 Useful Commands<\/h3>\n\n\n\n
    Task<\/th>Command<\/th><\/tr><\/thead>
    Restart MySQL<\/td>sudo systemctl restart mysql<\/code><\/td><\/tr>
    Enable on boot<\/td>sudo systemctl enable mysql<\/code><\/td><\/tr>
    MySQL version<\/td>mysql --version<\/code><\/td><\/tr>
    MySQL shell<\/td>sudo mysql<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \n\n\n\n
    \ud83d\ude80 MySQL is Ready!<\/h3>\n\n\n\n
    Your MySQL server is now fully installed and secured on Ubuntu. You can start creating databases and users for your applications.<\/p>\n","protected":false},"excerpt":{"rendered":"
    MySQL is a widely used open-source relational database. In this guide, you\u2019ll learn how to install the latest MySQL version (currently MySQL 8.0) on Ubuntu. \u2705 Step 1: Update Your System Start by updating your system packages to ensure everything is up to date: \u2705 Step 2: Add MySQL APT Repository (Optional but Recommended) Ubuntu\u2019s […]<\/p>\n","protected":false},"author":1,"featured_media":393,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[367,368],"class_list":["post-392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-installation","tag-how-to-install-mysql-on-ubuntu","tag-version-22-04-24-04"],"_links":{"self":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts\/392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/comments?post=392"}],"version-history":[{"count":3,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts\/392\/revisions"}],"predecessor-version":[{"id":397,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts\/392\/revisions\/397"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/media\/393"}],"wp:attachment":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/media?parent=392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/categories?post=392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/tags?post=392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}