Revision history of "MySQL: Buat User dan Database"

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

  • curprev 21:34, 19 June 2023‎ Ibm talk contribs‎ 674 bytes +674‎ Created page with "==Ubuntu 20.04== Masuk ke MySQL sudo mysql atau mysql -u root -p buat database CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; Buat User CREATE USER 'db_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; Grant GRANT ALL ON db_name.* TO 'db_user'@'%'; Flush FLUSH PRIVILEGES; exit; ==Ubuntu 22.04== Masuk ke MySQL sudo mysql atau mysql -u root -p Buat database CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLL..."