Skip to content

database.md

Latest commit

 

History

History
22 lines (19 loc) · 700 Bytes

database.md

File metadata and controls

22 lines (19 loc) · 700 Bytes

Database Setup

In order for the Panel to get and set data, we'll need a database. This is where all the information about the Panel is stored. In this case, we're using MySQL..

?> One thing you could do to further secure and scale the Panel is to have a separate VPS or server for databasing. This could be beneficial down the line for things like multi-cluster deployments and load balancing databases.

Create database

mysql -u root -p

# Remember to change 'yourPassword' below to be a unique password
CREATE USER 'dezer'@'127.0.0.1' IDENTIFIED BY 'yourPassword';
CREATE DATABASE dezerx;
GRANT ALL PRIVILEGES ON dezerx.* TO 'dezer'@'127.0.0.1' WITH GRANT OPTION;
exit