WesleyA Posted October 14, 2015 Share Posted October 14, 2015 (edited) I have a question about security and MYSQL. I installed MYSQL and PHPMYADMIN. I changed the root password. But when in PHPMYADMIN I see a list of users and priviliges. Usernames sound like: All, root or pma. I understand I need pma or root, but what is the use of All ? User name Host Password Global privileges User group Grant Action Any % -- USAGE Any localhost No USAGE pma localhost Yes USAGE root 127.0.0.1 Yes ALL PRIVILEGES root ::1 Yes ALL PRIVILEGES root localhost Yes ALL PRIVILEGES Furthermore which priviliges and global rights should a user have when developing localhost? Edited October 14, 2015 by WesleyA Link to comment Share on other sites More sharing options...
justsomeguy Posted October 14, 2015 Share Posted October 14, 2015 The "any" user is not an actual account, it's used when someone connects without a username. If you're developing on a local test server you might as well have all privileges, or otherwise match the privileges to your target environment. Link to comment Share on other sites More sharing options...
WesleyA Posted October 14, 2015 Author Share Posted October 14, 2015 so "any" automatically lapses if you create a user with password? Or do I have to change more settings to keep unwanted people out? Link to comment Share on other sites More sharing options...
justsomeguy Posted October 14, 2015 Share Posted October 14, 2015 so "any" automatically lapses if you create a user with password?No, it represents the permissions for a user who connected without a username.Or do I have to change more settings to keep unwanted people out?If you refuse remote connections that's the best way to protect the server. The server should only allow remote connections unless you really need to be able to connect remotely, and if so then ideally you would set up users that only connect from a specific IP address.There's a discussion about the default account setup here:http://dba.stackexchange.com/questions/5620/is-this-a-normal-set-of-mysql-privileges Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now