[ mysql: manually delete ]

For Linux based, follow these steps:

1. GOTO: /var/run/mysqld
2. find your database name
3. right click and delete
4. done

[ mysql: create user ]

Use this commands:

1. create user <your_user_name>;
2. grant all privileges on <your_db_name>.* to ‘<your_user_name>‘@’localhost’ identified by ‘<your_password>‘ with grant option;
3. flush privileges;

Note: grant all privileges on *.* blabla.. (for all access)

[ mysql-sedut.masuk ]

Please refer instructions below:

1. enter mysql

# mysql -u root -p
2. create database
# create database <your-db-name>;
# use <your-db-name>;
3. exit from mysql
# exit
4. use this command:
# mysql -u root -p <your-db-name> < <your-db-name>;
5. finish

[ mysqldump ]

To dump MySQL database:

1. #cd ~/<your-path>
2. use this command:
# mysqldump -u root -p <database-name> > <your-database>.SQL
3. done