> Halooo.....gimana seh cara ngasih permission akses ke database mySQL > dari user biasa ? > > #--------------------------------------------------------------------- > [EMAIL PROTECTED] etc]$ mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 24 to server version: 3.23.54 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> use bktamu; > ERROR 1044: Access denied for user: '@localhost' to database 'bktamu' > mysql> > #---------------------------------------------------------------------- > > thanx b4
++ coba connect ke mysql sebagai user, misalnya sbg root atau userid yg udah didaftarin di db mysql anda. prompt> mysql -uroot -p Enter password: trus pastikan user tsb punya hak utk akses ke database yg bernama bktamu tsb. punya akses 'root' di 'mysql user' gak ? kalo ada bisa pake perintah : prompt> mysql -uroot -p Enter password: mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bktamu.* TO [EMAIL PROTECTED] IDENTIFIED BY 'your-userid-password'; lebih lengkapnya coba baca manual mysql. salam, -rianu- -- Unsubscribe: kirim email kosong ke [EMAIL PROTECTED] Arsip, FAQ, dan info milis di http://linux.or.id/milis.php Tidak bisa posting? Baca: http://linux.or.id/wiki/index.php?pagename=ProblemMilisDanSolusi http://linux.or.id/wiki/index.php?pagename=TataTertibMilis