Sekilas Panduan MYSQL

Setting password root untuk pertama kali

$mysqladmin -u root password 'password baru'

Nambah user baru

$mysql -u root -p mysql
mysql>insert into user (host, user, password) values ('%','Antomeonkz', password('passwordnya'));

Buat database baru

mysql>use mysql;
mysql>create database hky;
mysql>grant all privileges on hky.* to Antomenkz;
myaql>flush privileges;


Ganti password dan kasi grant ke satu orang user(Antomeonkz)

$mysql -u root -p mysql
mysql>update user set password=password('password_baru') where user='Antomeonkz'
mysql>flush privileges;

atau

mysql>set password for Antomeonkz=password('password_baru');

Load file yang berisi skema database (sql syntax)

$mysql -u Antomeonkz -p namadatabase < filenya.sql

Backup database

$mysqldump -A -u root -p > backup.sql