Create Root Privilege User on MySQL
By default, MySQL root privileges user is “root”, I always remove “root” userid once I got MySQL installed, mainly for security purpose, secondly I do not want stupid thing happened like someone able to brute force into MySQL database.
You can create “root” alike privilege user in MySQL by following the step below;
- Access to mysql /usr/local/bin/mysql
- mysql> GRANT ALL PRIVILEGES ON *.* TO ‘yourusername’@’localhost’ IDENTIFIED BY ‘yourpasswordhere’ WITH GRANT OPTION;
- mysql> flush privileges;
- mysql> quit;
You can add a few more privileges user if you have more than 1 person to admin MySQL Database.