MySQL Connect Database

[Desire Gant]

Are you connecting remotely?

no, i cannot connect using other client. any kind of connection is prohibited

[jje]

Try using a user called something other than 'root'.

 

For example: jje_user

[Desire Gant]

Try using a user called something other than 'root'.

 

For example: jje_user

 

yes, i tryed with other user, desiree_test was the last. Nothing happened

[Guest Geoff]

Put an asterick in the box in remote mysql in your cpanel.

[Desire Gant]

Put an asterick in the box in remote mysql in your cpanel.

 

 

great!!! thank you

[jje]

 

Pinning, as this topic is useful.

[Guest Geoff]

great!!! thank you

 

You're welcome.

[teo_turtle]

<?php

 

$host="cine.heliohost.org";

$username="teo01234_root";

$password="********";

$db_selected="teo01234_cine";

 

 

 

$mysqli=mysqli_connect($host,$username,$password,$db_selected);

 

if(mysqli_connect_errno())

{

 

 

printf("Connect failed: %s\n ",mysqli_connect_error());

exit;

}

 

mysqli_query($mysqli,"set names utf8");

 

?>

 

http://img837.imageshack.us/i/cpanelr.png/

 

 

 

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'teo01234_root'@'216.218.192.170' (using password: YES) in /home1/teo01234/public_html/cine/include/connect.php on line 10

Connect failed: Access denied for user 'teo01234_root'@'216.218.192.170' (using password: YES)

 

 

please how to fixed this error? step by step. :-)

[jje]

Try using a user called something other than 'root'.

 

For example: jje_user

[teo_turtle]

ok.

[jje]

 

Let me know how you get on.

[teo_turtle]

$host="cine.heliohost.org";

$username="teo01234_user";

$password="************";

$db_selected="teo01234_cine";

 

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'teo01234_user'@'216.218.192.170' (using password: YES) in /home1/teo01234/public_html/cine/include/connect.php on line 10

Connect failed: Access denied for user 'teo01234_user'@'216.218.192.170' (using password: YES)

 

[jje]

Did you...

 

Put an asterick in the box in remote mysql in your cpanel.

 

..?

[teo_turtle]

how to fix this error.

 

I am confused

[jje]

On the cPanel homepage (straight after you login), click on 'Remote SQL'. In the box provided, enter *