From d8af5e6d199e6b89f944aee1a59ccc3b9a230815 Mon Sep 17 00:00:00 2001 From: Sanjay Dalal Date: Thu, 13 Aug 2009 17:06:03 +0000 Subject: [PATCH] NOJIRA fixed sql to fix the following error. ERROR 1133 (42000): Can't find any matching row in the user table +-------+------+-----------------------------------------------+ | Level | Code | Message | +-------+------+-----------------------------------------------+ | Error | 1133 | Can't find any matching row in the user table | +-------+------+-----------------------------------------------+ M src/main/resources/db/mysql/create_id_generators_table.sql --- .../src/main/resources/db/mysql/create_id_generators_table.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/services/id/service/src/main/resources/db/mysql/create_id_generators_table.sql b/services/id/service/src/main/resources/db/mysql/create_id_generators_table.sql index acf429587..e1fb321ad 100644 --- a/services/id/service/src/main/resources/db/mysql/create_id_generators_table.sql +++ b/services/id/service/src/main/resources/db/mysql/create_id_generators_table.sql @@ -42,6 +42,7 @@ CREATE TABLE `id_generators` ( GRANT SELECT, INSERT, UPDATE, DELETE on `id_generators` - to `test`; + to `test`@'localhost' IDENTIFIED BY 'test' WITH GRANT OPTION; +FLUSH PRIVILEGES; SHOW WARNINGS; -- 2.47.3