teo_turtle Posted March 21, 2011 Share Posted March 21, 2011 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 :-) Link to comment Share on other sites More sharing options...
jje Posted March 21, 2011 Share Posted March 21, 2011 Did you create the user 'root'? Link to comment Share on other sites More sharing options...
Guest Geoff Posted March 21, 2011 Share Posted March 21, 2011 You don't have root access to the MySQL database. You need to create users in cpanel. Link to comment Share on other sites More sharing options...
teo_turtle Posted March 22, 2011 Author Share Posted March 22, 2011 I have already created user(My username is teo01234_root). How to match teo01234_root and mydatabase ? Link to comment Share on other sites More sharing options...
Wizard Posted March 22, 2011 Share Posted March 22, 2011 Your database is also prefixed with teo01234_. Link to comment Share on other sites More sharing options...
teo_turtle Posted March 22, 2011 Author Share Posted March 22, 2011 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"); ?> Link to comment Share on other sites More sharing options...
Wizard Posted March 22, 2011 Share Posted March 22, 2011 Did you give the user all the permissions it needs? Link to comment Share on other sites More sharing options...
teo_turtle Posted March 22, 2011 Author Share Posted March 22, 2011 yes.. Link to comment Share on other sites More sharing options...
Wizard Posted March 22, 2011 Share Posted March 22, 2011 I think it's cPanel > databases Link to comment Share on other sites More sharing options...
teo_turtle Posted March 24, 2011 Author Share Posted March 24, 2011 http://img837.imageshack.us/i/cpanelr.png/ how to fix this error ? Link to comment Share on other sites More sharing options...
Guest Geoff Posted March 25, 2011 Share Posted March 25, 2011 Try connecting with your cpanel username and password. Link to comment Share on other sites More sharing options...
Desire Gant Posted March 27, 2011 Share Posted March 27, 2011 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 Link to comment Share on other sites More sharing options...
Guest Geoff Posted March 28, 2011 Share Posted March 28, 2011 Try connecting with your cpanel username and password. Link to comment Share on other sites More sharing options...
Desire Gant Posted March 28, 2011 Share Posted March 28, 2011 Try connecting with your cpanel username and password. ......... the same error if i use cPanel user. and, offcourse i used cPanel username- password Link to comment Share on other sites More sharing options...
Guest Geoff Posted March 28, 2011 Share Posted March 28, 2011 Are you connecting remotely? Link to comment Share on other sites More sharing options...
Recommended Posts