RE: IMPORTING

2004-07-26 Thread John R. Porter
Do you mean SQLYog? If so, this is a MySQL GUI - Info. at: http://www.webyog.com/sqlyog/index.php John R. Porter I.T. Services University of Strathclyde Faculty of Education 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTECTED] Tel. 0141 950 3289 -Original Message- From: Robert J

RE: Problem with GRANT...WITH GRANT OPTION

2004-07-21 Thread John R. Porter
Y' Do I have to set 'Grant_Priv' to 'Y' for 'demouser' in the 'user' table? Doesn't that give the user global GRANT privileges, rather than restricting them to the single database 'test'? Or do I have to give the user Read/Write privs. to the gra

Problem with GRANT...WITH GRANT OPTION

2004-07-21 Thread John R. Porter
oes 'demouser' have to be explicitly GRANTed access to the MySQL grant tables (user, db, host, tables_priv and columns_priv) before the user can be GRANTed GRANT privileges to any database or table? If so, what are the minimum privileges required? John R. Porter I.T. Services Univer

MySQL Installation Problem

2003-01-07 Thread John R. Porter
UP.EXE (or one of its components)' etc. I currently have version 3.23.49-nt installed. There were no problems installing it. Can anyone suggest what might be wrong? John R. Porter I.T.Services University of Strathclyde Jordanhill Campus 76 Southbrae Drive Glasgow G13 1PP e-mail: [EMAIL PROTE