Posted on March 27, 2022 by mudhalvan
MariaDB 10.7 Column Store Engine on Ubuntu 20.4 – Community Edition MariaDB 10.7 Column Store Engine on Ubuntu 20.4 – Community Edition Step 1. Virtual Environment Setup using either VMWare Viewer or Oracle VM Box Download VMWare Player – Evaluation Learing Purposehttps://www.vmware.com/products/workstation-player/workstation-player-evaluation.html Step 2. Download the respective VM Imagehttps://www.linuxvmimages.com/images/ubuntu-2004/#ubuntu-20044 Download VM Image for Ubuntu 20.403/22/2022 01:11 PM 2,599,524,771 Ubuntu_20.04.4_VM.7z Uncompress
Read More »
Posted on February 7, 2022 by mudhalvan
mysql> select user from mysql.user; ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them mysql> SELECT CONCAT(user, ‘@’, host, ‘ => ‘, JSON_DETAILED(priv)) FROM mysql.global_priv where user in (‘root’,’mariadb.sys’)\G;* 1. row *CONCAT(user, ‘@’, host, ‘ => ‘, JSON_DETAILED(priv)): mariadb.sys@localhost => {“access”: 0,“plugin”: “mysql_native_password”,“authentication_string”: “”,“account_locked”: true,“password_last_changed”: 0}* 2. row
Read More »
Posted on January 31, 2022 by mudhalvan
Read More »
Posted on October 21, 2021 by mudhalvan
When you have an incident of database crash or any issue we may need to collect detailed log for further investigation. Will be good to have these details You can run from the unix host. This command has been tested and confirmed on Centos Linux. Make sure you are able to login to mysql instance using “mysql -P 3306” in
Read More »
Posted on May 20, 2020 by sarah
How to fix lost connection of MySQL server during query? This issue caused of running a long query. To fix this on MySQL Workbench, you can change the option of connection read time out. In my case using Mac click : MySQLWorkbench > Preferences > SQL Editor. On MySQL Session part, increase the “DBMS connection read timeout interval (in seconds)”
Read More »