Change #1018408 had a related patch set uploaded (by Arnaudb; author: Arnaudb):

[operations/puppet@production] mariadb: create new account and database on m5 for striker_toolsbeta

https://gerrit.wikimedia.org/r/1018408

Change #1018408 merged by Arnaudb:

[operations/puppet@production] mariadb: create new account and database on m5 for striker_toolsbeta

https://gerrit.wikimedia.org/r/1018408

Thank you @ABran-WMF! Both of the credentials work fine.

Would it be possible to change the default character set and collation to utf8mb4 and utf8mb4_general_ci respectively? Those are what the main striker database uses and I'm seeing some issues that look like character set issues.

Never mind, the admin user had enough permissions so I could do ALTER DATABASE striker_toolsbeta CHARACTER SET utf8mb4; myself.

Change #1019069 had a related patch set uploaded (by Jcrespo; author: Jcrespo):

[operations/puppet@production] dbbackups: Add striker_toolsbeta to the list of m5 backups

https://gerrit.wikimedia.org/r/1019069

There is some issues on the already provided user grants. I don't think we should create databases with underscores or percentage signs on the name- but if we have to do it, let's use the proper escaping on grants to avoid things like this:

root@dbprov1002:~$ mysql -h db1217.eqiad.wmnet -P 3325 -u dump -p strikerAtoolsbeta
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13675862
Server version: 10.6.14-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql:dump@db1217.eqiad.wmnet [strikerAtoolsbeta]> show tables;
Empty set (0.001 sec)

See my patch for an example. This has caused security issues in the past, that's why I would advocate against allowing those in the first place.

Change #1019069 merged by Jcrespo:

[operations/puppet@production] dbbackups: Add striker_toolsbeta to the list of m5 backups

https://gerrit.wikimedia.org/r/1019069

Oops - sorry about that. If you prefer a version without underscores, from my side it's totally fine to rename the database or just drop it and re-create the tables with a new name. Up to you.

No need. I just wanted to warn the DBAs- althought you may find it interesting, as the last issue was with wikireplicas. No need to change anything at the moment (actual data and name), but the current grants providing access.

Sure, just let me know what the new name is so I can update the app config.

In T360149#9716836, @ABran-WMF wrote:

@taavi would you be OK to drop & recreate that db so we discard the underscore?

The grants need to be updated too

Change #1020709 had a related patch set uploaded (by Arnaudb; author: Arnaudb):

[operations/puppet@production] mariadb: removes underscore on striker database name

https://gerrit.wikimedia.org/r/1020709

@taavi you can replace all occurrences of striker_toolsbeta by strikertoolsbeta (i.e. striker_toolsbeta_admin → strikertoolsbeta_admin). I've also updated credentials in the previous location
@jcrespo database has been properly renamed, good catch!

Change #1021407 had a related patch set uploaded (by Majavah; author: Majavah):

[operations/puppet@production] hieradata: Update striker_toolsbeta database name

https://gerrit.wikimedia.org/r/1021407

Change #1021407 merged by Majavah:

[operations/puppet@production] hieradata: Update striker_toolsbeta database name

https://gerrit.wikimedia.org/r/1021407