MySQL - Suay.Site

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 of the following commands: UPDATE...

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 check which plugin...

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 SQL query with the SHOW...

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 the command line, the results...

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 check if a SQL query result is empty or not empty in PHP

Posted by Alex On August 18, 2024

When executing a SQL query to a database, the rows and columns of a table can be returned as the execution result. An empty value can also be returned if no data matching the query is found in the table. The usual algorithm for processing the received response from the database is to fetch the SQL query result row by...

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 MySQL/MariaDB

Posted by Alex On August 14, 2024

Backup a table in the same database This article will tell you how to make a copy of a table in the MySQL/MariaDB command line interface. 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...

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