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…
Tag: 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
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 connect Mysql server through SSH tunnel using AutoSSH
Read this tutorial first: How to create SSH tunnel on Windows by using AutoSSH In step 8, we use the command like: Now, all traffic…
How to install Mtop (MySQL top) in CentOS
mtop (MySQL top) monitors a MySQL database showing the queries which are taking the most amount of time to complete. Features include ‘zooming’ in on…
Centmin Mod: Install Phpmyadmin
Step 1: Step 2 If you get the error: You can download it here Result: Step 3 Now you can access phpmyadmin via address: https://tutorialspots.com/6936_mysqladmin27567/…
PHP & MYSQL: Anti Sql Injection with mysql_real_escape_string function
Mysql command will be: Mysql command will be: With this command will cause one user login without the correct password. => use mysql_real_escape_string to prevent…
PHP MYSQL: list of Timezones, Set Timezone
Recently I needed to check the time zone in one of my applications, because it is accessed from multiple locations in United States and soon…
Maxlength of MySQL TEXT Data Types
Data types and range of data management system MySQL database (Read more) TEXT Data Types in MySQL CHAR CHAR data type for storing a data…