Computing.Net > Forums > Web Development > Mysql problems in creating a db

Mysql problems in creating a db

Reply to Message Icon

Original Message
Name: webmx04
Date: June 26, 2005 at 23:12:07 Pacific
Subject: Mysql problems in creating a db
OS: winxp
CPU/Ram: 2.4ghz / 512ddr
Comment:

Guys please help me with this php and mysql prob I just installed a phpdev5 bundle and when I tried to use phpmyadmin at first I was able to create a database then after I restart it gave me a error

Database running on localhost
Error

SQL-query :

CREATE DATABASE

MySQL said:


You have an error in your SQL syntax near '' at line 1

what should I do I`m really a newbie here I just want to branch out from graphic design to web developing please help thanks please reply

The Bold and the beautiful


Report Offensive Message For Removal


Response Number 1
Name: Xoplex
Date: June 27, 2005 at 12:14:07 Pacific
Reply: (edit)

Did you restart your mysql server as well?
Is everything set to launch on startup?

Can you post the first few lines of the script?

XO


Report Offensive Follow Up For Removal

Response Number 2
Name: jimminy
Date: June 27, 2005 at 15:46:10 Pacific
Reply: (edit)

Could you post the line from the script referred to in this error message:

You have an error in your SQL syntax near '' at line 1?

It would be helpful to know what command is being issued to generate the error.


Report Offensive Follow Up For Removal

Response Number 3
Name: webmx04
Date: June 27, 2005 at 23:19:39 Pacific
Reply: (edit)

first thank you for your quick reply

2nd what script do you mean I really don`t know. Sorry Im really a newbie here please advice me what to do. I thought using phpdev5 was the best way for using php and mysql cause it comes in a bundle with all necessary components like apache

do you mean sql.php on phpmyadmin folder

yes I restarted it and it was set to start on startup


The Bold and the beautiful


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Mysql problems in creating a db 

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




Have you ever used OpenOffice?

Yes, as my main suite.
Yes, occationally.
Yes, but only once.
No, never.


View Results

Poll Finishes In 6 Days.
Discuss in The Lounge