{"id":9040,"date":"2019-09-28T03:34:34","date_gmt":"2019-09-28T10:34:34","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=9040"},"modified":"2024-02-26T04:44:24","modified_gmt":"2024-02-26T11:44:24","slug":"install-mysql-ubuntu","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/getting-started-with-mysql\/install-mysql-ubuntu\/","title":{"rendered":"Install MySQL on Ubuntu"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn step-by-step how to install MySQL 8.0 on Ubuntu 22.0 (codename: jammy).<\/p>\n\n\n\n

Before you begin, ensure you have root or sudo privileges on your Ubuntu system.<\/p>\n\n\n\n

Step 1. Update APT Package List<\/h3>\n\n\n\n

Update the APT package list to ensure that you have the latest information about available packages:<\/p>\n\n\n

sudo apt update<\/code><\/span><\/pre>\n\n\n
Step 2. Install MySQL Server<\/h3>\n\n\n\n
To install MySQL, use the apt<\/code> package manager. You can install MySQL using the apt package manager by running the following command:<\/p>\n\n\n
sudo apt install mysql-server<\/code><\/span><\/pre>\n\n\n
Step 3. Enable MySQL service to auto-start on reboot<\/h3>\n\n\n
sudo<\/span> systemctl<\/span> enable<\/span> mysql<\/span>.service<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 4. Start MySQL Service<\/h3>\n\n\n
sudo<\/span> systemctl<\/span> start<\/span> mysql<\/span>.service<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 5. Check the status of MySQL Service<\/h3>\n\n\n
systemctl<\/span> status<\/span> mysql<\/span>.service<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
Note that you can press q<\/code> to exit the message.<\/p>\n\n\n\n
Step 6. Log in to MySQL and change the root’s password<\/h3>\n\n\n\n
First, log in to the MySQL server using the following command:<\/p>\n\n\n
sudo mysql<\/code><\/span><\/pre>\n\n\n
It’ll take you to the mysql command line:<\/p>\n\n\n
mysql><\/code><\/span><\/pre>\n\n\n
Second, change the password of the root’s account:<\/p>\n\n\n
ALTER<\/span> USER<\/span> root<\/span>@localhost<\/span> \nIDENTIFIED WITH mysql_native_password  \nBY '<YOUR_PASSWORD>'<\/span>;<\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
You should store the password in a secure place for logging in to the MySQL server later.<\/p>\n\n\n\n
Third, exit the MySQL database server:<\/p>\n\n\n
exit<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Fourth, attempt to log in to the MySQL database server with the new password:<\/p>\n\n\n
mysql -u root -p<\/code><\/span><\/pre>\n\n\n
It’ll prompt you to enter a password. Please use the password that you entered in the previous step:<\/p>\n\n\n
Enter password:<\/code><\/span><\/pre>\n\n\n
If you enter the password correctly, you’ll be logged in to the MySQL database server.<\/p>\n\n\n
mysql><\/code><\/span><\/pre>\n\n\n
Before going to the next step, exit the mysql client tool:<\/p>\n\n\n
exit<\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 7. Secure the MySQL installation<\/h3>\n\n\n\n
Execute the following command to adjust the security of the MySQL Server:<\/p>\n\n\n
sudo mysql_secure_installation<\/code><\/span><\/pre>\n\n\n
It’ll prompt you to enter the root’s password. After you enter the password correctly, you will be asked a series of questions. Press ‘Y’ or ‘N’ for the various security questions.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful? <\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t