access denied error about dokku-mysql HOT 8 CLOSED

I'm getting this error as well. Issue with Ubuntu 16.04 LTS maybe?

from dokku-mysql.

No, it seems like an issue with the 5.7.12 image. I upgraded from 5.7.10 to 5.7.12 and it seems to fail now :(

from dokku-mysql.

As a workaround, I've temporarily started using the mariadb plugin instead. It seems to work as a drop-in replacement.

from dokku-mysql.

probably related with 47398f8 - I've tried to set up multiple images without success

mysql                     5.6.30              409517a9ab59        8 days ago          324.7 MB
mysql                     5.7.10              a917fce37db8        3 months ago        360.3 MB

root@57e7d8e17908:/var/log# mysql -u root -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select User from user;
+------+
| User |
+------+
| root |
+------+
1 row in set (0.00 sec)

mysql>

as a workaround, I've removed escape

from dokku-mysql.

That would actually make a lot of sense, as I was seeing errors in my logs
related to that line. I'm fairly sure dashed names worked before, but a
name with a space (don't do that!) would likely be a deal breaker.

On Thu, May 12, 2016 at 5:40 AM, Salvatore Ferrucci <
[email protected]> wrote:

probably related with 47398f8
47398f8

• I've tried to set up multiple images without success

mysql 5.6.30 409517a9ab59 8 days ago 324.7 MB
mysql 5.7.10 a917fce37db8 3 months ago 360.3 MB

root@57e7d8e17908:/var/log# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select User from user;
+------+
| User |
+------+
| root |
+------+
1 row in set (0.00 sec)

mysql>

as a workaround, I've removed escape

—
You are receiving this because you commented.
Reply to this email directly or view it on GitHub
#56 (comment)

from dokku-mysql.

Hi guys... I created mysql service from dokku commands and I getting issues trying to connect to mysql. I'm using MYSQL Version 14.14 Distrib 5.7.12

dokku@app:~$ dokku mysql:connect dbapp
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: YES)

Is there any solution for this? or how do I set manually Username and address for that connection?? sorry for my English...

from dokku-mysql.

Jesus, in the short term I just switched to the MariaDB plugin. It works as
a drop-in replacement for MySQL.

https://github.com/dokku/dokku-mariadb

On Thu, May 12, 2016 at 11:11 AM, Jesus D. Rossell <[email protected]

wrote:

Hi guys... I created mysql service from dokku commands and I getting
issues trying to connect to mysql. I'm using MYSQL Version 14.14 Distrib
5.7.12

dokku@app:~$ dokku mysql:connect dbapp
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: YES)

Is there any solution for this? or how do I set manually Username and
address for that connection?? sorry for my English...

—
You are receiving this because you commented.
Reply to this email directly or view it on GitHub
#56 (comment)

from dokku-mysql.

Reverted that commit here: 4e32b0a

from dokku-mysql.