~# sudo mysql -u root -p

> show databases;

> create database database_baru;

> create user ‘nama_user’@’localhost’ identified by ‘buatpassword’;

> grant all privileges on database_baru.* to ‘nama_user’@’localhost’;

> quit

~# mysql -u root -p database_baru < /home/user/database_lama.sql

~# mysql -u root -p

> show databases;

> use database_baru;

> show tables;

> quit

Tinggalkan Komentar :

comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here