table creation via PHP
Posted by: usmanbssi@gmail.com (---.dsl.lsan03.sbcglobal.net)
Date: August 27, 2009 05:17AM

i am using a php file to first connect to a database, then create a table inside of it. i am able to connect to the database fine but i cant create a table it says:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\php\create_Table.php on line 29

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\php\create_Table.php on line 29
no TABLE created. You have problems in the system already, backtrack and debug!

now someone told me i have to change the privlages on my user. ON that user i have all of the privlages selected and i dont understand why it is saying that i am using the password:NO. i am not using that password so i really dont get, can someone please help me?

Options: ReplyQuote
Re: table creation via PHP
Posted by: toumimi (---.115.116-78.rev.gaoland.net)
Date: August 27, 2009 11:04AM

"No" means you have not precised a password (no password) when you used mysql_connect function.
Check your param into that function
$link = mysql_connect("localhost", "mysql_user", "mysql_password"winking smiley

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Options: ReplyQuote
Re: table creation via PHP
Posted by: yfastud (Moderator)
Date: August 27, 2009 02:04PM

you have to create db first
to setup db, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote


Sorry, only registered users may post in this forum.