MySQL User
Create a user
For local mysql access
1 2 3 |
CREATE USER 'USERNAME-HERE'@'localhost' IDENTIFIED BY 'PASSWORD_HERE'; GRANT ALL PRIVILEGES ON DB_NAME_HERE.* TO 'USERNAME-HERE'@'localhost'; FLUSH PRIVILEGES; |
To allow remote access, run
1 2 3 |
CREATE USER 'USERNAME-HERE'@'%' IDENTIFIED BY 'PASSWORD_HERE'; GRANT ALL PRIVILEGES ON DB_NAME_HERE.* TO 'USERNAME-HERE'@'%'; FLUSH PRIVILEGES; |
To allow a user to create another user
1 |
GRANT GRANT OPTION ON *.* TO 'USERNAME-HERE'@'localhost'; |
Now this user will be able to create new users.
Create a user with root privilages
1 2 |
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'MYSQL_PASSWORD' WITH GRANT OPTION; GRANT PROXY ON ''@'' TO 'admin'@'localhost' WITH GRANT OPTION; |
For MySQL 8
1 2 |
CREATE USER 'admin'@'%' IDENTIFIED BY 'AEs308SuEtT0Hs'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION; |