/var/logs/paulooi.log
Menu
  • About Me
  • Contact
  • Privacy Policy
Systems Admin, Web Development and etc
Browse: Home » database

How to Change MySQL Data Directory in Linux Centos

July 2, 2011 · by Paul Ooi · in Open Source, Systems

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

July 12, 2010 · by Paul Ooi · in Systems

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

May 11, 2010 · by Paul Ooi · in Systems

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

May 10, 2010 · by Paul Ooi · in Systems

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 Posts

  • Proxmox Cluster Quorum Error
  • Thunderbird Unified Folder Some Account Inbox Missing
  • This Site is 18 Years Old
  • How to Rsync from Remote Server to Synology
  • Are you a Programmer and Preparing for an Interview?

Recent Comments

  • Paul Ooi on How to do Word Count on TextMate
  • Harshal on How to do Word Count on TextMate
  • Paul Ooi on How to Rsync from Remote Server to Synology
  • Jil Yana on How to Check Paypal Pre-Approved Payment List
  • Benedict Arnold on Enable SMTP Port 587 on Exim

Copyright © 2025 /var/logs/paulooi.log

Powered by WordPress and Origin