SQL server to connect to

[new_future]

Hello guys.
I've finally found something to make an SQL connection with, but the server said by the phpMyAdmin isn't working.

mysql-starka.x10hosting.com
If it is, what do I have to fill in at user?

 

[jtwhite]

For future references, it's always a good idea to post support requests here: http://forums.x10hosting.com/free-hosting/

The mysql host is "localhost" (without quotes).

You can create a MySQL user/database in cPanel.

Login to cPanel and scroll down to the Databases section and click on "MySQL(R) Database Wizzard" and follow the on-screen instructions.

 

[new_future]

I made an account in the MySQL cPanel.

How can an executable, located on your pc, connect to the SQL on a website using 'localhost'?
Unless you ment in PHP, because then it was my fault that you answered that

 

[jtwhite]

Oh, I'm sorry but the free hosting does not allow remote MySQL connections for security and server load reasons.

You would need to purchase hosting in order to use remote MySQL.

 

[new_future]

Great... going through hours and hours of work... to find out I need another host (kinda short on budget).

Ok, cya guys!

 

[jtwhite]

Good luck with your new host.

 

[new_future]

Thank ye
Gonna need it, had 10 hosts... neither of them supports external SQL so I'm pretty screwed

 

[ah-blabla]

You could always write a php / shell / python / perl interface to mySql (i.e. web based), and then use another program at the other end to bring it back to a mySQL interface if you were determined enough.

 

[new_future]

Uhh... that made like 1% sense to me xD
Anyways, it's for a Client-Client application, and the connection has to be as fast as possible, since around 100 clients will connect it at the same time.

 

[ah-blabla]

Uhh... that made like 1% sense to me xD
Anyways, it's for a Client-Client application, and the connection has to be as fast as possible, since around 100 clients will connect it at the same time.

My solution probably wouldn't be too good for that. But if you want really good performance I wouldn't use free hosting anyway, since it does occasionally suffer performace issues and outages. Paid hosting here I think offers remote MySQL, and is very reliable.

 

[new_future]

I'll keep it in mind once my game is done.
I just need something to test with, and I'm not going to pay for that xD

 

[jtwhite]

You could always down XAMPP server or something like that for testing.

http://www.apachefriends.org/en/xampp.html

 

[new_future]

Tried that, didn't get it to work, no matter what I did.
Btw, found a host for a 25MB MySQL server with remote SQL, so I'm fine for now.