This one-liner shows how to create a new MySQL user, grant permissions and set the password:
GRANT ALL PRIVILEGES ON mydb.* To 'myuser'@'%' IDENTIFIED BY 'mypassword';
Then run:
FLUSH PRIVILEGES
And that’s it.
This one-liner shows how to create a new MySQL user, grant permissions and set the password:
GRANT ALL PRIVILEGES ON mydb.* To 'myuser'@'%' IDENTIFIED BY 'mypassword';
Then run:
FLUSH PRIVILEGES
And that’s it.
Like what you see?
Take our survey and help us provide content that works for you.
We don't collect any information other than what you explicitly tell us.