MySQL: Buat User dan Database

From Catatan IBM
Revision as of 21:34, 19 June 2023 by Ibm (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 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

exit;