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> create user on *.* to ‘NAMAUSER’@’localhost’ identified by ‘PASSUSERNYA’;

mysql> grant all privileges on NAMADATABASENYA.* to ‘NAMAUSERNYA’@’localhost’;

mysql> exit

mugi2 saget manfaat 🙂

work as freelancer, web developer, tourism support, organizer, etc - 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………

Tinggalkan Balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

This site uses Akismet to reduce spam. Learn how your comment data is processed.