Zymic Forums

Webmaster resources

Zymic IRC Server

Chat in real time at irc.zymic.com - Learn More

Welcome

Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.

In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.

left Zymic Webmaster ForumsZymic Free Web HostingDatabases & MySQL right
  Reply to this topic Start new topic
left right
ShadowZA
post Jan 9 2012, 06:20 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 9-January 12
Member No.: 224,863



Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'vhostswww'@'192.168.1.1' (using password: NO) in /www/clanteam.com/c/l/i/clientnova/htdocs/index.php on line 38
Can't connect to database

whats wrong?
Go to the top of the page 
 
  + Quote Post
ssfdre38
post Jan 9 2012, 06:40 AM
Post #2


THE SILENT FORUM NINJA
*******

Group: Administrators
Posts: 3,697
Joined: 23-January 10
From: on your screen
Member No.: 127,507



vhostwww is not your user its something like 123456_user. just go to http://zymickb.tk/index.php/MySQL
Go to the top of the page 
 
  + Quote Post
ShadowZA
post Jan 9 2012, 06:55 AM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 9-January 12
Member No.: 224,863



This is what i did.

CODE
$host="localhost";
$username="645057_shadow";
$password="#######";
$db_name="clientnova_clanteam_info";
$tbl_name="accounts";


Is there something wrong?
Go to the top of the page 
 
  + Quote Post
ShadowZA
post Jan 9 2012, 08:49 AM
Post #4


Newbie
*

Group: Members
Posts: 4
Joined: 9-January 12
Member No.: 224,863



Can someone please help me?????

link: http://clientnova.clanteam.com/
Go to the top of the page 
 
  + Quote Post
ssfdre38
post Jan 9 2012, 09:12 AM
Post #5


THE SILENT FORUM NINJA
*******

Group: Administrators
Posts: 3,697
Joined: 23-January 10
From: on your screen
Member No.: 127,507



what is your mysql_connect() coding?
Go to the top of the page 
 
  + Quote Post
ShadowZA
post Jan 9 2012, 09:44 AM
Post #6


Newbie
*

Group: Members
Posts: 4
Joined: 9-January 12
Member No.: 224,863



CODE
CREATE TABLE Account
(
username varchar(255),
password varchar(255),
hwid varchar(255),
code varchar(255)
)


CREATE TABLE members
(
id int NOT NULL AUTO_INCREMENT,
username varchar(255),
password varchar(255),
PRIMARY KEY (id)
)


CODE
<?php
$host="SQL09.FREEMYSQL.NET"; // Host name
$username="shadowza"; // Mysql username
$password="******"; // Mysql password
$db_name="novaclient"; // Database name
$tbl_name="accounts"; // Table name

$usr = $_GET['usr'];
$pas = $_GET['pas'];
$hwid = $_GET['hwid'];
$code = $_GET['code'];

$con = mysql_connect("$host", "$username", "$password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$db_name", $con);

mysql_query("UPDATE $tbl_name SET username = '$usr', password = '$pas', hwid = '$hwid'
WHERE code = '$code' AND username = '-' AND password = '-' AND hwid = '-'");

mysql_close($con);
?>
Go to the top of the page 
 
  + Quote Post
ssfdre38
post Jan 9 2012, 05:21 PM
Post #7


THE SILENT FORUM NINJA
*******

Group: Administrators
Posts: 3,697
Joined: 23-January 10
From: on your screen
Member No.: 127,507



your trying to connect to a remote MySQL server and we have remote connections disable so you will have to use our database and not a remote database
Go to the top of the page 
 
  + Quote Post
 Reply to this topic Start new topic
left right
0 Members:
left right
 


Lo-Fi Version Time is now: 18th May 2013 - 10:54 AM