#StackBounty: #centos #mariadb Can't change the datadir for MariaDB mysql files

Bounty: 50

This is CentOS 8.1 and MariaDB 10.3 database server.

I have followed the directions I’ve seen in several places to relocate the datadir from the default of /var/lib/mysql to /home/mysql. /home is the RAID.

I’ve made the change in /etc/my.cnf putting this before the !include stuff, but it appears to be still pointing to /var/lib/mysql.

When I have done this, mysql complains and it won’t bring let my run the mysql command.

I have looked in /etc/my.cnf.d and see the default is still there in mariadb-server.cnf.

I see this message in the log and wasn’t sure if this was related or not?

Mar 11 11:58:44 myserver systemd[1]: Starting MariaDB 10.3 database server...

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.**

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.**

I have tried running mysql-prepare-db-dir, but the same messages appear in the logs.


Get this bounty!!!

#StackBounty: #centos #mariadb Can't change the datadir for MariaDB mysql files

Bounty: 50

This is CentOS 8.1 and MariaDB 10.3 database server.

I have followed the directions I’ve seen in several places to relocate the datadir from the default of /var/lib/mysql to /home/mysql. /home is the RAID.

I’ve made the change in /etc/my.cnf putting this before the !include stuff, but it appears to be still pointing to /var/lib/mysql.

When I have done this, mysql complains and it won’t bring let my run the mysql command.

I have looked in /etc/my.cnf.d and see the default is still there in mariadb-server.cnf.

I see this message in the log and wasn’t sure if this was related or not?

Mar 11 11:58:44 myserver systemd[1]: Starting MariaDB 10.3 database server...

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.**

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.**

I have tried running mysql-prepare-db-dir, but the same messages appear in the logs.


Get this bounty!!!

#StackBounty: #centos #mariadb Can't change the datadir for MariaDB mysql files

Bounty: 50

This is CentOS 8.1 and MariaDB 10.3 database server.

I have followed the directions I’ve seen in several places to relocate the datadir from the default of /var/lib/mysql to /home/mysql. /home is the RAID.

I’ve made the change in /etc/my.cnf putting this before the !include stuff, but it appears to be still pointing to /var/lib/mysql.

When I have done this, mysql complains and it won’t bring let my run the mysql command.

I have looked in /etc/my.cnf.d and see the default is still there in mariadb-server.cnf.

I see this message in the log and wasn’t sure if this was related or not?

Mar 11 11:58:44 myserver systemd[1]: Starting MariaDB 10.3 database server...

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.**

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.**

I have tried running mysql-prepare-db-dir, but the same messages appear in the logs.


Get this bounty!!!

#StackBounty: #centos #mariadb Can't change the datadir for MariaDB mysql files

Bounty: 50

This is CentOS 8.1 and MariaDB 10.3 database server.

I have followed the directions I’ve seen in several places to relocate the datadir from the default of /var/lib/mysql to /home/mysql. /home is the RAID.

I’ve made the change in /etc/my.cnf putting this before the !include stuff, but it appears to be still pointing to /var/lib/mysql.

When I have done this, mysql complains and it won’t bring let my run the mysql command.

I have looked in /etc/my.cnf.d and see the default is still there in mariadb-server.cnf.

I see this message in the log and wasn’t sure if this was related or not?

Mar 11 11:58:44 myserver systemd[1]: Starting MariaDB 10.3 database server...

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.**

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.**

I have tried running mysql-prepare-db-dir, but the same messages appear in the logs.


Get this bounty!!!

#StackBounty: #centos #mariadb Can't change the datadir for MariaDB mysql files

Bounty: 50

This is CentOS 8.1 and MariaDB 10.3 database server.

I have followed the directions I’ve seen in several places to relocate the datadir from the default of /var/lib/mysql to /home/mysql. /home is the RAID.

I’ve made the change in /etc/my.cnf putting this before the !include stuff, but it appears to be still pointing to /var/lib/mysql.

When I have done this, mysql complains and it won’t bring let my run the mysql command.

I have looked in /etc/my.cnf.d and see the default is still there in mariadb-server.cnf.

I see this message in the log and wasn’t sure if this was related or not?

Mar 11 11:58:44 myserver systemd[1]: Starting MariaDB 10.3 database server...

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.**

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.**

