NodeRED fails to connect to PhpMyAdmin / MySQL

My YunoHost server

Hardware: Raspberry 3B+
YunoHost version: 11
I have access to my server : SSH
Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : connect over wlan0 only local setup
If your request is related to an app, specify its name and version:

  • nodered 3.0.2~ynh4 installed on nodered.local
  • phpmyadmin 5.2.1~ynh1 installed on phpmyadmin.local

Description of my issue

I’m trying to write data in a mysql database from a NodeRED flow using node-red-node-mysql.
I created the database in PHPmyAdmin, I also created a phpmyadmin_local_user with access rights to the DB

Here are credentials I tried (user | pwd) :

  • phpmyadmin_local_user | phpmyadmin_local_user_pwd
  • root |
  • root | yunohost_admin_pwd

I’m never able to connect, e.g. with root | :

08/02/2024 10:52:14[node: 92a67d0a29ecacdd](https://nodered.local/admin/#)
msg : string[22]
"Database not connected"

Keep these and check out

It looks like it depends on how fast you trigger the SQL node?

It was just an issue with the password. Either I made a mistake typing it in NodeRED, or the password was not accepted. Thank you !

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