MariaDB and access to it

[mossiemosforth]

long story short, had a major vm system crash and decided it was time to move from beta5a and xen to latest to start using kvm and docker. i used to have an ubuntu vm that ran all my apps but i want to migrate these to docker containers.

 

i have successfully got sickbeard up and running and even salvaged all my config from the ubuntu vm, pleased on that part. another service it ran was mysql for a central xbmc database and i would like to dockerise this also.

 

i have pulled down needo's mariadb docker but i'm a little stuck from here on. how do i open a session to it from command line? i need to access it to create the require xbmc user inside it.

 

my question is, is this possible or do i need an sql client? just i would prefer not to have to install client tools just to create a user, as thats all you need to do really.

 

sorry if this seems noobish, docker is quite new to me and any help would be greatly appreciated. TIA

[johnodon]

Use HeidiSQL.  There is a portable version so no install needed.

[EdgarWallace]

Here is what I summarized earlier - I hope that this is what you were searching for: http://lime-technology.com/forum/index.php?topic=34754.msg327253#msg327253

[mossiemosforth]

Thanks for the advice guys, heidiSQL did the trick for me. i now have my xbmc database sitting in the mariadb docker.

very happy right now