How To Create a New User and Grant Permissions in MySQL

Published: 20 August 2014
on channel: NixInPix

9,393

MySQL the world's second most widely used open-source relational database management system. This tutorial will show you how to make new user and how to give permissions.
If you have any questions please ask in comment.

Commands:
sudo mysql -u root -p
CREATE USER 'testuser'@'localhost' IDENTIFIED BY '12345';
GRANT ALL PRIVILEGES ON * . * TO 'testuser'@'localhost';
FLUSH PRIVILEGES;
quit
sudo service mysql restart
mysql -u testuser -p
You can always Deploy an SSD cloud server in 55 seconds
with Digitalocean.
Anyone how use this link will receive $10 in hosting credit immediately after unlocking their account by adding a valid payment method.
Sign Up with this link
https://www.digitalocean.com/?refcode...
(affiliate, referral)

Watch video How To Create a New User and Grant Permissions in MySQL online, duration hours minute second in high quality that is uploaded to the channel NixInPix 20 August 2014. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 9,393 times and liked it 23 visitors.

653