development - Suay.Site

How to create a new MySQL (MariaDB) user and configure its status and privileges

Posted by Alex On August 19, 2023

This note will show how to create a new MySQL (MariaDB) user, as well as configure its privileges (permissions) at the DBMS level as a whole, at the level of a particular database, and even at the level of individual tables and columns. Why create a new MySQL or MariaDB user Using root to perform Data Management Language (DML) operations...

How to allow a user to access only certain columns in MySQL (MariaDB)

Posted by Alex On August 18, 2023

Table of contents 1. How to set permissions on individual columns in MySQL (MariaDB) 2. How to allow the user to add entries to a column 3. How to allow the user to view entries in a column 4. How to allow the user to update records in a column 5. How to allow the user to create a foreign...

How to allow a user to access only certain tables in MySQL (MariaDB)

Posted by Alex On August 18, 2023

Table of contents 1. How to set permissions on individual tables in MySQL (MariaDB) 2. How to allow a user to create a specific table in a database 3. How to allow a user to delete a specific table in a database 4. How to allow a user to delete records in a table 5. How to allow a user...

How to allow a user to access only certain databases in MySQL (MariaDB)

Posted by Alex On August 17, 2023

Table of contents 1. How to set permissions on individual databases in MySQL (MariaDB) 2. How to allow a user to create tables in a database 3. How to allow a user to delete tables in a database 4. How to allow user to delete records in database tables 5. How to allow user to add records in database tables...

Error when using ‘USE’ statement in MySQL (Mariadb): “ERROR 1044 (42000): Access denied for user” (SOLVED)

Posted by Alex On August 16, 2023

Table of contents 1. The “USE” statement causes the error “ERROR 1044 (42000)” 2. How to fix MySQL (MariaDB) “ERROR 1044 (42000): Access denied for user” with USE statement 3. How to grant a user read access to a database and its contents 3.1 How to give a user read access to a specific database in MySQL (MariaDB) 3.2 How...

ERROR 1044 (42000): Access denied for user ‘mial’@’localhost’ to database ‘TestDB’. Can’t create MySQL database (SOLVED)

Posted by Alex On August 14, 2023

Why can't user create MySQL (MariaDB) database When trying to create a database, you may encounter an error: ERROR 1044 (42000): Access denied for user 'mial'@'localhost' to database 'TestDB' The reason for the error is that the specified user (username “mial” in this example) does not have the authority to create databases. The solution to the problem depends on the...

How to list MySQL/MariaDB users and their privileges (using RDBMS client and PHP)

Posted by Alex On August 13, 2023

This note explains which queries can be used to list MySQL and MariaDB users. The article shows how to run these commands in MySQL/MariaDB query string as well as with PHP. How to display a list of users and their privileges using the DBMS client Queries to list MySQL / MariaDB users To list all users in MySQL / MariaDB,...

How to show all errors in PHP 8

Posted by Alex On July 6, 2022

How to display all errors in PHP 8 By default, PHP 8 disables showing errors, so if there is a problem while executing a PHP script, nothing will be displayed on the screen. If an error in the program occurred before the output of the HTML code, then you will see a white screen of the web browser. Where is...

How to make images on a site (including WordPress) maintain the correct aspect ratio

Posted by Alex On June 3, 2022

How to maintain aspect ratio with HTML IMG tag An image inserted into a page has the correct proportions by default unless you change it. When viewing images on a mobile phone, the images are scaled, that is, resized to fit completely on the screen. Web pages work in a similar way, including sites running WordPress. But I noticed one...

Error “remote: Support for password authentication was removed on August 13, 2021. Please use a personal access token instead” (SOLVED)

Posted by Alex On November 28, 2021

The article “How to make and submit changes to source code on GitHub” shows you how to update files on GitHub after you have edited their local copies on your computer. The commands shown in the article are still valid, but due to changes on GitHub, now instead of a password, you need to use a token that you need...