I have tried running mysql-prepare-db-dir, but the same messages appear in the logs.


Get this bounty!!!

#StackBounty: #centos #mariadb Can't change the datadir for MariaDB mysql files

Bounty: 50

This is CentOS 8.1 and MariaDB 10.3 database server.

I have followed the directions I’ve seen in several places to relocate the datadir from the default of /var/lib/mysql to /home/mysql. /home is the RAID.

I’ve made the change in /etc/my.cnf putting this before the !include stuff, but it appears to be still pointing to /var/lib/mysql.

When I have done this, mysql complains and it won’t bring let my run the mysql command.

I have looked in /etc/my.cnf.d and see the default is still there in mariadb-server.cnf.

I see this message in the log and wasn’t sure if this was related or not?

Mar 11 11:58:44 myserver systemd[1]: Starting MariaDB 10.3 database server...

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.**

Mar 11 11:58:44 myserver mysql-prepare-db-dir[6349]: **If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.**

I have tried running mysql-prepare-db-dir, but the same messages appear in the logs.


Get this bounty!!!

#StackBounty: #mariadb #permissions #mariadb-10.3 Grant MonitorAdmin / PROCESS privilege to user

Bounty: 50

I need to assign the monitoradmin privilege to a user because this is what an application called “dynatrace” needs to monitor the server (some details in a post on their site).

According to https://mariadb.com/kb/en/grant/ there is a PROCESS privilege but I can’t assign it.

MariaDB [(none)]> CREATE USER dynatrace IDENTIFIED BY 'secret';
Query OK, 0 rows affected (0.007 sec)

MariaDB [(none)]> GRANT MonitorAdmin TO dynatrace;
ERROR 1959 (OP000): Invalid role specification `MonitorAdmin`

Same result with PROCESS:

MariaDB [(none)]> GRANT PROCESS TO dynatrace;
ERROR 1959 (OP000): Invalid role specification `PROCESS`

Where is my mistake ? Although my knowledge about mariaDB is more than limited I have the password of the root account 😉 and can run the commands as this user.


Get this bounty!!!

#StackBounty: #mariadb #amazon-rds Why isn't there a character-set-client-handshake RDS parameter for MariaDB 10.2 or 10.3?

Bounty: 100

MariaDB has a parameter, –character-set-client-handshake, that can allow you to specify that the server should ignore the character set being specified by a client connecting.

On RDS, when you create a parameter group for a MariaDB v10.1 instance, this parameter is available for customization. But on v10.2 and v10.3 parameter groups, it is NOT present.

This parameter is also not present on the RDS list of MariaDB parameters not supported by MariaDB.

Searches for this have yielded no info.. can i be the only one that is looking for the character-set-client-handshake parameter for MariaDB v10.2 on RDS?


Get this bounty!!!

#StackBounty: #mariadb #amazon-rds Why isn't there a character-set-client-handshake RDS parameter for MariaDB 10.2 or 10.3?

Bounty: 100

MariaDB has a parameter, –character-set-client-handshake, that can allow you to specify that the server should ignore the character set being specified by a client connecting.

On RDS, when you create a parameter group for a MariaDB v10.1 instance, this parameter is available for customization. But on v10.2 and v10.3 parameter groups, it is NOT present.

This parameter is also not present on the RDS list of MariaDB parameters not supported by MariaDB.

Searches for this have yielded no info.. can i be the only one that is looking for the character-set-client-handshake parameter for MariaDB v10.2 on RDS?


Get this bounty!!!

#StackBounty: #mariadb #amazon-rds Why isn't there a character-set-client-handshake RDS parameter for MariaDB 10.2 or 10.3?

Bounty: 100

MariaDB has a parameter, –character-set-client-handshake, that can allow you to specify that the server should ignore the character set being specified by a client connecting.

On RDS, when you create a parameter group for a MariaDB v10.1 instance, this parameter is available for customization. But on v10.2 and v10.3 parameter groups, it is NOT present.

This parameter is also not present on the RDS list of MariaDB parameters not supported by MariaDB.

Searches for this have yielded no info.. can i be the only one that is looking for the character-set-client-handshake parameter for MariaDB v10.2 on RDS?


Get this bounty!!!