I can connect to database from SSH by using this command
mysql -u admin -p
I am using credentials
username: root
and no password
when try to connect from MYSQL Workbench it give me this error
How to connect to Mysql database using MYSQL Workbench
Note: I can connect to database for another providers using MYSQL Workbench.
You need to bind 0.0.0.0 mariadb service to work remotly and also allow root user to login remotly
@mohamed.soliman Are you test it?
I retry with your solution but no response.
Always keep the security in mind.
Opening MySQL for everyone can be quite a risk.
I want to execute some queries and I will turn off connection again.
You can execute the queries using the Command line!
@miguel I know this solution but the Idea you write a SQL query file and execute it.
In Command Line you write one by one query.
You can unpack phpmyadmin in the www storage.
Then you can use it via user and password vitalpbx.
Rename the phpmyadmin folder to something complicated or delete it again after done.
Yes i use it for some api’s
I reached the issue from MYSQL workbench log
Unsupported version
Unsupported server version: Debian 11 10.5.26-MariaDB-0+deb11u2
06:25:37 [INF][SQL Editor Form]: Opened connection '' to Debian 11 version 10.5.26-MariaDB-0+deb11u2
06:25:38 [INF][ Admin]: Auto-created dummy instance profile for remote connection
06:25:38 [ERR][ WBContext]: Unsupported server version: Debian 11 10.5.26-MariaDB-0+deb11u2
I connect to database from vscode using mysql extension and Now I can create queries without any issues
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.