0

AlmaLinux 9.6

We have recently been having some big issues with a Plesk update from MariaDB 10.5 to mariaDB 10.11.14 .

This now seems to be resolved (I reinstalled the MariaDB and the data from a dump), and appears to be working ok (touch wood).

I have one remaining issue; I can't see what's causing it.

On the command line the following is run:

# systemctl status mariadb.service  --no-pager --full

From this, it now ALWAYS shows:

enter image description here

With reference to 155396 /usr/sbin/mariadbd --skip-grant-tables --skip-networking. This is always here, and was never here before. I can't see why. Yes, we have used these commands in the /etc/my.cnf file but we have now removed these commands and restarted the server and the service multiple times, but still this remains.

There is no password required for anyone to log in from the command line but logging in as root does request a password but logging in as anyone else, even as a fictional user does not, and gives access to all databases.

How do we turn this off?

I repeat -- this is NOT SET in any of the .cnf files .

Improve this question
2
  • @ErgestBasha sorry where do you want this command run? in the mysql CLI? Commented Oct 30 at 10:16
  • @ErgestBasha output says replicate_events_marked_for_skip | REPLICATE and skip_external_locking | ON and all others are OFF. Commented Oct 30 at 11:34

1 Answer 1

Reset to default
1

Looking at the /usr/lib/systemd/system/mariadb.service file you will see the command that is used to start the service

# Start main service
# MYSQLD_OPTS here is for users to set in /etc/systemd/system/mariadb.service.d/MY_SPECIAL.conf
# Use the [Service] section and Environment="MYSQLD_OPTS=...".
# This isn't a replacement for my.cnf.
# _WSREP_NEW_CLUSTER is for the exclusive use of the script galera_new_cluster
ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION

Check if you have anything in /etc/systemd/system/mariadb.service.d/*.conf, that contains the Environment="MYSQLD_OPTS= line as you may have set those options there

Also check the file /usr/lib/systemd/system/mariadb.service itself as it may be different

Improve this answer
1
  • Thanks for this. There are no /*.conf files . Re uploading the local mariadb.service (sizes are different slighlty) and restarting seems to have resolved the issue. Thank you Commented Oct 30 at 11:08

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.