MYSQL in windows 98

durga

Friends,

I am very much new to MYSQL, PHP. Actually I happend to download helpdesk program from the web, in that installation it has specified to do the following:

[johnuser@somehost helpdesk]$mysql -u root -p < phphelpdesk.mysql
Enter password: (password is only required if you have a password set)

but I dont know where to implement this...and how to implement this..and I dont know what it means...So pls help me to solve this problem.....

Even a small help will be highly appreciated.

Thank you
Regards
Durga.

Anon

Sounds like it is an SQL statement to create a database in MySQL and populate some tables.

Assuming MySQL is installed and started (read the manual if not), open up a dos prompt window. CD \mysql\bin

then type the following command

mysql -u root -p < phphelpdesk.mysql

You'll either have to copy phphelpdesk.mysql into the bin directory or specify the full path.

Typing MySQL on its on will take you into the console. Here, you can enter loads of commands or SQL statements. i.e.

show databases;
use dbname;
show tables;

Just look at the manual for more info.

type exit when you're done.

Good Luck

Jon

Anon

Jon,

Thank you very much for the help...

I did exactly as what asked you to do... but when I enter the password it gives a error message telling that

"Cant connnect to mysql server on localhost"

I think some alteration has to be made in the local host part... but I dont where exactly to do the modification exactly....

So pls let me know how to solve this problem???

Regards
Durga

Anon

Have you started the MySQL Server. I recommend having 2 shortcuts on your desktop.

Startup MySQL, pointing to:
C:\mysql\bin\mysqld-opt.exe

and Shutdown MySQL, pointing to:
C:\mysql\bin\mysqladmin.exe -u root shutdown

Also, is there a password on the root user for MySQL. By default, after installation, there is no password. I don't bother if it is only a home development PC. So, if you leave password blank, you may get in.