Freebsd postgresql
Install
- pkg install -y postgresql96-server
Enable
- sysrc postgresql_enable="YES"
Initdb
- service postgresql initdb
Start
- service postgresql start
Create a user and a database
- su postgres
- createuser -P user_test
- createdb db_test -O user_test
Set more security
- mysql_secure_installation
Login
- mysql -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.6.37 Source distribution