Linux - SecurityThis forum is for all security related questions.
Questions, tips, system compromises, firewalls, etc. are all included here.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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...
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.