interwebtech Posted February 4, 2017 Share Posted February 4, 2017 orsomething else to use a mysql db admin? MySQL Workbench running on a separate computer / VM +1 Quote Link to comment
laxdragon Posted February 10, 2017 Share Posted February 10, 2017 Updated unRaid to 6.3.1 and now my mySQL docker won't start. The mysql error.log reports the following: 170210 7:28:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist Edit: Never mind, tracked down the issue. After updating to 6.3.1 my Cache drive did not get added back to the array for some reason. Manually adding the cache drive back fixed the issue. Now to figure why my cache drive was moved to unassigned. Quote Link to comment
jeffreywhunter Posted February 22, 2017 Share Posted February 22, 2017 Installing Pydio and getting a "PHP Extension 'MySQL' not loaded" when I click test connection. Recommendations on which PHP app to utilize with Pydio? Quote Link to comment
Kx2000 Posted March 3, 2017 Share Posted March 3, 2017 Hi I need help for understanding. I've installed Mysql docker package today and i don't know how to create a database on it Anyone could guide me ? Thanks. Quote Link to comment
CHBMB Posted March 3, 2017 Share Posted March 3, 2017 46 minutes ago, Kx2000 said: Hi I need help for understanding. I've installed Mysql docker package today and i don't know how to create a database on it Anyone could guide me ? Thanks. The below command will get you into the docker container to execute mysql commands via CLI. docker exec -it mysql bash Quote Link to comment
Kx2000 Posted March 3, 2017 Share Posted March 3, 2017 Thanks for your answer iv ever found this command before but i'm on root@d6be9cd0145e : /# and I don't found any create database command... Quote Link to comment
Kx2000 Posted March 3, 2017 Share Posted March 3, 2017 Ok, i've found "mysql -u root -p" Quote Link to comment
CHBMB Posted March 3, 2017 Share Posted March 3, 2017 53 minutes ago, Kx2000 said: Ok, i've found "mysql -u root -p" Once you have done docker exec -it mysql bash then you're at a linux prompt inside the mysql container and can treat it the same as any other linux terminal with mysql installed. You do need to know how to use mysql though. Quote Link to comment
Kx2000 Posted March 3, 2017 Share Posted March 3, 2017 I've done CREATE DATABASE glpi; (Is for GLPI installation) But on GLPI installation when i use localhost as server name with root login/password i've got an error " Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)" I've verified, /var/run/mysqld does not exist... I don't understand anything... Quote Link to comment
CHBMB Posted March 3, 2017 Share Posted March 3, 2017 localhost won't work in the docker environment as localhost means connections from INSIDE the mysql container, instead use the ip address of your Unraid machine. Quote Link to comment
Kx2000 Posted March 3, 2017 Share Posted March 3, 2017 Of course ! I'm not familiar with docker environment It's working now ! Thanks you !! Quote Link to comment
tyrindor Posted April 11, 2017 Share Posted April 11, 2017 (edited) Why is there never any guides? I can't figure this out, this is the first time needing to use a docker and I am just stumped. I installed community apps, installed this docker. Now what? Do I need a database? I've never setup MySQL either... I go to 192.168.0.101:3306 and nothings there. Edited April 11, 2017 by tyrindor Quote Link to comment
saarg Posted April 11, 2017 Share Posted April 11, 2017 11 minutes ago, tyrindor said: Why is there never any guides? I can't figure this out, this is the first time needing to use a docker and I am just stumped. I installed community apps, installed this docker. Now what? Do I need a database? I've never setup MySQL either... I go to 192.168.0.101:3306 and nothings there. I would believe there are a lot of guides on the Internet. If you have never used mysql before maybe read up on it if you want to use it. Quote Link to comment
tyrindor Posted April 11, 2017 Share Posted April 11, 2017 (edited) 19 minutes ago, saarg said: I would believe there are a lot of guides on the Internet. If you have never used mysql before maybe read up on it if you want to use it. I'm giving up I think, all the guides assume you're more knowledgeable than I am. There is no simple "How to setup a MySQL on UNRAID" step by step guide or video that I can find. The only one I found was back when dockers weren't a thing yet. All I did was install community applications > click this docker > install it with default setings. The docker says its running on 192.168.0.101:3306. I can't ping or access that in anyway. Edited April 11, 2017 by tyrindor Quote Link to comment
interwebtech Posted April 11, 2017 Share Posted April 11, 2017 You're working too hard Get MySQL Workbench (GUI admin tool). https://www.mysql.com/products/workbench/ Quote Link to comment
tyrindor Posted April 11, 2017 Share Posted April 11, 2017 (edited) I don't know what to do with that. https://github.com/YAMJ/yamj-v3/wiki/Getting-Started-with-the-Alpha-Test This is what I am trying to run. I don't think I need any of the developer tools, just a running MySQL server with a database. I gave up trying to get it to work as a unRAID docker, so I installed the windows version of MySQL server in a VM thinking it would be easier. The "creating database" commands given do not work though, throw syntax errors, or other errors. Guide seems outdated. Edited April 11, 2017 by tyrindor Quote Link to comment
CHBMB Posted April 11, 2017 Share Posted April 11, 2017 Guide isn't outdated as MySQL hasn't changed.Our goal has been to bring the ability to run these applications easily on Unraid, not teach everyone how to use each one, hence the lack of guides.My guess is you haven't entered the docker container with the command docker exec -it mysql bash before you have tried to run the guide you found.Sent from my LG-H815 using Tapatalk Quote Link to comment
rdubs Posted June 4, 2017 Share Posted June 4, 2017 Hi, What would be the procedure for resetting the root password on this docker? I installed it a while ago and no longer remember what it was set to. The information I found online suggests to run the mysql server with the parameters, " --skip-grant-tables " in order to allow for a new root password to be established; however, I don't know how to do this inside a docker environment. Thanks! Quote Link to comment
CHBMB Posted June 4, 2017 Share Posted June 4, 2017 docker exec -it mysql bashSent from my LG-H815 using Tapatalk Quote Link to comment
rdubs Posted June 4, 2017 Share Posted June 4, 2017 (edited) --Edit: I was able to add skip-grant-tables to the cnf file in the mysql folder. This allowed me to properly use the bash to reset the password. Thanks! Edited June 5, 2017 by rdubs Quote Link to comment
ebnerjoh Posted June 15, 2017 Share Posted June 15, 2017 (edited) Hi, I have a question to MySQL. I am trying to move from my old server to Unraid. I have a webservice running at a hoster. I am doing a backup of the website on a daily basis to my private webserver at home. Now I want to replace the old webserver with the MySQL and the Apache Docker but now I have issues with special characters (ä, ö, ...) in the Database. The Collation of the productice database is latin_swedish_ci. The Collation of the old backup database is utf8_general_ci. Regardless if I set the collation on the new backup database to latin_swedish_ci or utf8_general all special characters are shown wrongly. What could be the reason for that? Br, Johannes Edited June 15, 2017 by ebnerjoh Quote Link to comment
Zonkeeh Posted March 4, 2018 Share Posted March 4, 2018 just wondering where the template location is stored? I've added https://github.com/linuxserver/docker-templates but the MySQL docker is not on the list of templates, any help would be great thanks! Quote Link to comment
Squid Posted March 4, 2018 Share Posted March 4, 2018 3 minutes ago, Zonkeeh said: just wondering where the template location is stored? I've added https://github.com/linuxserver/docker-templates but the MySQL docker is not on the list of templates, any help would be great thanks! Don't worry about the Docker Repositories section at all. Install Community Applications instead Quote Link to comment
Xochipelli Posted May 1, 2018 Share Posted May 1, 2018 (edited) I've got a docker setup with mysql. It's running and working fine. I've logged into the db as root via ssh with no probs. I'm wondering about whether or not I'll be able to connect to it remotely with a software to write to it. I'm not sure if it's as simple as just connecting to the db? I believe the way it's set up with the docker it's the same as connecting through ssh, is this correct? That a user would have to issue the docker command before being able to connect remotely. I might have have come across some info that suggested the use of keys is possible, with some info added to unRaid's cfg file, if I got that correctly through skimming. Suspect I might not be able to to do that with the limitations of the software I'm attempting to connect with. To start, I'm simply attempting to connect through lan. Any tests I've run have failed. The software gives me the ability to test for successful connection, but only allows for input of: -Server -Port -Database -User -Pass Or am I going to be forced to run a mysql server in a vm instance? Edited May 1, 2018 by Xochipelli Quote Link to comment
icemansid Posted October 4, 2018 Share Posted October 4, 2018 Just an FYI - came here looking for answers, didn't find them here but on the Docker Hub page. Docker has been deprecated. https://hub.docker.com/r/linuxserver/mysql/ Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.