Re: How to grant all access to my SQL user

[hossam hassan]

okay after u type mysql -h localhost -u username -ppassword ur now in the mysql

type use mysql it will tell u database have been changed

type describe user:

thats the users mysql table u can insert the users in u will find hell lots of privileges for the user for example u want that user just to be able to select

INSERT INTO user(Host,User,Password,Select_priv) VALUES('%','anyname',password('secret'),('Y')):

if u want the user able to insert or any stuff just add grant_priv and in the values Y for sure just same like select

then type FLUSH PRIVILEGES;

now the user is present but have no privileges on any databse to grant for that user any thing u want also

GRANT ALL ON databsename.* TO anyname:

then flush privileges again

remeber that even u grant all the privileges to that user on the database he still just can select

feel free to ask

hossam