Revision history of "Mysql: Create, Import, Export"

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 10:28, 1 June 2022‎ Ibm talk contribs‎ 846 bytes +846‎ Created page with "==Ubuntu 22.04== ===Create Database=== Login Mysql sudo mysql atau mysql -u root -p CREATE DATABASE nama_db DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; CREATE USER 'nama_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password'; GRANT ALL ON nama_db.* TO 'nama_user'@'%'; FLUSH PRIVILEGES; EXIT; ===Import Database=== mysql -u nama_user -p nama_db < file_db.sql ===Export Database=== mysqldump -u nama_user -p nama_db > nama_file_db.sql Ke..."