MySQL
Code:
barry@paragon-DS-7:~$ mysql -u[username] -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.19-0ubuntu0.16.04.1 (Ubuntu)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
sudo apt install mycli
barry@paragon-DS-7:~$ mycli -u[username]
Password:
Version: 1.5.2
Chat: https://gitter.im/dbcli/mycli
Mail: https://groups.google.com/forum/#!forum/mycli-users
Home: http://mycli.net
Thanks to the contributor - Sudaraka Wijesinghe
mysql username@localhost:(none)>
[F2] Smart Completion: ON [F3] Multiline: OFF [F4] Emacs-mode
add a server user to the sudo < do a search on how to
Find your packages
sudo apt search 'what you need'
Code:
barry@paragon-DS-7:~$ sudo apt search php |grep -i 'php'
install the PHP you need
https://github.com/rosehosting/nginx...nginx_vhost.sh
Nginx HTTP server script
https://www.google.com/search?num=10...+host+scr ipt
Google is your friend
Let's encrypt
https://certbot.eff.org/docs/
good luck