How to save the entire HTML DOM in its current state
Posted by Alex On October 3, 2024
What is Document Object Model (DOM)? The content of a web page consists of HTML code received from a web server. But modern technologies (HTML 5 and JavaScript) allow you to change the content of a web page on the fly: JavaScript can add new elements, change the properties of existing elements, remove elements and […]
Choose UPDATE mysql.user SET or ALTER USER? (SOLVED)
Posted by Alex On September 29, 2024
Each MySQL and MariaDB user can have various settings, such as permission (grants) to execute certain queries to all or specific databases. Users also have settings related to identification (login) on the DBMS server, such as: user password, used authentication plugin. To change user settings such as password and authentication plugin, you can choose one […]
How to check what MySQL/MariaDB users exist and their characteristics
Posted by Alex On September 29, 2024
Contents How to display the names of all MySQL/MariaDB users How to display the names of all users and their hosts in MySQL/MariaDB How to check which users are allowed to log in without a password in MySQL/MariaDB How to check which users have expired passwords in MySQL/MariaDB. How to list users with expired passwords […]
How to display only column names and nothing more for a table in MySQL and MariaDB
Posted by Alex On September 29, 2024
How to display only field names in SHOW COLUMNS Let's look at a situation when in MySQL and MariaDB you need to get information not from the table, but about the table itself, for example, field names. We have already looked at how to get a list of fields for any table; for this, an […]
How to display results in MySQL and MariaDB without a table and without extraneous characters
Posted by Alex On September 23, 2024
Contents How to output data without a table when saving results to a file How to display results without a table on the screen How to display results in mariadb and mysql clients without a table How to configure the output of results without a table by default When working with MySQL and MariaDB in […]
How to monitor new lines in a file in PowerShell
Posted by Alex On September 21, 2024
How to set up notifications for new lines in a file If you need to monitor logs (journals) in which new lines appear, then Windows has a convenient tool for this. You do not need to install or configure anything additionally – everything you need is already available on all current versions of Windows. You […]
Error ‘mysqli::real_connect(): (HY000/1524): Plugin ‘mysql_native_password’ is not loaded’ (SOLVED)
Posted by Alex On September 20, 2024
Contents ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded How to switch a user from mysql_native_password to another authentication plugin Solution for ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded in Windows Solution to ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded on Linux Resolve ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded on macOS/Homebrew […]
How to install Apache web server with PHP, MySQL and phpMyAdmin on Windows [updated: September 2024]
Posted by Alex On September 18, 2024
Table of contents 1. Windows web server 2. How to install Apache on Windows 3. How to install PHP on Windows 4. PHP 8 setup 5. How to install MySQL on Windows 6. How to install phpMyAdmin on Windows Conclusion Windows web server A web server is a program that is designed to process requests for websites and send website […]
How to read file contents in PowerShell. How to save file contents to a variable
Posted by Alex On September 18, 2024
Table of contents How to read file contents and display them on the screen How to read a file and save it to a variable How to read multiple files with a single Get-Content command Using wildcards with file names in Get-Content How to read a specified number of lines from the beginning of a […]
Analogs of cat, tail, head and wc in PowerShell
Posted by Alex On September 17, 2024
How to pass the contents of a file to a cmdlet in PowerShell In this article, we will look at how to get the contents of a file and send it to a cmdlet for processing or for display on the screen. In Bash on Linux, when you need to pass data from a file, […]