MariaDB user management

mprlab327

[unknown] Fantastic, thank you! Relatedly: is there some kind of workaround to grant a new MariaDB user access to an existing database owned by a different MariaDB user? I saw elsewhere that standalone users are not available yet but was hoping there was some other way to grant access in the meantime.

sean

At the present time our panel does not let you assign users to databases after the database has been created, nor will it let you create a MariaDB user on its own without a matching DB. We do plan to add these features in the future.

In the meantime, you can work around it to a limited extent like so:

Create a new MariaDB database for your secondary DB user with the "Add a user to opalN.opalstack.com" option selected as the user for the new DB.
Wait for the panel to report that the new database and user are ready to use.
Create your main MariaDB with your secondary MariaDB user (from step 1) selected as the user for the new DB.
Delete the MariaDB that was created in step 1 (this is optional, but if you don't need the DB feel free to delete it).

In the end you'll have the DB you created in step 3 owned by the DB user that was created automatically in step 1.

I realize this isn't quite what you're looking for (ie multiple users sharing one database) but it does let you do the opposite (a single user owning multiple databases) which some people have asked for.

christer

(When) do you plan to add the possibility to add users to databases to the dashboard? It would be really useful, even if your workaround is possible.

I tried to add privileges to additional users via Adminer, but that was not possible (for some reason I got the error message "Access denied for user 'wpgit'@'localhost' to database 'wpgit", although wpgit is the owner of the database).

sean

christer (When) do you plan to add the possibility to add users to databases to the dashboard? I

As soon as possible, the underlying API is already there. We just need to build out the UI for it.

christer for some reason I got the error message "Access denied for user 'wpgit'@'localhost' to database 'wpgit", although wpgit is the owner of the database

DB ownership isn't sufficient for this. Changing user assignments in MariaDB (and MySQL) requires superuser access (ie the DB root user).

stangz

sean

Any update on this? I am trying to transfer from webfaction and having the ability to create standalone mariadb users would be nice.

etienneh

Based on this documentation:
https://my.opalstack.com/api/v0/redoc/#operation/MariaDB%20user%20create

You can do this:

curl --location --request GET 'https://my.opalstack.com/api/v0/mariadb/list/' \
--header 'Authorization: token <yourtoken>'

get your db id, then call

curl --location --request GET 'https://my.opalstack.com/api/v0/mariadb/read/<databaseid>' \
--header 'Authorization: token <yourtoken>'

from that get the server id, then call

curl --location --request POST 'https://my.opalstack.com/api/v0/mariauser/add/' \
--header 'Authorization: token <yourtoken>' \
--header 'Content-Type: application/json' \
--data-raw '{
    "name": "randocan",
    "server": "<server id>"
}'

Which seems to create the user as sean suggested 🙂
hope this helps someone.

etienneh

etienneh Playing with some more, looks like I can't get this to work fully. The new user doesn't seem to have access to the db server...

sean

stangz we still don't have UI to create a DB user without a DB but we do have UI to assign databases to individual users after they are created.

If you use the maria migrator in the WF migration tool then that can create your individual DB users for you.