Connecting database

[zestpanlo92]

Hi everyone. anyone there can help me? i cant connect my database in x10hosting.com.
pls help me. the error message is "Lost connection to MySQL server at 'reading initial communication packet', system error: 111"

 

[MaestroFX1]

Could you please post your domain name ?

 

[zestpanlo92]

my domain is www.greenscarf.co.cc
and i was connecting my database to my blog

---------- Post added at 09:29 AM ---------- Previous post was at 09:27 AM ----------

Could you please post your domain name ?

my domain is www.greenscarf.co.cc
and i want to connect my database to my blog

 

[MaestroFX1]

It is working for me!

 

[zestpanlo92]

It is working for me!

yes.. my domain is working... but if you click the TAB named BLOGS you will see the error

 

[MaestroFX1]

What did you use "mysql server name" as ?
It should be localhost.

 

[zestpanlo92]

What did you use "mysql server name" as ?
It should be localhost.

heres my code:

<?php
// Your host, 99% of the time it's localhost.
$db_host = 'localhost';
// Your username for MySQL.
$db_user = 'aianzki_aianzki';
// Your password for MySQL.
$db_pass = 'mypassword';
// And your given name for the database.
$db_name = 'aianzki_greenscarf';

// The database connection.
$con = mysql_connect($db_host, $db_user, $db_pass);
if(!$con) {
die("Cannot connect. " . mysql_error());
}
// The database name selection.
$dbselect = mysql_select_db($db_name);
if(!$dbselect) {
die("Cannot select database " . mysql_error());
}
?>

 

[MaestroFX1]

Have you granted all the required privileges to the mysql user?

 

[zestpanlo92]

Have you granted all the required privileges to the mysql user?

yes i granted all there permission.. in MySql Database and also to the MySql Database Wizard

---------- Post added at 09:58 AM ---------- Previous post was at 09:52 AM ----------

Have you granted all the required privileges to the mysql user?

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/aianzki/public_html/connect.php on line 12
Cannot connect. Lost connection to MySQL server at 'reading initial communication packet', system error: 111

 

[MaestroFX1]

What sort of data are you trying to fetch ?
Is it of type blob? How many tables are there ?

 

[zestpanlo92]

What sort of data are you trying to fetch ?
Is it of type blob? How many tables are there ?

its only 2 tables.. just for the comment

 

[MaestroFX1]

Just to be safe, I will iterate this:
---------
servername = localhost
username = cpanelusrname_databaseusrname
databasename = cpanelusrname_database
password = password for cpanelusrname_databaseusrname not cpanelusrname

databasename and username should be linked with required privileges set.
---------

Have you tried a standalone php script connecting to your database ?
Like yours aforementioned php script as a standalone .php file!

 

[zestpanlo92]

What sort of data are you trying to fetch ?
Is it of type blob? How many tables are there ?

it has have two tables.. just for a comment and for the data

---------- Post added at 03:22 PM ---------- Previous post was at 10:12 AM ----------

Just to be safe, I will iterate this:
---------
servername = localhost
username = cpanelusrname_databaseusrname
databasename = cpanelusrname_database
password = password for cpanelusrname_databaseusrname not cpanelusrname

databasename and username should be linked with required privileges set.
---------

Have you tried a standalone php script connecting to your database ?
Like yours aforementioned php script as a standalone .php file!

yes.. i tried standalone.. and it connects. but when i import it through online its not working

 

[MaestroFX1]

but when i import it through online its not working
---------
Import how ? Could please elaborate ?

Is it like

<?php
include ('/blah/somefile.php');
?>

or what ?

 

[zestpanlo92]

i tried it to my xampp the code i use in connecting to database. and it works.. and then.. when i uploaded it to online. the database cant connect no more..

---------- Post added at 03:45 PM ---------- Previous post was at 03:43 PM ----------

but when i import it through online its not working
---------
Import how ? Could please elaborate ?

Is it like

<?php
include ('/blah/somefile.php');
?>

or what ?

in short the website that i create is working on LAN BASED using my XAMPP..

 

[MaestroFX1]

<?php
mysql_connect("localhost", "cpanelusrname_databaseusername", "databaseusername_password") or die(mysql_error());
echo "Auth Pass<br />";
mysql_select_db("cpanelusrname_databasename") or die(mysql_error());
echo "DB Con Pass";
?>

Save it - example.php

Try this here on x10.
Post your results back.

 

[zestpanlo92]

here's the result:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'aianzki_aian'@'web3.vital.x10hosting.com' (using password: YES) in /home/aianzki/public_html/connect.php on line 2
Access denied for user 'aianzki_aian'@'web3.vital.x10hosting.com' (using password: YES)

 

[MaestroFX1]

here's the result:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'aianzki_aian'@'web3.vital.x10hosting.com' (using password: YES) in /home/aianzki/public_html/connect.php on line 2
Access denied for user 'aianzki_aian'@'web3.vital.x10hosting.com' (using password: YES)

Check your database user password (not cpanel user password).

Grant cpanelusrname_databaseusername all the reuired privileges to the cpanelusrname_databasename.

Use :
cPanel >>MySQL Databases >> Current Databases
Click the cpanelusrname_databaseusername to open
MySQL Account Maintenance

Manage User Privileges

User: cpanelusrname_databaseusername
Database: cpanelusrname_databasename

Set the required PRIVILEGES (Just grant all PRIVILEGES)

---
Also, if the cpanelusrname_databaseusername alongside cpanelusrname_databasename doesn't show upin the above table ; use "Add User To Database" and click add.

 

[zestpanlo92]

yes i tried that many times.. but it does not work. i check all the PRIVILEGES also in the mySQL database wizard..
hiazt... tommorow is my deadline...

 

[descalzo]

cPanel --> Remote MySQL

Please post the IP's listed