Hello everyone!
I recently installed HestiaCP and was looking at older posts, but maybe I misread them. I setup a MySQL database and wanted to use it via 3rd party app (like Navicat), I opened up the port, but no luck.
My other question is: how do I access mysql as root user? The posts I found send me to dir I do not have. Weirdly enough. Ty in advance!
Well, now I feel dumb. Found an answer to my first question in documentation (Database & phpMyAdmin SSO | Hestia Control Panel).
nano /etc/mysql/mariadb.conf.d/50-server.cnf
bind-address = 0.0.0.0
bind-address = “your.server.ip.address”
Although I removed the " from the second line. Now having issues getting to setup root access to database.
Please paste the error you encounter here so that we can help you analyze it. We will help you solve it together!
You will find a file having the name .my.cnf under the /root. The login details are inserted in there. This will help you create a root connection, changing root password, etc.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.