Anduin Xue

let today = new Beginning();

MySQL

19
OCT

MySQL allow remote connection (For root and other users)

For all Ensure firewall allows 3306 port: sudo ufw allow 3306 Allow MySQL to bind to all ports: sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf Then set bind-address to 0.0.0.0. bind-address = 0.0.0.0 For root user Log in root locally first: mysql -u root -p Replace the host value. mysql GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'password'; mysql UPDATE mysql.user SET host='%'  …

bash Database Linux Ubuntu Remote Management MySQL
05
JUL

Install Nextcloud on a Ubuntu 20.04\22.04 server

Step 1 - Buy a server and basic configuration You can buy a pure server at Vultr. After you installing a pure Ubuntu, or buying a new cloud Ubuntu server, you need to first finish the basic authentication configuration. Follow instructions here to: Delete other accounts. Create your own account instead of root. Disable password login and force to use SSH key to log in. Disable root account.  …

Web Linux Ubuntu IT Apache2 PHP MySQL Certbot Nextcloud Storage
  • 1