Navicat/MySQL Problems

[foamysquirl]

Let me start this post off by saying I am not an idiot. I have come here to look for legitimate help for this problem. If you are going to post something that you think someone with half a brain would have already tried, please don't. Odds are, I've tried it. Now-- On to the problem.

I hate MySQL. I'm experienced in Emulation and servers, and this program is the most bothersome part of the entire experience. Therefore, to simplify things, I have downloaded the Xampp Control Panel. Within this control panel, I've managed to set the MySQL server password to what I desire-- all is well in that category. The problem is, I have a multi-person team for my server (We're experienced, and running a legitimate server that you intend people to play on is certainly not a one-man job), and we are currently having trouble even making a navicat connection. When we put our DynDNS hostname into the hostname/IP box, we are getting error 1130- Host is not allowed to connect to this MySQL server. The problem may be that I have not enabled remote access with this Xampp program-- something I am not quite sure how to do. Nevertheless, this is a serious problem, we need this fixed ASAP. Now trust me, this is our last resort. I am aware of search engines... and yes, I have used them. I know there are experts here that will be able to help me with this problem, and that help is very much appreciated.

As another side note, please do not tell me to use "localhost" as the connection hostname-- that would defeat the entire purpose of what I am trying to do. I wish to still be able to remotely edit the database even though it is located on my partner's computer.

[Eleatha]

First of all, I have no experience with Xamp, however,
the connection name is merely a to identify the connection you are using
Have you added the host as user with correct credentials (rights) on you Mysql server?

How to do this depends on what you use to manage your msql server and databases

Also, if you have done so, do not forget to Flush privileges.

good luck

[foamysquirl]

First of all, I have no experience with Xamp, however,
the connection name is merely a to identify the connection you are using
Have you added the host as user with correct credentials (rights) on you Mysql server?

How to do this depends on what you use to manage your msql server and databases

Also, if you have done so, do not forget to Flush privileges.

good luck

This has helped a lot, and has made me realize what I need to do. The only problem is, I don't know how to do it. If anyone knows how to correctly add a user for your mysql server using xampp, please speak up. Help would be much appeciated.

[Heliumz]

I have a suggestion:
Why you don't use a remote program (remote computer etc.. google it) that connect you to your partner's computer (the computer database) and then edit the sql database with a localhost connection

[foamysquirl]

I have a suggestion:
Why you don't use a remote program (remote computer etc.. google it) that connect you to your partner's computer (the computer database) and then edit the sql database with a localhost connection

Hmm.. This sounds interesting. And could possibly work-- but I have no knowledge of such a program. I can indeed google it myself but I have no idea what to look for. A name would help greatly.