mark_18
-
Posts
5 -
Joined
-
Last visited
Never
Posts posted by mark_18
-
-
hi i just had some help from here in the mysql department of things just wondering if someone could help me connecting to the database. I'v done all the db name and db password and stuff but still wont connect. ill post what it says here
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'marksfor_mark'@'localhost' (using password: YES) in /home/marksfor/public_html/tekchat/config.php on line 15
Unable to connect to database.
anyone have any ideas??
-
thanks richardw it worked a treat.
much appreciated
-
could u paste the fixed version for me please
-
CREATE TABLE users (
id int(11) NOT NULL auto_increment,
username varchar(22) NOT NULL default '',
password varchar(32) NOT NULL default '',
email_address varchar(155) NOT NULL default '',
nickname varchar(255) NOT NULL default '',
user_level enum('0','1','2','3','4',5') NOT NULL default '0',
forum_posts int(11) NOT NULL default '0',
profile text NOT NULL,
siggy varchar(255) NOT NULL default '',
last_post varchar(155) NOT NULL default '0',
last_login varchar(12) NOT NULL default '0',
style varchar(55) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
this is the table im trying to import and ill post below the error its coming up
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problemERROR: Unclosed quote @ 552
STR: '
SQL:
CREATE TABLE users (
id int(11) NOT NULL auto_increment,
username varchar(22) NOT NULL default '',
password varchar(32) NOT NULL default '',
email_address varchar(155) NOT NULL default '',
nickname varchar(255) NOT NULL default '',
user_level enum('0','1','2','3','4',5') NOT NULL default '0',
forum_posts int(11) NOT NULL default '0',
profile text NOT NULL,
siggy varchar(255) NOT NULL default '',
last_post varchar(155) NOT NULL default '0',
last_login varchar(12) NOT NULL default '0',
style varchar(55) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
SQL query:
CREATE TABLE users ( id int(11) NOT NULL auto_increment, username varchar(22) NOT NULL default '', password varchar(32) NOT NULL default '', email_address varchar(155) NOT NULL default '', nickname varchar(255) NOT NULL default '', user_level enum('0','1','2','3','4',5') NOT NULL default '0', forum_posts int(11) NOT NULL default '0', profile text NOT NULL, siggy varchar(255) NOT NULL default '', last_post varchar(155) NOT NULL default '0', last_login varchar(12) NOT NULL default '0', style varchar(55) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5') NOT NULL default '0',
forum_posts int(11) NOT NULL default '0',
profil' at line 7
please help,
thanks
Wont connect to database
in MySQL Help
Posted
sorry it has taken me so long to give you the config.php line 15 as i had to re install my computer.
here is the error
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'marksfor_mark'@'localhost' (using password: YES) in /home/marksfor/public_html/tekchat/config.php on line 15
Unable to connect to database.
and here is like 15 of config.php
$conn = mysql_connect("$dhost","$dusername","$dpwd") or die ("Unable to connect to database.");
it cant be the password as there is only 1 password and username
all your help appreciated