Membuat database dan memberi grant privileges kepada user di MySQL

mysql

lanjut….. ini kasus yg sering saya alami krn kdg2 males pke phpmyadmin 😀

kasus: saya mau buat database di MySQL, dan user yg punya hak untuk pke+edit database tersebut
commandnya :

# mysql -u root -pPASSWDSQLROOTNYA

mysql > create database NAMADATABASENYA;

mysql> grant usage on *.* to [email protected] identified by ‘PASSUSERNYA’;

mysql> grant all privileges on NAMADATABASENYA.* to [email protected];

mysql> exit

mugi2 saget manfaat 🙂

Incoming search terms:

  • cara grant user di sql
work as freelancer - i’m a humanize human, a son, a father, a husband, who love coffee and cigarette, lazy and moody, entrepreneur, very easy to sleep, internet addict, bad designer, humorious, playing guitar, can’t singing & cooking, thin body, brown skin, smily, travelling & hiking, art & culture related, etc………

Leave a Reply

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

Top