I’m going to move my current MySQL server to another server so I have to backup all my current databases. One important step I need to do is check to see how data files for both MyISAM and InnoDB Storage Engines are stored by taking a look at the datadir and innodb data home dir Continue reading
We usually use phpMyAdmin which is written in PHP to manage MySQL but with SQL Server or Oracle, there is a tool called 1 Click DB which is an Open Source Web Database Administration using ASP to handle almost features to manage database, tables, indexes, users and triggers via a web-based interface. Continue reading
If you want to change,update or reset your MySQL account (ex: Root) password under Microsoft Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE, … you can use MySQL command, phpMyAdmin or mysqladmin command Continue reading
