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>
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>