[horde] Error running mysql_create.sql
horde at martycombs.com
horde at martycombs.com
Thu May 30 22:17:26 PDT 2002
While testing a CVS checkout of horde on a RedHat 7.3 system, I kept
getting the following error while attempting to run the mysql_create.sql
script:
ERROR 1133 at line 52: Can't find any matching row in the user table
This was the line which attempted to grant privileges to
'horde at localhost'. Adding a "FLUSH PRIVILEGES;" after updating the user
and db tables resolved the problem. Below is a diff of the change.
Thought you might want to know.
marty :-)
----------------------------------------------------------------------
"They that can give up liberty to obtain a little temporary safety
deserve neither liberty nor safety." --Ben Franklin
Marty Combs
traveller, geek, cat freak
----------------------------------------------------------------------
Index: mysql_create.sql
===================================================================
RCS file: /repository/horde/scripts/db/mysql_create.sql,v
retrieving revision 1.4
diff -c -r1.4 mysql_create.sql
*** mysql_create.sql 25 Mar 2002 17:32:45 -0000 1.4
--- mysql_create.sql 31 May 2002 05:12:36 -0000
***************
*** 32,37 ****
--- 32,38 ----
'Y', 'Y', 'Y', 'Y',
'Y', 'Y'
);
+ FLUSH PRIVILEGES;
# MySQL 3.23.x appears to have "CREATE DATABASE IF NOT EXISTS" and
# "CREATE TABLE IF NOT EXISTS" which would be a nice way to handle
More information about the horde
mailing list