MySQL Connect Database

[teo_turtle]

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)

 

How to fixed this error ?

 

thank you :-)

[jje]

Did you create the user 'root'?

[Guest Geoff]

You don't have root access to the MySQL database. You need to create users in cpanel.

[teo_turtle]

I have already created user(My username is teo01234_root).

 

How to match teo01234_root and mydatabase ?

[Wizard]

Your database is also prefixed with teo01234_.

[teo_turtle]

yes.

 

my code is(file connect.php) :

 

<?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");

 

?>

[Wizard]

Did you give the user all the permissions it needs?

[teo_turtle]

yes..

 

 

[Wizard]

I think it's cPanel > databases

[teo_turtle]

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

 

how to fix this error ?

[Guest Geoff]

Try connecting with your cpanel username and password.

[Desire Gant]

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)

 

How to fixed this error ?

 

thank you :-)

 

i have the same error

 

<br />

<b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'desiree_root'@'johnny.heliohost.org' (using password: YES) in <b>/home/desiree/public_html/test.php</b> on line <b>2</b><br />

Could not connect: Access denied for user 'desiree_root'@'johnny.heliohost.org' (using password: YES)

 

 

i used this script::

 

<?php

$conect = mysql_connect('desiree.heliohost.org', 'desiree_root', '********');

if (!$conect) {

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

mysql_close($conect);

?>

 

 

i created user desiree_root and i allocated to database

 

the same error if i use cPanel user

 

and yes, i have all permission granted to user

[Guest Geoff]

Try connecting with your cpanel username and password.

[Desire Gant]

Try connecting with your cpanel username and password.

 

 

.........

the same error if i use cPanel user.

 

and, offcourse i used cPanel username- password

[Guest Geoff]

Are you connecting remotely?