Tutorials for Developers & Sysadmins
Step-by-step guides for the work we actually do — Laravel, PHP, WordPress, MySQL, Linux servers, and the occasional rabbit hole. Every command has been run on a real machine; nothing is theoretical.
How to Access MySQL from Command Line in XAMPP on Windows
Fix 'mysql is not recognized' in XAMPP on Windows. cd into C:\xampp\mysql\bin or add it to Windows PATH so the…
How to Reset the MySQL Root Password in aaPanel
aaPanel MySQL root password: reset from the Databases page, or use the SSH auth_socket / --skip-grant-tables fallback. Plus why apps…
How to Display PHP Errors
Display PHP errors via ini_set at the top of a file, or permanently in php.ini, .user.ini, or .htaccess. Why parse…
How to Convert a String to Uppercase in PHP
PHP string uppercase with strtoupper, mb_strtoupper for UTF-8, ucfirst and ucwords for title case. When CSS text-transform is the better…
How to Convert a String to Float in PHP
PHP string to float: (float) cast for clean numbers, preg_replace + cast for mixed currency strings, NumberFormatter for locale-aware parsing.…
How to Combine Two Arrays Without Duplicates in PHP
PHP merge arrays unique: union operator (+) for keyed arrays, array_unique+array_merge for numeric, array_replace_recursive for deep nested config merges.
How to Delete an Element from a PHP Array
PHP delete array element four ways: unset by key, array_splice by offset, array_filter by callback, array_search + unset by value.…
How to Export and Import All MySQL Databases at Once
mysqldump all databases — single command exports the whole server. Covers --single-transaction for live servers, compression, scheduled backups, and import.
How to Create Users and Grant Privileges in MySQL 8 on Ubuntu
MySQL create user + GRANT privileges on MySQL 8/Ubuntu. Covers auth_socket / caching_sha2 / mysql_native_password plugins, scoped grants, REVOKE, and…
How to Connect to a Remote MySQL Database from Ubuntu
MySQL connect to remote server from Ubuntu: install mysql-client only, use mysql -h host -u user -p. Plus 'No route…