I'm try to set up a new user with select, update, insert, delete privileges. Even after mysqladmin flush-privileges and mysqladmin reload, the privileges do not work. I have even restarted the mysql service. Here is what I did:
grant select, update, insert, delete on db.table to user identified by 'password';
I then opened a command prompt and typed c:\mysql\bin\mysqladmin flush-privileges
Still, the account does not work. What do I do? I have done this once before, but I cannot remember how I did it.
BTW, this is a win 2k server box.
grant select, update, insert, delete on db.table to user identified by 'password';
I then opened a command prompt and typed c:\mysql\bin\mysqladmin flush-privileges
Still, the account does not work. What do I do? I have done this once before, but I cannot remember how I did it.
BTW, this is a win 2k server box.