mysql create user

Create a user For local mysql access 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 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 GRANT GRANT OPTION ON *.* … Read more