exactly. mysqladmin -V mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
this and every other command in mysqladmin work except for create and drop. dunno why. I'd like to get on to building databases instead of permissions over and over. I ssh into the box. User/pass are saved in /root/.my.cnf and work ok. Mysql -> use mysql -> select * from user; shows root@localhost all Ys, root@ip all Ys, root@hostname all Ys, root@myworkstaionip all Ys. Command for user access was: grant all privileges on *.* to root@localhost etc Identified by 'mymysqlrootpassword' with grant option; mysqlaccess root localhost etc show user root host localhost all Ys. /etc/hosts shows 127.x localhost hostname, ip hostname, etc server running as safe_mysqld --skip-all-options-i-found-listed-on-the-man-pages. But it still fails. Please advise, i'll try the lamest suggestion at this point. Thanks, Justin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benjamin Pflugmann Sent: Thursday, May 30, 2002 4:52 PM To: [EMAIL PROTECTED] Cc: 'Myk Melez'; 'mysql' Subject: Re: what causes this error Hi. This works fine for me. What is the output of mysqladmin -V mysqladmin version ? Bye, Benjamin. On Thu, May 30, 2002 at 03:09:11PM -0700, [EMAIL PROTECTED] wrote: > mysqladmin create test2 > mysqladmin: CREATE DATABASE failed; error: 'You have an error in your > SQL syntax near '`test2`' at line 1' -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
