connecting to mysql problems..

[partymaker]

My subdomain is:www.toni.x10hosting.com
I created new user in mysql db, for connecting to "bd" from other host server.(useing PHP of course).
for exemple:new user name:wert;
password:123456

For connecting I write:
$username = "wert";
$password = "123456";
$server = "toni.x10hosting";
$mysqlconnection = mysql_connect($server, $username, $password);

Where I do mistake?
Please help!

 

[themasterrocker]

shouldn't it be toni.x10hosting.com for the server? i mean i don't know alot about mysql but that would have been one of the obvious bits

 

[marshian]

username would be {cpanelusername}_wert, password "123456", server "localhost"
So mysql_connect is like this: mysql_connect("localhost", "toni_wert", "123456");

 

[DeadBattery]

The problem is your host name
Instead of

toni.x10hosting

use

localhost

Here is the code using localhost:

$username = "wert";
$password = "123456";
$server = "localhost";
$mysqlconnection = mysql_connect($server, $username, $password);

Give that a try; I'm 100% sure it will work.

 

[themasterrocker]

Didn't Marshian just say the same thing?

 

[GBH187]

Didn't Marshian just say the same thing?

No Marshian suggested changing the username also which is not correct
the only issue here is the hostname is wrong

 

[cowctcat]

no Marshian is correct. the username should be (cpannel_name)_wert
and the host shold be toni.x10hosting.com if you are connecting from a different server which it sounds like you are trying to.

 

[partymaker]

I'm connecting from different server.
$server = "localhost"; is not the solution for my problem!

 

[marshian]

As cowctcat said, if you want to connect from a remote server, the server is indeed "toni.x10hosting", and not "localhost"

 

[TechAsh]

x10Hosting does not allow user to connect to their MySQL databases from remote servers.

 

[partymaker]

I understand.Thanks for help.

 

[tnl2k7]

This has been resolved so I'll close it .

-Luke.

* Thread Closed *