phpMyAdmin - Suay.Site

Error “No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /run/php/php8.1-fpm.sock (*:80) failed” (SOLVED)

Posted by Alex On January 29, 2023

Debian and derivative distributions (Ubuntu, Linux Mint, Kali Linux, and many others) may experience a “FCGI: attempt to connect to Unix domain socket /run/php/php8.1-fpm.sock (*:80) failed” error when migrating from PHP 8.1 to PHP 8.2. Apache web server log sudo tail /var/log/apache2/error.log contains the following error messages: [Sun Jan 29 03:05:45.213609 2023] [proxy:error] [pid 1313500] (2)No such file or directory:...

How to rename a table in phpMyAdmin and MySQL

Posted by Alex On October 21, 2022

How to rename a table in phpMyAdmin Open the database and then navigate to the table you want to rename. When the table is open, select the “Operations” menu item. Locate the “Move table to (database.table)” section. Yes, renaming uses the same function as moving a table to another database. Enter a new table name and click the “Go” button....

phpMyAdmin error “Error: Undefined constant “SODIUM_CRYPTO_SECRETBOX_KEYBYTES”” (SOLVED)

Posted by Alex On October 20, 2022

On Arch Linux, when trying to use the phpMyAdmin 5.3 pre-release, I encountered an error: Error: Undefined constant "SODIUM_CRYPTO_SECRETBOX_KEYBYTES" Checking in Debian showed that there is no such problem with phpMyAdmin 5.3. The reason for the error is that sodium support is not enabled. How to enable sodium on Arch Linux (Manjaro, BlackArch) To enable sodium support in Arch Linux...

“Failed - Network error” when exporting from phpMyAdmin (SOLVED)

Posted by Alex On May 2, 2022

phpMyAdmin allows ones to export databases and individual tables (as well as individual rows) in the web interface. In the latest stable version of phpMyAdmin 5.1.3, users encountered a problem when exporting data from tables and databases to a file. Regardless of the selected settings, instead of downloading the file, an error is shown: Failed - Network error This is...

phpMyAdmin error “Deprecation Notice in .\vendor\twig\twig\src\Loader\FilesystemLoader.php#40 realpath(): Passing null to parameter #1 ($path) of type string is deprecated” (SOLVED)

Posted by Alex On December 17, 2021

At the time of this writing, the latest release of phpMyAdmin (5.1) is not fully compatible with the latest PHP versions (8.1.1), so the program displays the following deprecated syntax notices: Deprecation Notice in .\vendor\twig\twig\src\Loader\FilesystemLoader.php#40 realpath(): Passing null to parameter #1 ($path) of type string is deprecated Backtrace .\vendor\twig\twig\src\Loader\FilesystemLoader.php#40: realpath(NULL) .\libraries\classes\Template.php#57: Twig\Loader\FilesystemLoader->__construct(string 'C:\\Server\\data\\htdocs\\-phpmyadmin\\\\templates\\') .\libraries\classes\Theme.php#101: PhpMyAdmin\Template->__construct() .\libraries\classes\Theme.php#174: PhpMyAdmin\Theme->__construct() .\libraries\classes\ThemeManager.php#307: PhpMyAdmin\Theme::load( string...

Error “Composer detected issues in your platform: Your Composer dependencies require the following PHP extensions to be installed: mysqli, openssl” (SOLVED)

Posted by Alex On August 9, 2021

This post explains the causes of the error and how to fix it. When self-installing the web server on Windows, for example, following the guide “How to install Apache web server with PHP, MySQL and phpMyAdmin on Windows”, when trying to open the phpMyAdmin address, an error may occur: Composer detected issues in your platform: Your Composer dependencies require the...

How to install a web server (Apache, PHP, MySQL, phpMyAdmin) on Linux Mint, Ubuntu and Debian

Posted by Alex On March 16, 2021

If you are a webmaster, or a PHP programmer, or you just need to run a website on your computer, then you can do it using a web server. On Linux, the web server (Apache) and related components (PHP, MySQL, phpMyAdmin) are installed in just a few commands. This tutorial will show you how to set up a web server...

How to change default export settings in phpMyAdmin

Posted by Alex On March 7, 2021

phpMyAdmin has handy tools for exporting databases or individual tables. All this can be done in the web interface without using the command line. To export a table, click on its name on the left side of the phpMyAdmin window, and then go to the “Export” tab. A window with two export methods will be shown: Quick - display only...

Password and unix_socket authentication in MySQL and MariaDB. Error “#1698 - Access denied for user ‘root’@’localhost’” (SOLVED)

Posted by Alex On February 26, 2021

How to fix #1698 - Access denied for user ‘root’@’localhost’ In the latest versions of MariaDB (possibly MySQL), unix_socket authentication is used by default. If you are not familiar with it, then you might have encountered the error “#1698 - Access denied for user ‘root’@’localhost’”. Let's take a look at what unix_socket authentication is in MySQL and MariaDB, and how...

How to install Apache web server with PHP, MySQL and phpMyAdmin on Windows

Posted by Alex On February 22, 2021

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 pages to users. The most...