Kitematic: Unable to authenticate MySQL via kitematic

Created on 12 Mar 2017  路  5Comments  路  Source: docker/kitematic

Expected behavior

There should be a box where I can input parameters to run MySQL

Actual behavior

Container log:
_error: database is uninitialized and password option is not specified
You need to specify one of MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD and MYSQL_RANDOM_ROOT_PASSWORD
_

Information about the Issue

Steps to reproduce the behavior

  1. Installed mysql via kitematic.

I am not sure if this issue is already being worked on based on what I read in the the closed issues.

Most helpful comment

@dhulke Could you share the solution with us please :) ?

EDIT: I found the solution. For those who wonder:

  • open the mysql container settings
  • under the "General" tab click on the + icon and add :
  1. MYSQL_ROOT_PASSWORD as a key and what you want as a value
  2. MYSQL_DATABASE as a key and what you want as a value
  3. MYSQL_USER as a key and what you want as a value
  4. MYSQL_PASSWORD as a key and what you want as a value

Then, save and go back to your Wordpress installation page and fill the fields with the data you set. Instead of localhost, copy/paste the "Access URL" provided in the "Home" tab (next to "Settings") when you're on your mysql container in Kitematic.

All 5 comments

Please read the MySQL requirement documentation:
https://hub.docker.com/_/mysql/

I havent found anything on that documentation that addresses the issue with kitematic. What should I do?

@dhulke @bythckr Did you set any of MYSQL_ROOT_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD or MYSQL_RANDOM_ROOT_PASSWORD environment variables for the container and still getting this error ?

I eventually found out that I had to set that on kitematic and it worked

@dhulke Could you share the solution with us please :) ?

EDIT: I found the solution. For those who wonder:

  • open the mysql container settings
  • under the "General" tab click on the + icon and add :
  1. MYSQL_ROOT_PASSWORD as a key and what you want as a value
  2. MYSQL_DATABASE as a key and what you want as a value
  3. MYSQL_USER as a key and what you want as a value
  4. MYSQL_PASSWORD as a key and what you want as a value

Then, save and go back to your Wordpress installation page and fill the fields with the data you set. Instead of localhost, copy/paste the "Access URL" provided in the "Home" tab (next to "Settings") when you're on your mysql container in Kitematic.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

sumpokemonster picture sumpokemonster  路  3Comments

albfan picture albfan  路  3Comments

EliotSlevin picture EliotSlevin  路  3Comments

tijn72 picture tijn72  路  4Comments

rick02840 picture rick02840  路  3Comments