Remote connection to mariadb tables

1

Hi, I need help. I have to connect to the database tables.
At present I modified /etc/mysql/my.cnf bind address = 0.0.0.0 I got the password and the user in the file site_config.json, but I still can’t connect.

2

You need to give the DB permissions for access

  mysql -uroot -pYourMYSQLpasswordOfChoice -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.%.%.%' IDENTIFIED BY 'YourMYSQLpasswordOfChoice' WITH GRANT OPTION;"
  mysql -uroot -pYourMYSQLpasswordOfChoice -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'YourMYSQLpasswordOfChoice' WITH GRANT OPTION;"
  mysql -uroot -pYourMYSQLpasswordOfChoice -Bse "GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%.%' IDENTIFIED BY 'YourMYSQLpasswordOfChoice' WITH GRANT OPTION;"

Adjust the IP to your LAN/subnet

3

Ti ringrazio per l’aiuto, ma … non riesco, sono incapace.
Se fornisco un accesso root (+ nome del database e psw) potresti apportare le modifiche giuste?

4

I thank you for your help, but … I can’t, I’m incapable.
If I provide root access (+ database name and psw) could you make the right changes?

5

I can try - safer if you send me a private message via my profile

6

ok.
I wanted to add that I’m looking for support, not for free.
I’m not a programmer, I had a consultant but I left myself for personal health problems. What I need most is configuration help.