I am creating a simple webpage that requires me to make users for everyone who needs to login. And they have there own small database that they have god rights to, but nothign else.
Everything works perfectly besides they have no rights to anything. I create the user and they are blank (i create it by editing the mysql db which I know isn't the prefered method.)
It had to be done with PHP so it's via command line.
It has to be something like this right?:
GRANT ALL PRIVILEGES ON SCHEMA andy TO andy@%"
I've done other variations to get syntax correct. Nothing works in Query Browser or via PHP, which is similar.