MySQL Error: #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.
MySQL Error: #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. Example SQL: Solution: edit file /etc/my.cnf…
Category: MYSQL
How to reset MariaDb 10.4 root password on Linux
You forgot or you unknow your root MYSQL password! How to reset MariaDb root password on Linux? Related articles – Old articles: How to change…
Node.JS: Using spawn to import a database
Example 1: background process: File api.js Example link: http://tutorialspots.com/api/import?u=admin_tutorialspots&p=tutorialspots&db=admin_tutorialspots&file=/root/tutorialspots.sql Example 2: event when import done File api.js: Example link: http://tutorialspots.com/api/importdone?u=admin_tutorialspots&p=tutorialspots&db=admin_tutorialspots&file=/root/tutorialspots.sql
PHP: How to check if a MySQL table exists
In this article, we show how to check if a MySQL table exists using PHP. Using the code below, you can check to see if…
Enable Remote Access To MySQL / MariaDB Databases on Linux
By default, MySQL or MariaDB only listens for connections from the localhost. All remote access to the server is denied by default. Step 1: To…
MYSQL: how to fix error #1364 – Field ‘name’ doesn’t have a default value
Step 1: check sql_mode You see STRICT_TRANS_TABLES in that value. Step 2: use as root account then use this command: Done, however, you should do…
How to reset MariaDb root password on Linux
You forgot or you unknow your root MYSQL password! How to reset MariaDb root password on Linux? Step 1: stop MariaDb or in some cases:…
How to change Mysql root password
Step 1: Result: Step 2: As of MySQL 5.7.6, use ALTER USER: Before 5.7.6, use SET PASSWORD: Note: you must use strong password like: Tutorialspots*123456…
How to know the default root password of MYSQL 5.7
After the installation MySQL-community-server 5.7 on linux, you will need to find the default root password. How to know it? You can find the password…
How to install MYSQL on Centos
Step 1: download RMP file, for Centos 6.x 64bits, you can use file: http://repo.mysql.com/yum/mysql-5.7-community/el/6/x86_64/mysql57-community-release-el6-7.noarch.rpm Depend on version of CentOS, you can find your file at…