Good idea. In brief, you need to add a new "root" user with % as the host name. Use the IP address of the host computer to refer to the server. I will create a video that shows these steps since this is a common question with students in my class.
@@shadsluiter Thank you for reply. But why exactly "root" user? I want to create "test" user and restrict the rights of actions. And it just doesn't work somehow with the ip address. I am thinking if the problem exists because my (host) computer is connected to internet through a hotspot from my mobile phone. Or my friend does not have sql installed on her computer while using Workbench, or Windows is preventing connection to my virtual sql server. Or... I feel so lost...
![Mysql Index Tutorial | [Simple Explanation] [2020]](http://i.ytimg.com/vi/kv3jC0P4gOc/mqdefault.jpg)
Im already a software engineer working but sometimes i like refreshers and you do a great job 👍 thank you
I appreciate that!
Do you have something on remote connection to mysql database hosted on a private computer, please?
Good idea. In brief, you need to add a new "root" user with % as the host name. Use the IP address of the host computer to refer to the server. I will create a video that shows these steps since this is a common question with students in my class.
@@shadsluiter Thank you for reply. But why exactly "root" user? I want to create "test" user and restrict the rights of actions. And it just doesn't work somehow with the ip address. I am thinking if the problem exists because my (host) computer is connected to internet through a hotspot from my mobile phone. Or my friend does not have sql installed on her computer while using Workbench, or Windows is preventing connection to my virtual sql server. Or... I feel so lost...