Installing MariaDB Database Server on macOS
MariaDB is an alternative to MySQL database which is more performant with a full open license, you can install it easily on macOS via Homebrew. The first step is to install Homebrew on your computer and possibly to remove any older MySQL database server versions. Once Homebrew is installed, on the command line: brew install…
Read MoreRemove MySQL database server from macOS or OSX via the command line
To remove an instance of MySQL Database Server from your macOS or OSX installation you need to delete a number of files via the command line, but first ensure that you have database dumps of your databases and that then the database server is not running. Back Up any needed MySQL databases Launch the command…
Read MoreUpdating to PHP versions 7.4 and 8 on macOS 11 Big Sur and Catalina
The latest macOS versions of Big Sur and Catalina currently ship with PHP 7.3 and have a deprecation notice that they intend to drop support for PHP altogether in a future upgrade. You can see this by running a <? phpinfo(); ?> function in a webhosted file or running php -v on the command line.…
Read MoreSet up WP Fastest Cache with Optimus Prime in Local Mode
Optimus Prime is a cache warmer to load web pages faster on initial load by querying all pages on a websites sitemap via the sitemap URL, it works in harmony with a cache plugin preloading tool. Optimus Prime also has a local mode in which it checks the local cache folder for cached relative URLs…
Read MoreInstall Apache, MySQL, PHP on macOS 11 Big Sur and earlier macOS
Get your Local Web Development Environment Up & Running on macOS Big Sur 11 and Catalina 10.15 With Apples’ new macOS Big Sur 11 available for download, here is how to get the AMP stack up and running on the new macOS. This tutorial will go through the process of getting Apache, MySQL, PHP (or…
Read MoreFinding the Large Files on a Linux/Ubuntu Server
Reducing space on a server is a never ending task, taking out the big unnecessary large files will speed up the process. A bloated log is an example of files that may be building up on your limited disk space. This command run on Linux: CentOS, Red Hat, Fedora and Ubuntu via command line will…
Read MoreCreating a Social Media Menu from Icon Fonts with FontAwesome
How to make social media menus from icon fonts using the awesome FontAwesome. Fontawesome is widely used and supported in all modern browsers and older browsers. <link href=”https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css” rel=”stylesheet”> You can link to the Fontawesome CSS file via a CDN or just copy the download it to your site. If using WordPress you can…
Read MoreHow to connect to a MySQL or mariadb database with PHP
This tutorial will require a mysql database set up with a database user and password and a web development environment using mysql or mariadb, apache and php and a simple text editor. The tutorial takes you through establishing a mysql connection using php on a web page, connecting to a mysql table and retrieving the…
Read MoreQuery dns/domains in macos using dig and nslookup via the command line
In macos you can query a domain via the command line via default nameservers with a couple of DNS querying tools, notably nslookup and dig, how that works is on the command line: dig domain.com or nslookup domain.com The results are returned to you on the command line. Query from a different nameserver To query…
Read MoreIn macOS, show the difference of 2 folders / files in the Command Line
In macOS, you can compare and show the differences of files in two folders in the Command Line by using the diff command. With folders you use rq as an argument and pass in the 2 folder names on the command line like so… diff -rq folder_1 folder_2 You will get notifications on what same…
Read More