GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
What syntax error is it whinging about?
All these attempts generate syntax errors....
GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint@localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON '.' TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON '*' TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON * TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON % TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON 'find_a_tradie' TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
So how do you do this?
This would be so much easier with a proper GUI that hides all the vaguieries of these differences in syntax used by different setups.
This is the problem I am trying to solve:
What syntax error is it whinging about?
All these attempts generate syntax errors....
GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON . TO 'debian-sys-maint@localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON '.' TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON '*' TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON * TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON % TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
GRANT ALL PRIVILEGES ON 'find_a_tradie' TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'wCN5zhYx5R6004zg';
So how do you do this?
This would be so much easier with a proper GUI that hides all the vaguieries of these differences in syntax used by different setups.
This is the problem I am trying to solve:
Last edited: