Hi Guys:

I just downloaded mysql version mysql-4.0.17. I am using a book MySql and perl for the web. At present I have two problems.



1) I tried some code from the book to configure MySql

% mysql -h localhost -p -u root

GRANT ALL ON webdb.* TO webdv@localhost IDENTIFIED BY

"webdvpass"; Below is a copy of the error received.

msql> % mysql -h localhost -p -u root
-> GRANT ALL ON webdb.* TO webdv@localhost IDENTIFIED BY

"webdvpass";


ERROR 1064: You have an error in your SQL syntax. Check the

manual that corresponds to your MySQL server version for the

right syntax to use near '% mysql -h localhost -p -u root


GRANT ALL ON webdb.* TO webdv@l
mysql>

Where can I find a manuel for mysql-4.0.17?

What is the problem?



2)

I've looked at information on starting mysql for the first time on line.

Starting for the first time required runnning mysqld --console.

Below is a copy of the error message received.




C:\mysql\bin>mysqld --console
Can't start server: Bind on TCP/IP port: No error
031221 6:10:29 Do you already have another mysqld server running on port: 3306
?
031221 6:10:29 Aborting

031221 6:10:29 mysqld: Shutdown Complete


C:\mysql\bin>
C:\mysql\bin>C:\mysql\bin>mysqld --console
'C:\mysql\bin' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin>Can't start server: Bind on TCP/IP port: No error
'Can't' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin>031221 6:10:29 Do you already have another mysqld server running
on port: 3306
'031221' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin> ?
'?' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin>031221 6:10:29 Aborting
'031221' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin>
C:\mysql\bin>031221 6:10:29 mysqld: Shutdown Complete
'031221' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin>
C:\mysql\bin>
C:\mysql\bin>C:\mysql\bin>cls
'C:\mysql\bin' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql\bin>cd..

C:\mysql>mysqld --console
'mysqld' is not recognized as an internal or external command,
operable program or batch file.

C:\mysql>dir mysqld
Volume in drive C has no label.
Volume Serial Number is 089A-F55F

Directory of C:\mysql

File Not Found

C:\mysql>cd\bin
The system cannot find the path specified.

C:\mysql>cd bin

C:\mysql\bin>mysqld --console
Can't start server: Bind on TCP/IP port: No error
031221 6:32:33 Do you already have another mysqld server running on port: 3306
?
031221 6:32:33 Aborting

031221 6:32:33 mysqld: Shutdown Complete


C:\mysql\bin>

Any suggestions?



Thanks,

Dave





















C:\mysql\bin>mysqld --console
Can't start server: Bind on TCP/IP port: No error
031221 6:10:29 Do you already have another mysqld server running on port: 3306
?
031221 6:10:29 Aborting

031221 6:10:29 mysqld: Shutdown Complete


C:\mysql\bin>

Hi,

You can find the manual at:

http://www.mysql.com/doc/

Your problem is you need to type in only the SQL:

GRANT ALL ON webdb.* TO webdv@localhost IDENTIFIED BY "webdvpass";

The line:

mysql -h localhost -p -u root

is used to connect to mysql, not an actual query.

Cheers,

Alex
--
Gossamer Threads Inc.