[Request]Free webhosting that can connect with php to mysql.

[Thelasthero]

Guys, i tried to connect my php site to 000webhost.com (free), but it said that free webhosting is not allowed to connect. Can you tell me a site with free that it is allowed?

[Hax0r]

also, this one:

[Thelasthero]

<?php
$L2JBS_config["mysql_host"]="localhost";	// MySQL IP
$L2JBS_config["mysql_port"]=3306;		// MySQP port
$L2JBS_config["mysql_db"]="l2jdb";		// l2jdb or your lineage 2 server database name
$L2JBS_config["mysql_login"]="root";		// MySQL Login name	
$L2JBS_config["mysql_password"]="my pass here";		// MySQL Password
$htitle="L2 Unique";				// Site Title
$fut="Napas © Unique <br>2007";		// You can change only server name . You must leave Napas © 
$top="100";					// How many players must be in top100
$hserver="127.0.0.1";				// Server IP
$portgame="7777";				// Game Server Port
$portlogin="2106";				// Server Port
$where='1=1';					
$shat="C:\workspace\thelasthero\gameserver\log\chat.txt"; // bale edo ston fakelo logs t gameserver to arxio chat.log


// Original by Picassoo
//Skin
$skin1="heven";					

//Serever Rates
$exp="1000";
$sp="1000";
$adena="1000";
$items="7";
$spoil="20";


include("_config_procs.php");
error_reporting(0);
?>

my config.php file

[ExTrEmEDwarf]

<?php
$L2JBS_config["mysql_host"]="localhost";	// MySQL IP
$L2JBS_config["mysql_port"]=3306;		// MySQP port
$L2JBS_config["mysql_db"]="l2jdb";		// l2jdb or your lineage 2 server database name
$L2JBS_config["mysql_login"]="root";		// MySQL Login name	
$L2JBS_config["mysql_password"]="my pass here";		// MySQL Password
$htitle="L2 Unique";				// Site Title
$fut="Napas © Unique <br>2007";		// You can change only server name . You must leave Napas © 
$top="100";					// How many players must be in top100
$hserver="127.0.0.1";				// Server IP
$portgame="7777";				// Game Server Port
$portlogin="2106";				// Server Port
$where='1=1';					
$shat="C:\workspace\thelasthero\gameserver\log\chat.txt"; // bale edo ston fakelo logs t gameserver to arxio chat.log


// Original by Picassoo
//Skin
$skin1="heven";					

//Serever Rates
$exp="1000";
$sp="1000";
$adena="1000";
$items="7";
$spoil="20";


include("_config_procs.php");
error_reporting(0);
?>

my config.php file

You have on hserver 127.0.0.1

 

-.-"

[Thelasthero]

You have on hserver 127.0.0.1

 

-.-"

yes, with this ip i have the server.

[ExTrEmEDwarf]

yes, with this ip i have the server.

127.0.0.1 and 192.168.1 are LOCAL hosts.

 

 

None can connect there but you, also you cant add a localhost on a website.

[Thelasthero]

127.0.0.1 and 192.168.1 are LOCAL hosts.

 

 

None can connect there but you, also you cant add a localhost on a website.

so what must i do

[Hax0r]

also root only accepts local connections if I'm not mistaken.

[Thelasthero]

1st) ports are opened

2nd) i add my no-ip to hserver

Error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/a9522426/public_html/config/_config_procs.php on line 3

 

Free Web Hosting

Couldn't connect to MySQL

 

Extreme please give me an example of yours config.php file to understand.

[ExTrEmEDwarf]

i have an upload script, why would you need it for? D:

 

You just didnt add the right password on your configs

[Thelasthero]

i have an upload script, why would you need it for? D:

 

You just didnt add the right password on your configs

Everything is as it should be.

 

config.php file:

<?php
$L2JBS_config["mysql_host"]="";	// MySQL IP
$L2JBS_config["mysql_port"]=3306;		// MySQP port
$L2JBS_config["mysql_db"]="l2jdb";		// l2jdb or your lineage 2 server database name
$L2JBS_config["mysql_login"]="thelasthero";		// MySQL Login name	
$L2JBS_config["mysql_password"]="mypass";		// MySQL Password
$htitle="L2 Unique";				// Site Title
$fut="Napas © Unique <br>2007";		// You can change only server name . You must leave Napas © 
$top="100";					// How many players must be in top100
$hserver="127.0.0.1";				// Server IP
$portgame="7777";				// Game Server Port
$portlogin="2106";				// Server Port
$where='1=1';					
$shat="C:\workspace\thelasthero\gameserver\log\chat.txt"; // bale edo ston fakelo logs t gameserver to arxio chat.log


// Original by Picassoo
//Skin
$skin1="heven";					

//Serever Rates
$exp="1000";
$sp="1000";
$adena="1000";
$items="7";
$spoil="20";


include("_config_procs.php");
error_reporting(0);
?>

(Note: I want to connect to site, not others that's why i have 127.0.0.1 to hserver)

 

_config_procs.php:

<?php
$L2JBS_config["javascript_sort_method"]="bubble";
  $link = mysql_connect($L2JBS_config['mysql_host'].":".$L2JBS_config['mysql_port'], $L2JBS_config['mysql_login'], $L2JBS_config['mysql_password']);
  if (!$link)
    die("Couldn't connect to MySQL");
  @mysql_select_db($L2JBS_config['mysql_db'], $link)
    or die ('Error '.mysql_errno().': '.mysql_error());

?>

[Hax0r]

Don't ignore me. You MUST create another user to connect.

user 'root' is only for local connections.

[Thelasthero]

Don't ignore me. You MUST create another user to connect.

user 'root' is only for local connections.

i made use thelasthero can't you see????????

[Hax0r]

I saw that:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES)

 

 

anyway, does it say anything?

[Thelasthero]

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'thelasthero'@'localhost' (using password: YES) in /home/a9522426/public_html/config/_config_procs.php on line 3

 

[Hax0r]

Access denied for user 'thelasthero'@'localhost'

localhost? are you crazy?

 

change:

$hserver="your IP/no-ip";