Hi Michael; I took once moe a sharp look now that you did a reply with another sample. Actually I was wrong the SQL statement was NOT correct - you forgot the semicolon in the first exapmple ;-)
....'Y', 'Y', 'Y');\"" Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 09:38、Michael Iatauro さんは書きました: > Thanks for your reply, Nils. > > > and then I would like you to take a sharp look at whats left, then there > > should perhaps be something with this part above. Perhaps the " at the > > very end is not escaped correctly (double) or something similar. The > > actual SQL statement works perfectly fine. > > I thought that, too, but there seems to be no difference between the two > statements on Linux and Solaris. Mucking about with commands, however, > the following: > > eval "/path/to/mysql --user=root --password=****** > --socket=/path/to/sock --database=mysql --execute=\"grant all on > PlanWorks.* to 'LocalUser' identified by '******';\"" > eval "/path/to/mysql --user=root --password=****** > --socket=/path/to/sock --database=mysql --execute=\"grant alter , delete > , drop , file , index , insert , select , shutdown , update on *.* to > 'LocalUser';\"" > > works on Linux but not Solaris. I'd like not to introduce the > complexity of checking for the operating system type and executing a > different set of commands. Does anybody know how I can avoid that? -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
