hey, Could you tell me someone please why this simple setup wont work! I am using SuSE9.3 and trying to set this up:
$ mysql -uroot -e"insert into user(Host,User,Password) values('localhost','guestbook',password('guestbook')" mysql -p this is the error: $ ERROR 1064 (42000) at line 1: 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 '' at line 1 could someone please shed some light on this, Maybe the answer is so obvious I cant see it? Thankyou very much Ben :') -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]