how do i grant permissions to my mysql db?
Posted on 2008-06-10
ok, i just created an app and db on my local system. we are now using linux os. I have moved the code to the server, created the db and now I need to add the tables and data which are all located in an .sql files. after creating the db i did this:
grant all privileges on compx to compx identified by 'compx20';
grant all privileges on compx to compx@localhost identified by 'compx20';
update mysql.user set password=OLD_PASSWORD('compx20') where user='compx ';
i load my .sql file and get 1044-access denied for user 'compx@% to database mysql. I am using mysql qui (navicat) and i know locally, i had to go to manage users and select everything, edit, create, etc and save it. I thought all the granting above would take care of that. Now I am wondering if I have to somehow grant edit, create, delete, etc for the db that is on the linux server.
any help would be appreciated.