...
4. In console, create new database, user , and passwod password to this user, make . Make sure to enter your own secure password in commands below:
Code Block | ||
---|---|---|
| ||
mysql -u root create database hostbilldb; CREATE USER 'hostbilldb'@'localhost' IDENTIFIED BY 'strongpassword'; GRANT ALL ON hostbilldb.* TO 'hostbilldb'@'localhost'; FLUSH PRIVILEGES; exit; |
5. Move database dump to the newly created db
Code Block | ||
---|---|---|
| ||
mysql hostbilldb < /root/hbdump.sql |
6. Point HostBill to the new database, by updating $db_ variables in file:
...