mysql server with network connect

happyreacer · 21. November 2014

Hi All,

i've used mysql plugin for a lot of plugins and it works. I will use it for a programm on my PC an laptop too. On the mysql plugin options i activate network. the config on my PC is servername "omv" (i test it with the IP too) the right port 3306 and the username and password. but i bekome the error:

Code

Can't connect to MySQL server on '192.168.178.28' (111) QMYSQL: Verbindungsaufbau nicht möglich

I test with a 0.0.0.0 IP for the mysql too and the error is:

Code

Host 'PC.host' is not allowed to connect to this MySQL server QMYSQL: Verbindungsaufbau nicht möglich

everybody can help?

ryecoaaron · 21. November 2014

That allows you to connect to the server but not a database. You need to set which hosts can connect to the specific databases. I use mysql_setpermission from the command line to do this.

Actually, you can use the User Manager in MyWebSQL to add a user with privileges. Just tried it and it worked.

happyreacer · 21. November 2014

thanks, do you have a totorial for thes?

ryecoaaron · 21. November 2014

Log into MyWebSQL
Go to Tools -> User Manager
Click Add User
Fill in username
Host is the address you want to connect from
Enter password
If you are just using select sql statements, check Select in the Database Privileges.

happyreacer · 21. November 2014

thanks, it works

Jetzt mitmachen!