Topic: Mysql grant not working after upgrade

[Damian]

SME 6.0 and upgraded to mysql 4.0.21-standard.

All SME functions are working but after creating a new table I'm unable to grant user access to the table. It looks like the "mysql_fix_privilege_tables" issue but I've run that a few times and it doesn't make a difference.

Still have:

mysql> grant all on netjuke.* to netjuke@localhost identified by 'XXX';
Query OK, 0 rows affected (0.00 sec)

Anyone any further ideas ?

Damian

[Damian]

Seems I've fixed it myself.

It appears that with mysql 4.02 you need to "use" the databse you want to change user access to before running the grant command. As in:

use netjuke;
 grant all on *.* to netjuke@localhost identified by 'XXX';

Ho Hum. Could do with verifying this though.

Damian