Before installing any new software, update your system\u2019s package list to ensure you have the latest information on available packages and their versions.\n\n\n\n
\n
sudo apt update<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\nStep 2: Install MySQL Server<\/h3>\n\n\n\n Install MySQL by executing the following command:\n\n\n\n
\n
sudo apt install mysql-server<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\nThis command installs the MySQL server package and any other dependencies required.\n\n\n\n
Step 3: Check MySQL Version<\/h3>\n\n\n\n Verify the installation and check the installed version of MySQL:\n\n\n\n
\n
mysql --version<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\nYou should see output similar to mysql Ver 8.0.36-2ubuntu3 for Linux on x86_64 ((Ubuntu))<\/code>, indicating the version of MySQL installed on your system.\n\n\n\nStep 4: Run the Security Script<\/h3>\n\n\n\n After installation, run the included security script to tighten security defaults:\n\n\n\n
\n
sudo mysql_secure_installation<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n\n\n\n\n
This script will guide you through some security improvements, including setting up a root password if you haven\u2019t already, removing anonymous users, disallowing remote root login, and removing the test database.\n\n\n\n\n\n\n\n
Step 5: Changing Authentication Method (Important for Production)<\/h3>\n\n\n\n By default, MySQL uses the auth_socket<\/code> plugin for authenticating the root user, which might not be suitable for production environments where a traditional password method is preferred. To change this:\n\n\n\n1. Login to MySQL as root:<\/strong>\n\n\n\n\n
sudo mysql<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n2. Change the authentication method:<\/strong>\n\n\n\nReplace 'your_new_password'<\/code> with a secure password:\n\n\n\n\n
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';\nFLUSH PRIVILEGES;<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n3. Exit MySQL:<\/strong>\n\n\n\n\n
exit<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n4. Test the new setup:<\/strong>\n\n\n\nNow, when you use:\n\n\n\n
\n
mysql -u root -p<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\nYou should be prompted to enter the password you have set, verifying that the password-based authentication is active.\n\n\n\n
Step 6: Managing MySQL Service<\/h3>\n\n\n\n To control the MySQL service on your Ubuntu server:\n\n\n\n
\nStart MySQL Service:<\/strong><\/li>\n<\/ul>\n\n\n\n\n
sudo systemctl start mysql.service<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n\nStop MySQL Service:<\/strong><\/li>\n<\/ul>\n\n\n\n\n
sudo systemctl stop mysql.service<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n\nEnable MySQL to Start at Boot:<\/strong><\/li>\n<\/ul>\n\n\n\n\n
sudo systemctl enable mysql.service<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n\nDisable MySQL from Starting at Boot:<\/strong><\/li>\n<\/ul>\n\n\n\n\n
sudo systemctl disable mysql.service<\/code><\/pre>\n \n Copy<\/button>\n <\/amp-iframe>\n <\/div>\n\n\n\n\n\n\n\n
FAQ: Installing MySQL on Ubuntu 24.04 LTS<\/h2>\n\n\n\n \n\n\n\n
\nHow do I install MySQL on Ubuntu 24.04?<\/strong>What’s the process for installing MySQL server on Ubuntu 24.04?<\/strong>Is the installation process different for MySQL 8 on Ubuntu 24.04?<\/strong>How can I check the MySQL version on Ubuntu 24.04?<\/strong>Can I install MySQL Workbench on Ubuntu 24.04?<\/strong>Is MySQL 5.7 available for Ubuntu 24.04?<\/strong>How do I start MySQL in Ubuntu?<\/strong>What’s the command to check if MySQL is running on Ubuntu?<\/strong>How do I secure my MySQL installation on Ubuntu?<\/strong>Can I install MySQL on Ubuntu 24 (shorthand for 24.04)?<\/strong>How do I install MySQL server on Ubuntu 24.04?<\/strong>What’s the process to install WordPress with MySQL on Ubuntu 24.04?<\/strong>Is there an LTS version of MySQL?<\/strong>How do I install MySQL in Spanish? (instalar mysql en ubuntu 24.04)<\/strong>How can I install MySQL on Ubuntu 24 server edition?<\/strong>How do I check the MySQL version on Ubuntu?<\/strong>What’s the correct way to install MySQL on Ubuntu?<\/strong>How do I install MySQL Workbench on Ubuntu 24.04?<\/strong>How do I start MySQL in Ubuntu after installation?<\/strong>How do I install MySQL on Linux Ubuntu?<\/strong>How do I run the MySQL secure installation on Ubuntu?<\/strong>What’s the command to install MySQL server on Ubuntu?<\/strong>How do I install MySQL on Ubuntu in French? (installer mysql ubuntu)<\/strong>Conclusion<\/h2>\n\n\n\n With MySQL installed and secured, you are now ready to start developing applications or managing data with one of the most popular RDBMS platforms. The transition from authentication via auth_socket<\/code> to mysql_native_password<\/code> is particularly crucial for environments that demand traditional password security, providing you with greater flexibility and security control.\n","protected":false},"excerpt":{"rendered":"MySQL is a robust, scalable, and widely used relational database management system (RDBMS), and it is an essential component for many software applications, especially those […]<\/p>\n","protected":false},"author":1,"featured_media":843,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[214],"tags":[69,15,66],"class_list":["post-505","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-installation","tag-mysql","tag-mysql-8","tag-ubuntu-24-04"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/posts\/505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/comments?post=505"}],"version-history":[{"count":4,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/posts\/505\/revisions"}],"predecessor-version":[{"id":896,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/posts\/505\/revisions\/896"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/media\/843"}],"wp:attachment":[{"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/media?parent=505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/categories?post=505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zahiralam.com\/blog\/wp-json\/wp\/v2\/tags?post=505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}