morfargekko
Verified User
- Joined
- Oct 21, 2007
- Messages
- 189
Hello, I am having big problems granting a special user privileges in mySQL.
I an issuieng the following command in mysql and I am getting errors.
=================================
mysql> GRANT CREATE ROUTINE ON database.* TO databaseuser@localhost IDENTIFIED BY 'secretpassword';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected, 1 warning (0.01 sec)
Error (Code 1146): Table 'mysql.procs_priv' doesn't exist
=================================
Can someone please help me.
I an issuieng the following command in mysql and I am getting errors.
=================================
mysql> GRANT CREATE ROUTINE ON database.* TO databaseuser@localhost IDENTIFIED BY 'secretpassword';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected, 1 warning (0.01 sec)
Error (Code 1146): Table 'mysql.procs_priv' doesn't exist
=================================
Can someone please help me.