Comments (7)
There is a root
user and its password should be located in /var/lib/dokku/services/mariadb/your-service/ROOTPASSWORD
.
But you’ll have to connect to the DB directly with mariadb tools and not through the mariadb:connect
command provided by this plugin.
from dokku-mariadb.
Note: this is related to the enhancement proposed here. If someone wants to sit down and do it, you get commit rights on all the dokku plugins and I'll buy you beers whenever you are in NYC (ask @michaelshobbs, he almost died when he went out with me 🍻 ).
from dokku-mariadb.
@josegonzalez I’m currently working on it https://github.com/dokku/dokku-postgres/commits/lg-multi-db-users :)
from dokku-mariadb.
🍻 🍻 🍻 🍻
from dokku-mariadb.
😀
from dokku-mariadb.
Here is the proposal if anyone wants to take a stab at this:
# by default, simply create a `postgres` user on a database
dokku postgres:create <db>
# we store the user/pass info in a set of files
# located in
#
# /var/lib/dokku/services/postgres/SERVICE/auth/username
#
# where the username is the name of the user,
# and the contents are the password. Note that we
# will need to migrate all the old auth stuff over, including
# any root users.
# create a custom user
# users will have access to all databases etc. Let's not get fancy
# here. If a user wants to lock things down on their own, it's up to
# them
dokku postgres:create-user <db> <user> <pass>
# linking uses the postgres user by default
dokku postgres:link <db> <app>
# you can specify the user to use when linking
dokku postgres:link <db> <app> --user <user>
# we can also create specific databases, and we'd have a list of them here:
#
# /var/lib/dokku/services/postgres/SERVICE/databases/name
#
dokku postgres:create-database <db> <name>
# you can specify the database *and* user to use when linking
dokku postgres:link <db> <app> --user <user> --database <name>
from dokku-mariadb.
Closing in favor of a rather large rfc here: dokku/dokku-redis/issues/64
from dokku-mariadb.
Related Issues (20)
- ADD bash_completion support: autocomplete mariadb service names HOT 2
- Cannot run `mariadb:connect` and `mariadb:export` commands HOT 1
- -
- Designate a data-dir at create or install HOT 1
- Restore from filesys backup HOT 6
- Kills itself when not enough memory? HOT 4
- dokku mariadb:create <service> freezes HOT 2
- Diagnosing database status HOT 2
- How to configure my.cnf HOT 8
- Locking tables HOT 8
- How to override plugin alias HOT 2
- Error while trying to setup backup - Container is restarting HOT 3
- Consider to change default character set to utf8 HOT 6
- Consider having single-instance mode HOT 3
- Database stuck in 'Restarting' HOT 3
- What is the format of schedule exactly? HOT 1
- dokku mariadb:export locks tables HOT 1
- Shared database container? HOT 1
- ERROR: unable to connect HOT 20
- Allow to override user on create HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dokku-mariadb.