Tag: MySQL

“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...

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

How to change default export settings in phpMyAdmin

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)

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

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