Create MySQL Admin user

If you want to create a MySQL admin user that can connect from anywhere, feel free to tweak the string below:

#create SQL Admin user
CREATE USER ‘clusterAdmin’@’%’ IDENTIFIED BY ‘YOUR_cool_password_here’;
GRANT ALL PRIVILEGES ON *.* TO ‘clusterAdmin’@’%’;
FLUSH PRIVILEGES;

If you want to limit connections to localhost, switch the “%” to “localhost”

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge