Category: MySQL

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

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”

How to get the MySQL Server Only installer package?

I’m working on a small .Net project, I used in my project EntityFramework with MySQL server, i tried the official Full MySQL installer, but i need only the server from that package to reduce the size … Read the rest “How to get the MySQL Server Only installer package?”

selecting multiple categories from database

I am working on a blog system where blogs are categorized and we can choose the category we want to. For this, I have to separate the tables blogs and categories. I know how to get blogs from all categories … Read the rest “selecting multiple categories from database”

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

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”

Bash: Unable to enter into if even the condition is true

I am building a script which will backup a WordPress database.
I have created the function need for the MySQL dump:
function db_backup {
read -r -p “Dump the database? [Y/n]: ” response
if … Read the rest “Bash: Unable to enter into if even the condition is true”

How can I log all outgoing SQL statements from Go / MySQL?

I’m using a non-framework Go stack with sqlx, and MySQL for a web project.
I would like to log all outgoing SQL statements for debugging. Is it possible to do this? Hopefully looking … Read the rest “How can I log all outgoing SQL statements from Go / MySQL?”

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?

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?”