How to Change MySQL Data Directory in Linux Centos
By default Linux CentOS or other Linux Distro installation, MySQL data directory is stored in /var/db/mysql, how can I change it to other directory in example /db/mysql? It is always better to have MySQL Data Directory store in a specific…
PostgreSQL Database psql Command Line Query
Sometime psql command line query can be useful when it comes to Bash script processing. There are data stored in PostgreSQL database and I would like to write a bash script to massage the data into report. Example below show…
Create Root Privilege User on MySQL
By default, MySQL root privileges user is “root”, I always remove “root” userid once I got MySQL installed, mainly for security purpose, secondly I do not want stupid thing happened like someone able to brute force into MySQL database. You…
Reset MySQL Root Password
Very often, once we didn’t log on to MySQL database for some time, I guess most of us will forgot the root password. Can we reset the root password? Obviously… Nothing is Impossible 😛 Follow the steps below to reset…
Recent Comments