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?