mysql-error-1044

Lock out of mysql db thru webmin!

[root@cp ~]# mysql> CREATE DATABASE foo; [root@cp ~]# mysql> GRANT ALL ON foo.* TO root@'my home ip' IDENTIFIED BY 'aron1252'; [root@cp ~]# mysql> update user set Host='my home ip' where user='webadmin'; [root@cp ~]# GRANT ALL ON foo.* TO root@'localhost' IDENTIFIED BY 'newpass'; -bash: GRANT: command not found [root@cp ~]# mysql> GRANT...

MySQL permissions -- can't create functions even with the 'CREATE ROUTINE' grant

When connecting to my server (from a different machine) I get Error Code: 1044 Access denied for user 'username'@'%' to database 'dbname' when I try to create a function. But when I look at my permissions SHOW GRANTS FOR CURRENT_USER; I get 'GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFER...