Skip to content

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

Featured Replies

sqlew7.jpg

also, this one:

accessp.jpg

  • Author

<?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

<?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

 

-.-"

  • Author

You have on hserver 127.0.0.1

 

-.-"

yes, with this ip i have the server.

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.

  • Author

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

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

  • Author

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.

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

 

You just didnt add the right password on your configs

  • Author

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());

?>

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

user 'root' is only for local connections.

  • Author

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????????

I saw that:

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

 

 

anyway, does it say anything?

  • Author

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

 

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.