Install MySQL on a virtual machine running OpenSUSE Linux in Azure

MySQL is a popular, open-source SQL database. This tutorial shows you how to create a virtual machine running OpenSUSE Linux, then install MySQL.

If you choose to install and use the CLI locally, you need Azure CLI version 2.0 or later. To find the version, run az --version. If you need to install or upgrade, see Install Azure CLI.

Create a virtual machine running OpenSUSE Linux

First, create a resource group. In this example, the resource group is named mySQSUSEResourceGroup and it is created in the East US region.

az group create --name mySQLSUSEResourceGroup --location eastus

Create the VM. In this example, the VM is named myVM and the VM size is Standard_D2s_v3, but you should choose the VM size you think is most appropriate for your workload.

az vm create --resource-group mySQLSUSEResourceGroup \
   --name myVM \
   --image SUSE:openSUSE-Leap:15-2:latest \
   --size Standard_D2s_v3 \
   --generate-ssh-keys

You also need to add a rule to the network security group to allow traffic over port 3306 for MySQL.

az vm open-port --port 3306 --resource-group mySQLSUSEResourceGroup --name myVM

Connect to the VM

You'll use SSH to connect to the VM. In this example, the public IP address of the VM is 10.111.112.113. You can see the IP address in the output when you created the VM.

ssh 10.111.112.113

Update the VM

After you're connected to the VM, install system updates and patches.

sudo zypper update

Follow the prompts to update your VM.

Install MySQL

Install the MySQL in the VM over SSH. Reply to prompts as appropriate.

sudo zypper install mysql

Set MySQL to start when the system boots.

sudo systemctl enable mysql

Verify that MySQL is enabled.

systemctl is-enabled mysql

This should return: enabled.

Restart the server.

sudo reboot

MySQL password

After installation, the MySQL root password is empty by default. Run the mysql_secure_installation script to secure MySQL. The script prompts you to change the MySQL root password, remove anonymous user accounts, disable remote root sign in, remove test databases, and reload the privileges table.

Once the server reboots, ssh to the VM again.

ssh 10.111.112.113

mysql_secure_installation

Sign in to MySQL

You can now sign in and enter the MySQL prompt.

sudo mysql -u root -p

This switches you to the MySQL prompt where you can issue SQL statements to interact with the database.

Now, create a new MySQL user.

CREATE USER 'mysqluser'@'localhost' IDENTIFIED BY 'password';

The semi-colon (;) at the end of the line is crucial for ending the command.

Create a database

Create a database and grant the mysqluser user permissions.

CREATE DATABASE testdatabase;
GRANT ALL ON testdatabase.* TO 'mysqluser'@'localhost' IDENTIFIED BY 'password';

Database user names and passwords are only used by scripts connecting to the database. Database user account names do not necessarily represent actual user accounts on the system.

Enable sign in from another computer. In this example, the IP address of the computer to allow sign in from is 10.112.113.114.

GRANT ALL ON testdatabase.* TO 'mysqluser'@'10.112.113.114' IDENTIFIED BY 'password';

To exit the MySQL database administration utility, type:

quit

Next steps

For details about MySQL, see the MySQL Documentation.