I need help please.

[Kursack]

I keep getting a syntax error code when following the windows server guide.
When i try to type in mysql-uroot-ppassword it tells me that the command is not reconized (inshell)

In MYSQL prompt

It says it is a Syntax error 1064 (42000) I have looked up this error and there is almost no information on a solution. I need help bad please.

[lerxst2112]

You need spaces between options.

mysql -uroot -ppassword

[Kursack]

ok cool that worked only problem i have no is it did not let me move on with the other options

[Kursack]

Ok here is the subject of my second problem In the tutorial the argument is
create
then database peq;

when i type that it says Create is not reconized as a internal or external command...

Any ideas?

[moofta]

just do:-
create database peq;

[Kursack]

ok i loaded the command mysql -uroot- p password however;

when i type in create database peq; it says that it is not reconized as an internal or external command, opererable program or batch file.

Please i need a little help. this is the last thing i need to do is to create this database.

[moofta]

It sounds like you haven't actually logged into MySql.

When you logged in with:
mysql -uroot -ppassword

Did it then print out "Welcome to MySQL monitor" (and a bunch of other stuff)? If it didn't, you're not logged in. Sounds like you missed out the step to add mysql to your PATH variable.

The last thing shown would look like:-
mysql>

So when you type in your command it would look like this:-
mysql> create database peq;

[Kursack]

Ok yea i think that is it. I installed it like the tutorial said. Is there a special way that i am missing?

[pfev1980]

I had the same issues. The way I fixed it was I used HeidiSQL. Open HeidiSQL, click on the session name, "Unknown", right click and then click on new --> Database. Then name it PEQ and source your files into. Your source files in Heidi by clicking on the query tab for PEQ and then right clicking in the open space beneath that and clicking on "Load script" or something like that...the only load option. Then select your script, and click on the blue arrow at the top to run it.