mysqladmin - MySQL new user PRIVILEGES not working -

i created user select/read data mysql can still drop tables database. wrong in sql script.

create user 'test'@'%' identified 'test!'; grant select on * . * 'test'@'%'; flush privileges;

you need connect database root.

mysql -u root -p

i notice proper command should be

grant select on *.* 'test'@'%';

meanwhile yours

grant select on * . * 'test'@'%';

that is, got many spaces (this dealbreaker).

then use test user

mysql -u test -p

and run update query.

you should receive error

command denied user

you try tell you're using:

grant select on databasename.viewname 'test'@'identifythehost';

My