GRANT @ MySQL

Huaa…! saya tidak bisa mengubah privileges database mysql dari mesin lain! Padahal seluruh privileges sudah saya berikan dengan command:
GRANT ALL PRIVILEGES ON *.* TO ‘my_account’@’%’ IDENTIFIED BY ‘password_account’;
Tapi tetep saja dari mesin lain tak bisa mengubah privileges. Ada yang kurang? Ternyata iya. Mestinya seperti ini:
GRANT ALL PRIVILEGES ON *.* TO ‘my_account’@’%’ IDENTIFIED BY ‘password_account’ WITH GRANT OPTION;

Leave a Comment

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

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

Scroll to Top