Facebook
TwitterHello,
I need a MySQL user that has the privileges to add routines and triggers. The default users that are created by Plesk do not have these rights. How would I be able to add these rights to a specific user, or all users, that doesn't care.
I already logged in over SSH as a root user:
Then I tried to update the rights of the users:
This didn't work. So I wanted to add super privileges by doing this:
But also not of any effect. What's left to do?
I need a MySQL user that has the privileges to add routines and triggers. The default users that are created by Plesk do not have these rights. How would I be able to add these rights to a specific user, or all users, that doesn't care.
I already logged in over SSH as a root user:
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow`Then I tried to update the rights of the users:
Code:
mysql >UPDATE db SET Create_view_priv = 'Y', Show_view_priv = 'Y', Create_routine_priv = 'Y', Alter_routine_priv = 'Y';
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Code:
mysql> GRANT SUPER ON *.* TO 'user'@'%' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
Last edited:
