table creation via PHP

Reply

Join Date: Aug 2009
Posts: 2
Reputation: usmanbssi is an unknown quantity at this point 
Solved Threads: 0
usmanbssi usmanbssi is offline Offline
Newbie Poster

table creation via PHP

 
0
  #1
Aug 25th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Feb 2003
Posts: 793
Reputation: Paladine has a spectacular aura about Paladine has a spectacular aura about Paladine has a spectacular aura about 
Solved Threads: 26
Team Colleague
Paladine's Avatar
Paladine Paladine is offline Offline
Master Poster

Re: table creation via PHP

 
0
  #2
Aug 25th, 2009
Validate your login credentials have the proper privileges.
Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code
Reply With Quote Quick reply to this message  
Join Date: Aug 2009
Posts: 2
Reputation: usmanbssi is an unknown quantity at this point 
Solved Threads: 0
usmanbssi usmanbssi is offline Offline
Newbie Poster

Re: table creation via PHP

 
0
  #3
Aug 25th, 2009
i am using phpmyadmin and i went to privlages and it says nothing close to what i need. what do i do?
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 3,746
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 331
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: table creation via PHP

 
-1
  #4
Aug 25th, 2009
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.
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC