Jump to content


Photo

MySQL Connect Database


  • This topic is locked This topic is locked
45 replies to this topic

#16 Desire Gant

Desire Gant

    Newbie

  • Members
  • 5 posts

Posted 29 March 2011 - 09:22 AM

QUOTE (Geoff @ Mar 28 2011, 09:31 PM) <{POST_SNAPBACK}>
Are you connecting remotely?

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

#17 jje

jje

    Rank X Member

  • Moderators
  • 2,769 posts
  • Gender:Male
  • Location:UK

Posted 29 March 2011 - 03:24 PM

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

For example: jje_user
Support Administrator | @HelioHost on Twitter.
Posted Image

#18 Desire Gant

Desire Gant

    Newbie

  • Members
  • 5 posts

Posted 29 March 2011 - 04:32 PM

QUOTE (jje @ Mar 29 2011, 03:24 PM) <{POST_SNAPBACK}>
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

#19 Guest_Geoff_*

Guest_Geoff_*
  • Guests

Posted 29 March 2011 - 10:03 PM

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

#20 Desire Gant

Desire Gant

    Newbie

  • Members
  • 5 posts

Posted 30 March 2011 - 02:16 PM

QUOTE (Geoff @ Mar 29 2011, 10:03 PM) <{POST_SNAPBACK}>
Put an asterick in the box in remote mysql in your cpanel.



great!!! thank you smile.gif

#21 jje

jje

    Rank X Member

  • Moderators
  • 2,769 posts
  • Gender:Male
  • Location:UK

Posted 30 March 2011 - 02:45 PM

ohmy.gif

Pinning, as this topic is useful.
Support Administrator | @HelioHost on Twitter.
Posted Image

#22 Guest_Geoff_*

Guest_Geoff_*
  • Guests

Posted 31 March 2011 - 09:31 PM

QUOTE
great!!! thank you


You're welcome.

#23 teo_turtle

teo_turtle

    Rank II Member

  • Members
  • PipPip
  • 55 posts

Posted 02 April 2011 - 10:09 AM

<?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.images.../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. :-)

#24 jje

jje

    Rank X Member

  • Moderators
  • 2,769 posts
  • Gender:Male
  • Location:UK

Posted 02 April 2011 - 10:14 AM

QUOTE (me)
Try using a user called something other than 'root'.

For example: jje_user

Support Administrator | @HelioHost on Twitter.
Posted Image

#25 teo_turtle

teo_turtle

    Rank II Member

  • Members
  • PipPip
  • 55 posts

Posted 02 April 2011 - 10:23 AM

ok.

#26 jje

jje

    Rank X Member

  • Moderators
  • 2,769 posts
  • Gender:Male
  • Location:UK

Posted 02 April 2011 - 10:29 AM

wink.gif

Let me know how you get on. smile.gif
Support Administrator | @HelioHost on Twitter.
Posted Image

#27 teo_turtle

teo_turtle

    Rank II Member

  • Members
  • PipPip
  • 55 posts

Posted 02 April 2011 - 10:31 AM

$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)

sad.gif

#28 jje

jje

    Rank X Member

  • Moderators
  • 2,769 posts
  • Gender:Male
  • Location:UK

Posted 02 April 2011 - 10:40 AM

Did you...

QUOTE (Geoff)
Put an asterick in the box in remote mysql in your cpanel.


..?
Support Administrator | @HelioHost on Twitter.
Posted Image

#29 teo_turtle

teo_turtle

    Rank II Member

  • Members
  • PipPip
  • 55 posts

Posted 02 April 2011 - 10:53 AM

how to fix this error.

I am confused unsure.gif

#30 jje

jje

    Rank X Member

  • Moderators
  • 2,769 posts
  • Gender:Male
  • Location:UK

Posted 02 April 2011 - 11:47 AM

On the cPanel homepage (straight after you login), click on 'Remote SQL'. In the box provided, enter *
Support Administrator | @HelioHost on Twitter.
Posted Image




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users