[jonathan]

The new beta puts the correct database permissions into the mysql.db table, however there is still a problem with table level permissions and column level permissions

/*[15:56:09][ 0 ms]*/ insert into mysql.tables_priv (host, db, user, table_name, grantor, Table_priv ) values ( '%', 'test', 'jdw5', 'tab1', 'root@mysql0', 'select,insert,update' )

/*[15:56:09][ 0 ms]*/ insert into mysql.columns_priv (host, db, user, table_name, column_name, column_priv) values ( '%', 'test', 'jdw5', 'tab1', 'testtab', 'select,insert,update' )

Changing 'select,insert,update' to 'Select,Insert,Update' seems to do the job.

[jonathan]

Just tried sqlyog 4.02 beta with mysql 4.1.9 (on redhat). I can now set global permissions successfully, but still cannot set specific database, table or column permissions using the Manage Permissions screen.

[Author]

Posts