MySQL SuSe Leap 15 Initial Setup

Leap 15, SuSE, mysql, MariaDB

Mysql is not installed in SuSe by default. Install MariaDB instead
Haven't felt any difference yet.

So the server is installed. Let's check if it is running in the system.
What I like SuSE from the first meeting is Yast.
Yast-System-Service Management
We find mariadb set to start at boot and start the service.
The service has started. The /var/log/mysql/mysql.log file appeared
In it we see that the service has started and is available only from 127.0.0.1
And it would be desirable to work with basis and from other machines.

Open file /etc/my.cf
Commenting out the line

     #bind-address = 127.0.0.1

We restart the service.

 service mariadb restart

Now you can connect to the server from anywhere.

Now we need a service user to work with the database
run mysql as root
run two commands

/ Create htuser user with SecretPassword password to work with glsheduler database /
/ Connect from localhost i.e. locally from the system where the database is running /
GRANT ALL PRIVILEGES ON glsheduler. TO htuser@localhost IDENTIFIED BY 'SecretPassword' WITH GRANT OPTION;
/ Access from any remote host /
GRANT ALL PRIVILEGES ON glsheduler. TO htuser@"%" IDENTIFIED BY 'SecretPassword' WITH GRANT OPTION;

Connecting to MySQL with the user htuser

rust@Leap15:~> mysql -u htuser -p
Enter password:

enter password
And for verification, we create a database with which our user will work
CREATE DATABASE glsheduler;