[Digikam-devel] [Bug 262321] mysql user privileges

[Alexander Stein]

https://bugs.kde.org/show_bug.cgi?id=262321


Alexander Stein <alexander.stein at informatik.tu-chemnitz.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |alexander.stein at informatik.
                   |                            |tu-chemnitz.de




--- Comment #10 from Alexander Stein <alexander stein informatik tu-chemnitz de>  2011-08-06 15:47:29 ---
(In reply to comment #9)
> It should work with privileges only on the database, try a "FLUSH PRIVILEGES;"
> command.
> 
> [MySQL privileges]

Are these your actual privileges digikam runs without problems?
I have the following privileges, but I still do get the error message.

mysql> SELECT * FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE LIKE
'%alex%';
+------------+---------------+----------------+--------------+
| GRANTEE    | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+------------+---------------+----------------+--------------+
| 'alex'@'%' | NULL          | USAGE          | NO           |
+------------+---------------+----------------+--------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES WHERE GRANTEE LIKE
'%alex%' AND TABLE_SCHEMA LIKE 'digikam';
+------------+---------------+--------------+-------------------------+--------------+
| GRANTEE    | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE          |
IS_GRANTABLE |
+------------+---------------+--------------+-------------------------+--------------+
| 'alex'@'%' | NULL          | digikam      | SELECT                  | YES    
     |
| 'alex'@'%' | NULL          | digikam      | INSERT                  | YES    
     |
| 'alex'@'%' | NULL          | digikam      | UPDATE                  | YES    
     |
| 'alex'@'%' | NULL          | digikam      | DELETE                  | YES    
     |
| 'alex'@'%' | NULL          | digikam      | CREATE                  | YES    
     |
| 'alex'@'%' | NULL          | digikam      | DROP                    | YES    
     |
| 'alex'@'%' | NULL          | digikam      | REFERENCES              | YES    
     |
| 'alex'@'%' | NULL          | digikam      | INDEX                   | YES    
     |
| 'alex'@'%' | NULL          | digikam      | ALTER                   | YES    
     |
| 'alex'@'%' | NULL          | digikam      | CREATE TEMPORARY TABLES | YES    
     |
| 'alex'@'%' | NULL          | digikam      | LOCK TABLES             | YES    
     |
| 'alex'@'%' | NULL          | digikam      | EXECUTE                 | YES    
     |
| 'alex'@'%' | NULL          | digikam      | CREATE VIEW             | YES    
     |
| 'alex'@'%' | NULL          | digikam      | SHOW VIEW               | YES    
     |
| 'alex'@'%' | NULL          | digikam      | CREATE ROUTINE          | YES    
     |
| 'alex'@'%' | NULL          | digikam      | ALTER ROUTINE           | YES    
     |
| 'alex'@'%' | NULL          | digikam      | EVENT                   | YES    
     |
| 'alex'@'%' | NULL          | digikam      | TRIGGER                 | YES    
     |
+------------+---------------+--------------+-------------------------+--------------+
18 rows in set (0.00 sec)

Note: This is digikam 2.0.0

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.