Root MySQL
 

So when it comes down to Linux in general I know it's not safe to use root for anything unless you have too. So my question is because I don't see how it will work in the same way (Like MySQL I don't see you being like oh well only if you can't do this do this instead) in MySQL. So should i use root in MySQL cause I know alot of programs they need one user and I'm worried if I make a normal user if i don't have access to something I can't do what i need I'm just beginning MySQL and all I need it for is for my forum to interact with phpBB and some other things later on when I get it all setup. Is there anything you can teach me about my situation here or work arounds or anything. Mainly is it safe to use root in mysql accounts or no? how can i make sure that if i'm not using root that if only root has access i can still do it safely.

The privilege model on MySQL is really very simple and straight forward. every application should have its own user account, which may well have full access to create and delete data but not in other databases or other non-db related code. Only quirk (as I see it) is that you grant privileges to the high level commands, e.g. CREATE, DROP etc. So you can't actually create a user who can create a table in their own database who can't create a new database too, same for a drop - if you an drop a table, you can drop the db too...