<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.ibm.my.id/index.php?action=history&amp;feed=atom&amp;title=Mysql%3A_Create%2C_Import%2C_Export</id>
	<title>Mysql: Create, Import, Export - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.ibm.my.id/index.php?action=history&amp;feed=atom&amp;title=Mysql%3A_Create%2C_Import%2C_Export"/>
	<link rel="alternate" type="text/html" href="https://wiki.ibm.my.id/index.php?title=Mysql:_Create,_Import,_Export&amp;action=history"/>
	<updated>2026-11-16T16:55:54Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.37.1</generator>
	<entry>
		<id>https://wiki.ibm.my.id/index.php?title=Mysql:_Create,_Import,_Export&amp;diff=116&amp;oldid=prev</id>
		<title>Ibm: Created page with &quot;==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 &#039;nama_user&#039;@&#039;%&#039; IDENTIFIED WITH mysql_native_password BY &#039;password&#039;;   GRANT ALL ON nama_db.* TO &#039;nama_user&#039;@&#039;%&#039;;   FLUSH PRIVILEGES;   EXIT;   ===Import Database===   mysql -u nama_user -p nama_db &lt; file_db.sql   ===Export Database===   mysqldump -u nama_user -p nama_db &gt; nama_file_db.sql   Ke...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.ibm.my.id/index.php?title=Mysql:_Create,_Import,_Export&amp;diff=116&amp;oldid=prev"/>
		<updated>2022-06-01T03:28:13Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;==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 &amp;#039;nama_user&amp;#039;@&amp;#039;%&amp;#039; IDENTIFIED WITH mysql_native_password BY &amp;#039;password&amp;#039;;   GRANT ALL ON nama_db.* TO &amp;#039;nama_user&amp;#039;@&amp;#039;%&amp;#039;;   FLUSH PRIVILEGES;   EXIT;   ===Import Database===   mysql -u nama_user -p nama_db &amp;lt; file_db.sql   ===Export Database===   mysqldump -u nama_user -p nama_db &amp;gt; nama_file_db.sql   Ke...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==Ubuntu 22.04==&lt;br /&gt;
&lt;br /&gt;
===Create Database===&lt;br /&gt;
&lt;br /&gt;
Login Mysql&lt;br /&gt;
 sudo mysql&lt;br /&gt;
atau&lt;br /&gt;
 mysql -u root -p&lt;br /&gt;
&lt;br /&gt;
 CREATE DATABASE nama_db DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;&lt;br /&gt;
&lt;br /&gt;
 CREATE USER &amp;#039;nama_user&amp;#039;@&amp;#039;%&amp;#039; IDENTIFIED WITH mysql_native_password BY &amp;#039;password&amp;#039;;&lt;br /&gt;
&lt;br /&gt;
 GRANT ALL ON nama_db.* TO &amp;#039;nama_user&amp;#039;@&amp;#039;%&amp;#039;;&lt;br /&gt;
&lt;br /&gt;
 FLUSH PRIVILEGES;&lt;br /&gt;
&lt;br /&gt;
 EXIT;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Import Database===&lt;br /&gt;
&lt;br /&gt;
 mysql -u nama_user -p nama_db &amp;lt; file_db.sql&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Export Database===&lt;br /&gt;
&lt;br /&gt;
 mysqldump -u nama_user -p nama_db &amp;gt; nama_file_db.sql&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Keterangan:&lt;br /&gt;
&lt;br /&gt;
Cara mudahnya:&lt;br /&gt;
&lt;br /&gt;
Coba perhatikan command &amp;gt; (pada export MySQL) dan command &amp;lt; (pada import MySQL). Command tersebut adalah simbol instruksi Unix.&lt;br /&gt;
&lt;br /&gt;
&amp;gt; adalah STDOUT sedangkan &amp;lt; adalah STDIN.&lt;br /&gt;
&lt;br /&gt;
Jika ingin melakukan export MySQL, silakan tulis &amp;gt; sebelum file export (dbexport.sql)&lt;br /&gt;
&lt;br /&gt;
Jika ingin melakukan import MySQL, silakan tulis &amp;lt; sebelum file export (dbexport.sql)&lt;/div&gt;</summary>
		<author><name>Ibm</name></author>
	</entry>
</feed>