Skip navigation links

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


Advanced Search

Re: mysql error #1064 with latest wamp install
Posted by: steph mc ()
Date: June 14, 2012 08:43PM

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?

Options: ReplyQuote


Subject Written By Posted
mysql error #1064 with latest wamp install steph mc 06/14/2012 07:21AM
Re: mysql error #1064 with latest wamp install Barry Galbraith 06/14/2012 05:28PM
Re: mysql error #1064 with latest wamp install steph mc 06/14/2012 08:43PM
Re: mysql error #1064 with latest wamp install steph mc 06/14/2012 08:58PM
Re: mysql error #1064 with latest wamp install Barry Galbraith 06/14/2012 09:33PM
Re: mysql error #1064 with latest wamp install steph mc 06/15/2012 12:09AM
Re: mysql error #1064 with latest wamp install Barry Galbraith 06/15/2012 05:01AM
Re: mysql error #1064 with latest wamp install Leo Agustinus 06/19/2012 11:45AM
Re: mysql error #1064 with latest wamp install Peter Garcia-Webb 06/23/2012 08:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.