I noticed once when executing a SQL query the following error:
Continue reading “Resolving error #1064 – You have an error in your SQL syntax”Category Archives: Databases
cPanel. Upgrade MySQL 5.5 to 5.7
For example, update the MySQL server from version 5.5 to 5.7.
Before performing an update, it is imperative that you make backup copies of all databases, including the standard ones.
Recovering MySQL InnoDB after power failure
Once, after the power was turned off, the UPS was discharged, then the generator automatic start did not work because it turned on and off several times, as a result, the server with MySQL was also started and disconnected from the power supply several times, later the tables of different databases were damaged , including the default database with mysql users, as a result, the MySQL daemon did not start.
Continue reading “Recovering MySQL InnoDB after power failure”Changing InnoDB log file size in MySQL
InnoDB log file size – the size of the transaction log files that are needed to cancel transactions and restore the database in case of failure.
Continue reading “Changing InnoDB log file size in MySQL”Configuring InnoDB Buffer Pool size in MySQL
I will give an example of resizing the InnoDB buffer pool in MySQL.
In the InnoDB buffer pool, this is the memory space in which indexes, caches, buffers, etc. are stored.
How to solve “Extension mysqli | mysql not found”
I noticed once on one of the new Ubuntu servers an error when opening phpMyAdmin – “The extension mysqli | mysql not found.”
Continue reading “How to solve “Extension mysqli | mysql not found””How to change root password for MySQL
I will give an example of changing the root password for MySQL.
Continue reading “How to change root password for MySQL”How to reset root password for MySQL
I will give the option of changing the root password of the user for MySQL.
Continue reading “How to reset root password for MySQL”How to change open_files_limit in MySQL
I will give an example of viewing and increasing the open_files_limit parameter in MySQL.
Will perform operations in the Ubuntu Server 16.04.
Changing query_cache_type in MySQL
query_cache_type – this parameter enables or disables the operation of MySQL Query Cache.
Continue reading “Changing query_cache_type in MySQL”