Admin Functions WITHIN WAMP

[Maurice Stephens]

This is a Noob type question … and I am currently working with WAMP and **have NOT installed or configured MySQL/Apache on my own yet **

I’m trying to work through the tutorial in Chapter 3 of the MySQL Reference Manual which starts you working directly with the console and referencing Server Administration functions – priveldges, Grant, Revoke etc … The problem I’m having is that since my version MySQL is already configured within WAMP and accessed from thr Wamp System tray Menu … some of the commands that should be working aren’t. I’m talking like the simple …

mysql> SELECT VERSION(), CURRENT_DATE;

Which should spit out:

+----------------+--------------+
| VERSION() | CURRENT_DATE |
+----------------+--------------+
| 5.0….. | 2009-02-17 |
+----------------+--------------+
1 row in set (0.01 sec)

… or something like that … but instead I’m getting an Error 1064 … syntax problem …

So, I’m trying to figure out which aspects of WAMP’s MySQL config are preventing me from working with basic root/admin functions like those detailed in the Reference manual … This is something that is going to become important at some point I’m sure … and I’m really just trying to give myself a solid foundation to build upon troubleshooting wise …

Is my mistake that I'm working with WAMP to begin with ... and SHOULD learn to configure these things from teh beginning ... OR is there a happy medium somewhere where I can build some small business client dbs in WAMP and learn more global config settings as I get some experience ... Dying to know ...

Any comments or advice ??? … thx in advance … !



Edited 1 time(s). Last edit at 02/17/2009 02:42PM by Maurice Stephens.