Wednesday, July 04, 2007

MYSQL Frequently Annoying Questions

MYSQL Frequently Annoying Questions
Setting password root mysql untuk pertama kali
$mysqladmin -u root password ‘password baru’
Menambah user di mysql
$mysql -u root -p mysql mysql>insert into user (host, user, password) values (’%',’echo’, password(’passwordnya’));
Buat database baru
$mysql -u root -p mysql
mysql>create database hky; grant all privileges on hky.* to echo; flush privileges;
Ganti password dan kasi grant ke satu orang user(echo)
$mysql -u root -p mysql
mysql>update user set password=password(’passwordbaru’) where user=’echo’ ;flush privileges;
atau
mysql>set password for echo=password(’passwordbaru’);
Load file yang berisi skema database (sql syntax)
$mysql -u echo -p namadatabase <> backup.sql
Bagaimana caranya mereset password root di mysql ?
Matikan daemon mysql anda, kemudian start lagi dengan menambahkan argumen –skip-grant-tables (misalnya seperti ini : /usr/local/mysql/bin/safe_mysqld –skip-grant-tables &)
Kemudian masuk ke database mysql dan update password root yang baru, misalnya begini :
$ mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1564 to server version: 3.23.39-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> update user set password=password("rahasiadeh") where user='root';
mysql> flush privileges;
mysql> exit
Restart mysql anda seperti biasanya