COLLINEAU Franck FTRD/DMI/TAM writes:
> I have read the manual. > > I don't understand because when i type: SELECT VERSION(), CURRENT_DATE; > it's OK, the server answer to me!! > > > > I have the error message: > > ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' If you've read the manual, why not do as it says? :-o Log in as the mysql root user, create the database and a user, and grant whatever privileges you need on that database to that user. Then use that user when connecting, instead of doing everything as root or ''. That you're able to SELECT VERSION() is not very strange. You're logged in as the anonymous (or nameless) user, and you don't need any privileges to SELECT without a FROM. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
