Contents General commands Working with databases and tables Working with databases Working with tables Working with columns Selecting data Using regular expressions Importing and exporting data MySQL users, passwords MySQL root reset Backup, restore Creating backups Restore from a backup Tables creation examples General commands To check MySQL status run: systemctl status mysql To connect to a MySQL server running on the same host: mysql -u username -p To connect to a MySQL server running on the remote host db1.example.com:...
Read More

A PHP application might produce many different levels of earning and errors during its execution. Being able to see these errors is essential for developers trying to troubleshoot a misbehaving application. However, developers often have trouble when trying to display errors from their PHP applications. Instead, their apps just fail silently. The quickest way to display all php errors and warnings is to add these lines to your PHP code file: ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); What Do These Lines of Code Do Exactly? The ini_set...
Read More

Installing NetFx3 on Windows 8,8.1,10,11 through Programs and Features or cmd You may need the .NET Framework 3.5 to run an app on Windows 11, Windows 10, Windows 8.1, and Windows 8. You can also use these instructions for earlier Windows versions. Download the offline installer The .NET Framework 3.5 SP1 offline installer is available on the .NET Framework 3.5 SP1 Download page and is available for Windows versions prior to Windows 10. Install the .NET Framework 3.5 on Demand You may see the following configuration dialog if you try...
Read More

Installing Virtualmin onto your server, the easy way, is through their script: wget https://software.virtualmin.com/gpl/scripts/install.sh Run the Install Script and Configure Virtualmin Execute the install script using the following command /usr/bin/sudo /bin/sh install.sh Run the install script with the --help flag for a list of available options, and consult the documentation, especially about the available installation bundles and the minimal installation mode, if choosing a non-default installation type. Complete all the questions the script may ask. You need to provide a fully...
Read More

For fast and simple configuration you can use our Netplan Generator. Here we have a collection of example netplan configurations for common scenarios. Configuration To configure netplan, save configuration files under /etc/netplan/ with a .yaml extension (e.g. /etc/netplan/config.yaml), then run sudo netplan apply. This command parses and applies the configuration to the system. Configuration written to disk under /etc/netplan/ will persist between reboots. Using DHCP and static addressing To let the interface named 'enp3s0' get an address via DHCP, create a YAML file with the following:...
Read More