MySQL Forums :: Install :: mysql error #1064 with latest wamp install

Hi Barry,

thank-you so much for your reply, and your assistance. As i spent 6 hours straight trying to fix the problem yesterday, iv had a sleep, and ready to give it another try.

Start | Run "services.msc"
Is MySQL listed? Is it running?

**** I did this, and listed in services is wampmysql, which im guessing is the same as mysql? and yes this service is running.

If it's running, can you login with mysql command line client?
Open a command line (a.k.a. a DOS prompt).
CD to the folder MySQL is installed into. The MySQL standard is C:\Program Files\MySQL\MySQL Server 5.x\bin.
It could be differnt on your machine, you'll need to find it.

**** I found the files location, however, does it need to be a "bin" file? as im able to open an exe file located at C:\wamp\bin\mysql\mysql5.5.20\bin\mysql.exe - and upon opening I see a DOS like command statement box (black box, white text) which says

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection is 1
Server Version:5.5.20-log MySQL community server

(the the oracle copyright information is here)

type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW DATABASES;
+--------------------------+
Database
+---------------------------+
information_schema
test
+----------------------------+
2 rows in set <0.00sec>






so this is what iv found, but im a little unsure of what this tells me. does this mean i have to create the database with commands, rather than simply using the phpmyadmin?