boo_lolly Posted March 10, 2008 Share Posted March 10, 2008 so it's been a while since i've messed with mysql. apparently so long that i've forgotten how to even start mysql =P. so i ended up re-installing it on my linux machine (local host test server), and can run it just fine. i already have a mysql user on my linux machine, and a mysql group. now how do i add users to the mysql server? they don't even need to be users on my linux machine right? also, when i'm in the mysql command prompt, and i create a database, how can i add a user to that database? how do i grant all permissions to that user ONLY for that specific database? how do i make sure mysql server starts automatically when i boot my machine? i'm hoping for a little insight here guys hahah =) thanks in advanced. Quote Link to comment https://forums.phpfreaks.com/topic/95336-adding-linux-usersmysql-users-granting-all-priviledges-per-database/ Share on other sites More sharing options...
mwasif Posted March 30, 2008 Share Posted March 30, 2008 now how do i add users to the mysql server? they don't even need to be users on my linux machine right? Use GRANT statement to give rights. Right. Quote Link to comment https://forums.phpfreaks.com/topic/95336-adding-linux-usersmysql-users-granting-all-priviledges-per-database/#findComment-504956 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.