Can't conect to phpmyadim,and mysql's commands doesn't work

stonediao 2019-07-11 02:02:28 UTC #1

Keywords: WordPress + NGINX + SSL - Linux - How to - Other
Description:
I tried to connect to phpmyadmin using the method described in the documentation, but it failed.
https://docs.bitnami.com/general/apps/wordpress-pro/get-started/access-phpmyadmin/
At the same time, I found that mysql --version and other commands are invalid.

Why is it invalid?http://127.0.0.1:8888/phpmyadmin

stonediao 2019-07-11 02:21:48 UTC #2

I used stack is bitnami-wordpresspro-5.1.1-2-linux-x64-installer.run.

jota 2019-07-11 07:34:27 UTC #3

Hi @stonediao,

If you used the Bitnami's installer, you need to load the Bitnami's Environment to run any command in the stack.

https://docs.bitnami.com/installer/how-to/understand-bnconsole/

Once you run those commands, you will be able to execute the mysql command or any other one in the stack.

jota 2019-07-11 08:35:41 UTC #6

Hi @stonediao,

As you can see in your screenshot, there is a use_wordpresspro script inside the installation directory. Please run that one and then use the mysql command.

jota 2019-07-11 08:54:36 UTC #8

Please check my previous comment

stonediao 2019-07-11 09:36:29 UTC #9

Finally succeeded.
It seems that my understanding is wrong in the past, I thought that to execute mysql command, must go to find mysql script, but there is no mysql script under /opt/bitnami. is to execute the real meaning is wordpress script.
Thank you for your help!

stonediao 2019-07-12 02:14:12 UTC #10

Hi @jota,
Yesterday,you helped me solve the problem of executing the mysql command.
But I couldn't access phpmyadmin:
1.I have executed './use_wordpresspro',and it works.
2.I have config ssh-tunnel:

I really can't find the cause of the error.

jota 2019-07-12 08:52:21 UTC #11

Hi @stonediao,

It seems that you created the SSH tunnel properly but the protocol you are using is incorrect, can you use this url in the web browser?

https://127.0.0.1:8443/phpmyadmin

Happy to help!

Was my answer helpful? Click on

stonediao 2019-07-12 09:25:05 UTC #12

I have tried to open https://127.0.0.1:8443/phpmyadmin.But it redirected to my domain.
https://127.0.0.1:8443/phpmyadmin ——>https://abc.com/phpmyadmin
And got 403 error.

gongomgra 2019-07-12 09:57:21 UTC #13

Hi @stonediao,

Did you modify anything in the Apache configuration? It should being redirecting 127.0.0.1 or localhost connections to your domain name. We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please download and execute it on the machine where the stack is running by following the steps described in the guide below?

How to Run the Bitnami Support Tool

Please note that you need to paste the code outputted by the tool in your reply.

Regards,
Gonzalo

stonediao 2019-07-12 23:04:28 UTC #14

@gongomgra I installed WordPress+NGINX+SSL on Aws's lightsail,so there isn't Apache configuration.
I have run the Bitnami Support Tool,and the below code is generated:
8da732fd-f36b-73cc-565a-16181fe8954f

gongomgra 2019-07-15 09:50:52 UTC #15

Hi @stonediao,

You are right, I misunderstood your issue and thought about Apache instead of NGINX. Sorry for the confusion.

The bnsupport tool didn't get all the required files from your system. Can you please follow the instructions in the link below to download the latest bnsupport tool version and run it again using sudo?

https://docs.bitnami.com/installer/how-to/understand-bnsupport/#linux

Apart from that, did you modify anything in your NGINX configuration for WordPress? How did you configure the domain name for WordPress? Can you please run the command below?

sudo cat /opt/bitnami/apps/wordpress/conf/nginx-app.conf

I also see many owner and group values in your installation are different from the default values. Can you tell us what modifications did you do and what were you trying to achieve? Where you using any guide for it?

Regards,
Gonzalo

stonediao 2019-07-17 09:39:37 UTC #17

Hi @gongomgra
Thank you for your reply.I reposted this post.
I have run the lastest Bitnami Support Tool,and the below code is generated:
f7daa112-e87e-4c90-0ea6-8e153b329a13
I didn't change any NGINX configuration,it's default configuration in this instance.

gongomgra 2019-07-17 10:16:15 UTC #18

Hi @stonediao,

I still can't see the WordPress config file into your bnsupport bundle. Are you running the tool with root privileges using sudo? Did you modify any file permissions on your server? Did you modify anything in the phpMyAdmin configuration?

It also looks like the NGINX configuration for WordPress is correct and is stopping the redirection in case you are accessing phpMyAdmin. Can you try accessing phpMyAdmin using the guide below and HTTP instead of HTTPS just in case it solves your issue?

https://docs.bitnami.com/aws/apps/wordpress-pro/get-started/access-phpmyadmin/

I also see the NGINX configuration have the next definition, so can you try to access using localhost in the URL instead of 127.0.0.1? It shouldn't be the issue, but I just want to discard as many options as possible

server_name  localhost;

Regards,
Gonzalo

system 2019-07-31 10:16:30 UTC #19

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!