Tag: phpMyAdmin

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 Resolve ERROR 1524 (HY000): Plugin...

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

How to find rows with empty column value in MySQL/MariaDB table (in phpMyAdmin and in command line)

Posted by Alex On August 16, 2024

How to find rows with empty column value in phpMyAdmin Suppose you want to find rows in a table where the value of a certain column is empty. To do this, you try to use the table search in phpMyAdmin. If you go to the “Search” tab in phpMyAdmin and click the “Go” button without entering any values (since you...

How to copy a table in phpMyAdmin

Posted by Alex On August 14, 2024

Backup of a table in the same database This article will tell you how to make a copy of a table in phpMyAdmin. Usually, backups of databases and tables are saved to files, but let's consider a situation when you need to duplicate or clone data, structure and indexes of tables in the same or another database in the phpMyAdmin...

ERROR at line 1: Unknown command '\-'. (SOLVED)

Posted by Alex On July 12, 2024

The database management systems (DBMS) MariaDB and MySQL are quite compatible with each other (at least in basic functionality). And until recently, it was possible to import and export databases from MariaDB to MySQL and vice versa without any problems. If you have updated MariaDB to the latest version, you may receive the following error when importing a database into...

How to increase the size of columns in phpMyAdmin

Posted by Alex On February 15, 2024

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

Posted by Alex On February 14, 2024

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

Posted by Alex On February 12, 2024

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)

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