Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titlecode sample
use bclys_grad_cs_1917;
CREATE USER 'test-user'@'%' IDENTIFIED BY 'test-user';
CREATE USER 'test-user'@'localhost' IDENTIFIED BY 'test-user';
GRANT USAGE ON *.* TO 'mysql.sys'@'localhost';
GRANT TRIGGER ON `sys`.* TO 'mysql.sys'@'localhost';
flush privileges;
GRANT ALL PRIVILEGES ON *.* TO 'test-user'@'localhost' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'test-user'@'localhost' WITH GRANT OPTION;
flush privileges;
GRANT ALL PRIVILEGES ON *.* TO 'test-user'@'%' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'test-user'@'%' WITH GRANT OPTION;
flush privileges;

As soon as I ran this script it all started working