Can't connect to mysql from remote

mudidav 2019-09-23 16:09:34 UTC #1

Keywords: Magento - Google Cloud Platform - Technical issue - Connectivity (SSH/FTP)
bnsupport ID: e5c0920a-d6c8-39a0-54c9-752a650e8fc2
Description:
As explained here https://docs.bitnami.com/bch/apps/magento/administration/connect-remotely/

The execution of the command
"sudo mysql -h 127.0.0.1 -P 3306 -u root -p"

Then prompt for password and result is:
ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: YES)

The password is correct, if I access to mysql from ssh with the command:
mysql -u root -p
then prompt for Password and I can access (password is correct)

michiel 2019-09-24 07:55:43 UTC #2

Hi @mudidav,

Did you start an SSH tunnel as explained in the guide? Can you access the application at localhost?

Regards,
Michiel

mudidav 2019-09-24 10:26:15 UTC #3

Yes as in the guide.
This is a new server on GC whit magento 2.3.2.
Older version works.
I connect with Heidisql on PC and worldbench on mac with same error I get in SSH

mudidav 2019-09-24 10:51:51 UTC #4

Here the config

michiel 2019-09-25 09:21:08 UTC #5

Hi @mudidav,

Do you open port 3306 in the firewall?

https://docs.bitnami.com/google/faq/administration/use-firewall/

Please, click on if you think my answer was helpful

mudidav 2019-09-25 16:23:04 UTC #6

It was not necessary in the old server to open port 3306. I noticed, however, that in the old server the mysql DB, in the "user" table, I find a user root with host "%" and user "root" with host "localhost"
Perhaps this is the solution?

michiel 2019-09-26 08:40:59 UTC #7

Hi @mudidav,

Do you mean you already had it open?

In your previous reply you said that it was possible to log in MySQL when you access the server through SSH. So it should be possible.

Regards,
Michiel

mudidav 2019-09-28 16:28:49 UTC #8

Hi Michiel,
I can access through SSH.

Sorry mistyping,
I solved adding to user tbl root@*
now I can connect.

michiel 2019-09-30 10:38:58 UTC #9

I'm glad to hear you've solved the issue. Thanks for sharing it.

system 2020-01-14 18:24:14 UTC #10

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!