User Permissions Edit & Table Editing

[qstoodley]

Hello,

I have just bought the upgrade to the latest version of webyog and have experienced these problems on two totally different systems but both with the same versions. I am using version v 4.01 and MySQL 4.1.9-nt. Once of my PC's is XP Pro and the other Windows Sever 2003 Web Edition.

The problem I have experienced is when I change a user permission using Tools -> User Manager -> Edit User I then change the permissions for particular databases and tables and when I apply them and go back to look again the permission changes have not been made. I can create the user (but I gave them global privileges and these didn't stick on creation either).

I am also experiencing this issue when I try to change the structure of table. Go into a structure and change the datatype of a table and save and when I go back to look again the change has not taken place. I have not had this issue before.

I looked through the history and when I copy the command to apply the change in manually it seems to work.

I have attached a history log here.

Any help greatly appreciated.

Regards,

Quentin.

/*[10:46:35 AM][ 0 ms]*/ show databases

/*[10:46:48 AM][ 0 ms]*/ insert into mysql.user ( host, user, password, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, reload_priv, shutdown_priv, process_priv, file_priv, grant_priv, references_priv, index_priv, alter_priv ) values ( '%', 'test', PASSWORD('test'), 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y' )

/*[10:46:48 AM][ 0 ms]*/ flush privileges

/*[10:46:52 AM][ 0 ms]*/ select user, host from mysql.user

/*[10:46:52 AM][ 0 ms]*/ select * from mysql.user where user='root' and host ='%'

/*[10:46:55 AM][ 0 ms]*/ select * from mysql.user where user='test' and host ='%'

/*[10:46:58 AM][ 0 ms]*/ update mysql.user set user='test', host='%', select_priv='n', insert_priv='y', update_priv='n', delete_priv='n', create_priv='n', drop_priv='n', reload_priv='y', shutdown_priv='y', process_priv='n', file_priv='n', grant_priv='n', references_priv='n', index_priv='n', alter_priv='n' where user='test' and host='%'

/*[10:46:58 AM][ 0 ms]*/ flush privileges

/*[10:46:59 AM][ 0 ms]*/ select user, host from mysql.user

/*[10:46:59 AM][ 0 ms]*/ select * from mysql.user where user='root' and host ='%'

/*[10:46:59 AM][ 0 ms]*/ select * from mysql.user where user='test' and host ='%'

/*[10:47:01 AM][ 0 ms]*/ show databases

/*[10:47:04 AM][ 0 ms]*/ select user, host from mysql.user

/*[10:47:04 AM][ 0 ms]*/ select * from mysql.user where user='root' and host ='%'

/*[10:47:06 AM][ 0 ms]*/ select * from mysql.user where user='test' and host ='%'

/*[10:47:42 AM][ 0 ms]*/ update mysql.user set user='test', host='%', select_priv='n', insert_priv='y', update_priv='n', delete_priv='n', create_priv='n', drop_priv='n', reload_priv='y', shutdown_priv='y', process_priv='n', file_priv='n', grant_priv='n', references_priv='n', index_priv='n', alter_priv='n' where user='test' and host='%'

/*[10:47:42 AM][ 0 ms]*/ flush privileges

/*[10:47:48 AM][ 0 ms]*/ select user, host from mysql.user

/*[10:47:48 AM][ 0 ms]*/ select * from mysql.user where user='root' and host ='%'

/*[10:47:50 AM][ 0 ms]*/ select * from mysql.user where user='test' and host ='%'

[peterlaursen]

read this thread and try the 4.02 beta …

http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1156

[Author]

Posts