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.
Related posts:
- Reset MySQL Root Password Very often, once we didn’t log on to MySQL database...
- How to Create User with useradd in FreeBSD You can invoke “adduser” command in FreeBSD in order to...
- MySQL Quick Installation on FreeBSD Quick installation of MySQL Database on FreeBSD Server. Make sure...
- Change or Set User Password in FreeBSD If you notice, during FreeBSD installation, it doesn’t have a...
- installing postgresql 8.2 on Leopard with macports postgresql! one of my favorite high performance open source db,...
- MySQL 5 Server Cannot Start on Apple Mac Leopard There were some problem during configuring MySQL5 Server on Leopard...
- Forget / forgot / cannot remember root password On a FreeBSD server 1. reboot server 2. choose to...
- How to Change MySQL Data Directory in Linux Centos By default Linux CentOS or other Linux Distro installation, MySQL...
- bash – dealing with backtics ” ` ” in mysql statement problem : using backticks in bash for mysql statements. e.g....
- MySQL Cannot Connect with PHP in OSX I think some of you might have problem connecting to...
Tags: database, mysql, password, privileges, user
