Tag: phpMyAdmin

How to increase the size of columns in phpMyAdmin

Table of contents 1. Why phpMyAdmin does not show the full contents of a cell (column) 2. How to view the full contents of a cell in phpMyAdmin 3. Why does changing column widths not show the entire data? 4.How to increase the number of characters in cells in phpMyAdmin Why phpMyAdmin does not show the full contents of a...

How to search in phpMyAdmin

Table of contents 1. How does searching through databases and tables work in phpMyAdmin 2. Instructions for using the search function in phpMyAdmin 3. Search the database as a whole. Search multiple tables simultaneously 4. Single table search Conclusion How does searching through databases and tables work in phpMyAdmin Searching MySQL/MariaDB is performed using SQL queries and therefore requires knowledge...

Case sensitive search in phpMyAdmin

Table of contents 1. Case sensitive search in phpMyAdmin 2. How to create a request with “BINARY” in phpMyAdmin 3. How can I make SQL case sensitive string search in phpMyAdmin 4. Video on how to find a case-sensitive string in phpMyAdmin Case sensitive search in phpMyAdmin Let’s try to find rows in the table that contain the word “test”....

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

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

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)

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)

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)

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)

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

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...
Loading...
X