Introduction Over the past few years, I’ve immersed myself in the world of data—collecting, cleaning, analyzing, and most importantly, visualizing. Like many professionals, I relied heavily on dashboards to bring data stories to life. Yet as I delved deeper into user needs, I realized a key challenge: the more dashboards I built, the harder it […]
You are browsing archives for
Category: MySQL
How To: Install phpMyAdmin on CentOS/RHEL 6.x, How To Reset MySQL Password, Backup and Restore with mysqlhotcopy guide, Finding MySQL table storage engine
Setup Open Source Pure-FTPd with MySQL o...
Pure-FTPd is a free and secure FTP server. It provides efficiency and ease of use, simple answers to common needs, plus unique useful features for personal users as well as hosting providers. This how to guide will help you to setup Pure-FTPd with MySQL as user database. Also providing detailed instruction to create a user […]
How To: Install phpMyAdmin on CentOS/RHE...
In this article I will guide you through the steps to install phpMyAdmin. Some info from wikipedia: PHPMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases,tables, fields or rows; executing SQL statements; or managing users and permissions in a GUI based […]
How To: Reset MySQL Password
From time to time it happens that mysql password for root user gets lost and you are required to reset mysql password. here’s how it’s done: System Requirements: A Linux or Windows machine running mysql server. The following process will teach you how to reset mysql password for root user (or any other user) on […]
How To: Backup and Restore with mysqlhot...
Tutorial: Backup and Restore with mysqlhotcopy I’d like to share with you a way to backup MySQL databases and that is by using a perl script included with MySQL called mysqlhotcopy. Things to note about mysqlhotcopy are: It only works with MyISAM and ARCHIVE storage engines. Does not work with InnoDB. Is faster that mysqldump […]
How To: Find MySQL table storage engine
Tutorial: Find MySQL Table Storage Engine MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle nontransaction-safe tables. As of MySQL 5.1, MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into […]
How To: Grant MySQL Permissions for new\...
Tutorial: Grant MySQL Permissions in for new\existing users What the Red Means The lines that the user needs to enter or customize will be in red in this tutorial! The rest should mostly be copy-and-pastable. About MySQL MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a variety of options […]