create database and create user grant all to that database at mysql

 mysql> create database xxx;

Query OK, 1 row affected (0.01 sec)


mysql> use xxx

Database changed

mysql> create user 'xxxuser'@'%' identified by 'xxx';

Query OK, 0 rows affected (0.01 sec)

mysql> grant all on xxx.* to 'xxxuser'@'%';

Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)


Postingan populer dari blog ini

Create a root password for PHPMyAdmin

Extensions pada WYSIWYG Web Builder

Tabel Perbandingan Kode Baterai Kancing (Button Battery)