When MariaDB is initially installed, it is not configured with an administrator password, nor is it configured to start automatically. To set up the MariaDB database server for use with CIS, perform the following:
In a terminal window, become the root user.
To start the database server, run the following command:
systemctl restart mysql.service
To enable the database server, run the following command:
systemctl enable mysql.service
To verify the database server has started, run the following command:
systemctl status mysql.service
To set the root password and enable root access from remote machines, run the following command:
mysql_secure_installation
It prompts for current password for root user, press 'Enter' to continue.
It prompts to Set root password?, enter 'y' to continue and then enter password.
The password is updated successfully.
It prompts to Remove anonymous users?, press 'Enter' to continue with the default configuration.
It prompts to Disallow root login remotely?, enter 'n' to continue.
It prompts to Remove test database and access to it?, press 'Enter' to continue with the default configuration.
It prompts to Reload privilege tables now?, enter 'y' to continue.
Login to MariaDB.
mysql -u root -p
It prompts for password.
To grant permissions for the superuser account, run the following commands:
> GRANT ALL PRIVILEGES ON *.* TO '<username>'@'%' IDENTIFIED BY '<password>';
> FLUSH PRIVILEGES;
For example:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
To enable the firewall, run the following command:
yast2 firewall
The Firewall Configuration: Start-Up window is displayed.
In the left menu, click Allowed Services and then click Advanced option.
The Additional Allowed Ports window is displayed.
Add 3306 port under the TCP Ports and then click OK.
Click Next and Finish.