How To Set up MySQL on Ubuntu 22.04/Ubuntu 20.04

To put in it, you need to replace the package deal index in your Ubuntu server by operating the next apt instructions.

$ sudo apt replace
$ sudo apt improve

Subsequent, use the apt-cache command (queries the package deal cache) to seek for MySQL server and consumer packages in your Ubuntu server.

$ apt-cache search mysql-server


mysql-server - MySQL database server (metapackage relying on the newest model)
mysql-server-8.0 - MySQL database server binaries and system database setup
mysql-server-core-8.0 - MySQL database server binaries
default-mysql-server - MySQL database server binaries and system database setup (metapackage)
default-mysql-server-core - MySQL database server binaries (metapackage)
mariadb-server-10.6 - MariaDB database server binaries
mariadb-server-core-10.6 - MariaDB database core server recordsdata

Step 2: Set up MySQL on Ubuntu Server

Then run the next command to put in packages for the MySQL neighborhood server, consumer, and the database widespread recordsdata.

$ sudo apt-get set up mysql-server

The default MySQL configuration file and an error log file shall be situated on the following location, you may view them utilizing the nano editor or tail command as proven.

$ sudo nano /and so forth/my.cnf
$ sudo tail -f /var/log/mysql/error.log

Step 3: Managing MySQL Server by way of Systemd

On Ubuntu, after putting in the MySQL server package deal, its service(s) are normally began mechanically as soon as the package deal is configured. You’ll be able to verify if the MySQL server is up and operating utilizing the next systemctl command.

$ sudo systemctl standing mysql.service

If for one cause or the opposite, it isn’t auto-started, use the instructions under to begin and allow it to begin at system boot time, as follows.

$ sudo systemctl begin mysql.service
$ sudo systemctl standing mysql.service
$ sudo systemctl begin mysql.service
$ sudo systemctl restart mysql.service

Step 4: Set MySQL Root Password

First, open up the MySQL immediate:

$ sudo mysql

Subsequent, run the next ALTER USER command to set the MySQL root password utilizing the mysql_native_password authentication methodology as proven.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR-STRONG-PASSWORD';

After setting the password, exit the MySQL immediate:

mysql> exit

Step 5: Safe MySQL Server Set up

By default, the MySQL set up is unsecure. To safe it, run the safety script which comes with the binary package deal.

$ sudo mysql_secure_installation

You may be requested to enter the root password you simply set above.

Then enter sure/y to the next safety questions:

• Take away nameless customers? (Press y|Y for Sure, another key for No) : y
• Disallow root login remotely? (Press y|Y for Sure, another key for No) : y
• Take away the take a look at database and entry to it? (Press y|Y for Sure, another key for No) : y
• Reload privilege tables now? (Press y|Y for Sure, another key for No) : y

To additional safe your MySQL server, learn our article 12 MySQL Safety Finest Practices for Linux.

Step 6: Create MySQL Database with Consumer

The MySQL set up comes with a root account, which you should utilize to handle the entire database, however for safety causes, I recommend you create a standard consumer account with restricted privileges to databases as proven.

$ mysql -u root -p
mysql> CREATE DATABASE tecmintdb;
mysql> CREATE USER 'aaron'@'localhost' IDENTIFIED BY 'rig!43B#web1rdl0gn1';
mysql> GRANT ALL PRIVILEGES ON tecmintdb.* TO 'aaron'@'localhost';

Now to log in as your new MySQL consumer, use the next command.

$ mysql -u aaron -p

Step 7: Set up Additional MySQL Merchandise and Elements

As well as, you may set up additional MySQL parts that you simply really feel you want with the intention to work with the server, akin to mysql-workbench-community, libmysqlclient18, and lots of others.

$ sudo apt-get replace
$ sudo apt-get set up mysql-workbench-community libmysqlclient18

Lastly, to entry the MySQL shell, subject the next command.

$ sudo mysql -u root -p

That’s It! On this article, we’ve got defined tips on how to set up MySQL in Ubuntu 22.04 and Ubuntu 20.04. If in case you have any questions or ideas to share, use the remark kind under to achieve us.