943,671 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 1143
  • PHP RSS
Aug 25th, 2009
0

table creation via PHP

Expand Post »
i am using a PHP file to first connect to my database and then make a table in that database. i am able to connect to the database fine but i can not create a table, it keeps on saying:

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!

i dont know why it is saying this especially when i didnt put that password in. can somebody please help me? thankyou.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
usmanbssi is offline Offline
3 posts
since Aug 2009
Aug 25th, 2009
0

Re: table creation via PHP

Validate your login credentials have the proper privileges.
Team Colleague
Reputation Points: 211
Solved Threads: 27
Master Poster
Paladine is offline Offline
793 posts
since Feb 2003
Aug 25th, 2009
0

Re: table creation via PHP

i am using phpmyadmin and i went to privlages and it says nothing close to what i need. what do i do?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
usmanbssi is offline Offline
3 posts
since Aug 2009
Aug 25th, 2009
-1

Re: table creation via PHP

Go to mysql console and create a new user either by following http://dev.mysql.com/doc/refman/5.1/...ing-users.html OR go to phpmyadmin -> mysql database -> user table. Add a record there filling suitable fields and giving relevant privileges.
Moderator
Featured Poster
Reputation Points: 524
Solved Threads: 356
Purple hazed!
nav33n is offline Offline
3,878 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: email attachment
Next Thread in PHP Forum Timeline: PhoneBook Script [Project]





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC