Lightsail wordpress , cannot connect mysql

Keywords: MySQL - AWS - Technical issue - Services (Apache, MariaDB, MySQL…)

bnsupport ID: fc88875f-b9c9-bfc1-f5bc-68f22cb85120

bndiagnostic output:

The diagnostic tool couldn't find any issues.

bndiagnostic failure reason: The tool could not find any issue

Description:
Hi,
I need to link to my WordPress mysql, I follow this tutorial:

https://docs.bitnami.com/general/infrastructure/mysql/configuration/configure-workbench/

https://docs.bitnami.com/general/infrastructure/mysql/administration/connect-remotely-mysql/

But when it comes to the “input password” step, I cannot enter any letters or numbers.

In addition, when I purchase a shared host on bluehost, when I connect to the mysql of that website, I need to add the local IP to the whitelist.
Do I need to do something similar for lightsail?

Now I still can’t link my mysql, I need your help, thank you

Huang

Hi @hwp994108018,

Thanks for using Bitnami. I’m afraid I don’t fully understand your issue. Where are you having errors typing the password? Can you share a screenshot with us?

The MariaDB server seems to be running properly on your server, did you configure workbench with your server IP address?

Hello,

I have solved that problem, and now, a new problem.

I want to import data from my computer to the bitnami database, but only 20,000 data have been imported in 12 hours.
This is too slow, how can I import 100,000 data in 10 minutes?

What I have done:

Add the following code to the [mysqld] section of my.cnf:

innodb_flush_log_at_trx_commit=0

sync_binlog=2000

Then, restart:

sudo /opt/bitnami/ctlscript.sh restart mariadb

thank you for your time,

Huang

Hello,

I can only import one post to the database every 2 seconds, the following is a screenshot:

https://photos.app.goo.gl/mUXKC2YczAvURHsk6

Even using the wp all import plugin, I imported 90,000 posts in 6 hours,

So how can I optimize the database to increase the import speed?

thank you for your time,

Huang

Hi @hwp994108018,

Thanks for your message. According to the new information you provided, I think your question is more related to the WordPress and MySQL applications themselves than to the Bitnami installation. Can you open a new thread in the official WordPress forums where someone with more knowledge about the applications and plugins you are using may give you any hint?

https://wordpress.org/support/forums/

Maybe trying to import the information on batches will be faster than trying to load the whole information in a single step, but I’m afraid I’m just guessing on this.

Apart from that, you may be facing performance issues due to the usage of burstable instances in AWS Lightsail. You can check the official information about this type of instances in the link below

https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-viewing-instance-burst-capacity

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