MYSQL Database Wizard Software 2

[zoeythecat]

Hi All,

I have installed MYSQL5.1 on a Windows2003 Server. I've been trying to find some Wizard Software that would help make my life easier creating a database (I'm not very familiar with the command line way of doing things). Does anyone know of any MYSQL Database Wizard software out there that would help me out with MYSQL?

Thanks in advance!

 

[petrosky]

Hey zoeythecat,

Here are the best ones for your review (IMO).

MYSQL - Administrator

http://dev.mysql.com/downloads/gui-tools/5.0.html

SQLYOG

http://www.webyog.com/en/downloads.php

phpMyadmin -

Normally comes bundled with LAMP or WAMP downloads.

Good luck!

Peter.


Remember- It's nice to be important,
but it's important to be nice

 

[zoeythecat]

Peter,

Thanks for the reply. I have installed the MYSQL Gui tools, but I don't see how you can create a new database from within the gui. I see how you can do different things and manage the MYSQL, but could you offer any suggestions on how to create a new database using this gui?

Thanks

 

[ingresman]

it would be easier to byte the bullet and do some typing !
Start up a query browser such as mysql query browser (assume your ok with this tool ) and type create database name (where name is the database you want to create) and click the execute button and it'll do it - quck easy and painless.
Are you ok creating tables ?

 

[zoeythecat]

Ingresman,

Thanks for the reply. What we are doing is creating a web page using IIS6 for some forums software which requires MYSQL. I'm not if I need to creat the tables. The documentation just notes creating the database and then running an install.php file that will hopefully do the rest.

I didn't think on running the query browser. I'll try this.

Thanks a lot for the quick reply. I'll post back if I have any more questions or problems.

 

[zoeythecat]

Do you know what the default schema would be?

 

[ingresman]

user or database ?

 

[zoeythecat]

When I open the MYSQL Query Browser, I enter the root username and password, then the next field is the Default Schema. I assume its looking for a database?

 

[zoeythecat]

Disregard...I entered "MYSQL" as the schema. Now i'm trying to execute the command: create database (For database I just gave it the name of the database i'm creating) but I get an error: "You have an error in your SQL syntax". Error#64.

Any thoughts on this error?

Thanks

 

[johnwm]

You may do better with MySQL questions in forum436

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[ingresman]

cut and paste your create command here.

 

[zoeythecat]

I think i'm good now.

thanks for the help.

 

[zoeythecat]

Ingresman,

One last question. This is a PHP question. The software we installed requires PHP. I downloaded a zipped file that contains a bunch of files. The web files/folders (I.E d:\example)that IIS will be using is located in a folder on the D drive. Do I just uncompress the files from the PHP zip file to the d:\example folder? Is there any gotchas related to the PHP files?

Sorry for the dumb questions..I'm a beginner with MYSQL and PHP.

 

[ingresman]

No you have to actualy install php in a way that IIS will see it, e.g. where php binaries reside .php extnetion assiocation etc. If you go to the PHP site there's advice to get installed. The download page is at

http://www.php.net/downloads.php.

I think it prompts you to name the web server (e.g. IIS or Apache etc).
If you can't get it to work post a a question in the PHP forum or search here or do a google for it.
As for gotachs I recall there is something about cgi.force_redirect needing setting (or unsetting) in php.ini but the installer should take car of it for you.
Good luck !

 

[zoeythecat]

Ingresman,

Thanks for all your suggestions. I have it up and running.

 

[ingresman]

good glad to help