How to allow remote root access MariaDB 10.4 on Centos 7

By default, MariaDB not allow you access as root from anywhere but localhost. In order to allow remote root access to MariaDB, follow these steps.

Step 1: Accessing MariaDB on local

Use this command

sudo mysql -u root

Step 2: Grant access for root remotely

Read the rest “How to allow remote root access MariaDB 10.4 on Centos 7”

ZingChart how to load latest data after some interval and update chart

ZingChart how to load latest data after some interval and update chart

I am using ZingChart . At loading of the page the chart successfully loads the data from MySql database . But after some interval when the database is updated how to load the … Read the rest “ZingChart how to load latest data after some interval and update chart”

PHP Grouping an Array with Multiple Dimensions from database results

PHP Grouping an Array with Multiple Dimensions from database results

I have an array as a result of a database query. Lines include two dimensions and some metrics.
Metrics must be summed by dimension groups.
Here is an example raw data array in table view:… Read the rest “PHP Grouping an Array with Multiple Dimensions from database results”

Cannot properly insert greek characters in mysql database

Cannot properly insert greek characters in mysql database

Our mysql database shows Î Î¿Î»Ï Î³Î»Ï…ÎºÏŒÏ in place of greek characters while sending data from an emulator to a mysql database. Other characters are left ok.
screenshot from phpMyAdmin:

UPDATE:
After using
@Félix Gagnon-Grenier answer in … Read the rest “Cannot properly insert greek characters in mysql database”

How big MySQL table should be before breaking it down to multiple tables?

How big MySQL table should be before breaking it down to multiple tables?

Problem: We have a very big table, and growing. Most of its entries (say 80%) are historical data (with “DATE” field past current date) that are seldom queried, while small part of … Read the rest “How big MySQL table should be before breaking it down to multiple tables?”

how to deal with accents and strange characters in a database?

how to deal with accents and strange characters in a database?

im trying to safe spanish words with accent in my database but it won’t work, i have already tried:
1) changing conllation from tables and rows to utf8_spanish_ci and utf_unicode_ci.
2)adding a header tag … Read the rest “how to deal with accents and strange characters in a database?”