Im stuck..how do I connect to SQL

[bladewarriors]

Isnt there a way to connect to my website with sqlyog or navicat?
I have ad-enhanced website.
I have on user and password etc but i dont know why it doesn work..im new on x10hosting

 

[kajasweb]

You have to add your Static Ip in Remote SQL Section of cPanel and Pm Corey to add your IP in Firewall allow list for MySQL Server.

 

[naim4u]

you should use this tag to connect to your mysql server:

<?php



define('DBUSER','rootusername);

define('DBPASS','yourpassword');

define('DBNAME','databasename');

define('DBHOST','localhost');



mysql_connect(DBHOST,DBUSER,DBPASS) or die(mysql_error());

if(!mysql_select_db(DBNAME)){

echo 'Unable to select database.'.mysql_error();

exit;

}



?>



like this in your php fileeeeee if you use remote site :rename localhost to you sqlhost server.