Author Archives: Tajid Yakub
Securing MySQL Installation
This is the step for standard security implementation to a fresh MySQL installation; it will; Give the root password Remove anonymous users Disallow root login remotely Remove test database and access to it Reload privilege tables If you answer Y (Yes) to all question. Notice the error log on the output below is because this [...]
Adding MySQL User
This one from MySQL Docs; mysql --user=root mysql -p Insert your MySQL root password, it will jump you to mysql database (keeping user account information); mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; [...]
Change Your Time Zone
From somewhere else, this is the easiest way I found to change your Box’s Time Zone cp /usr/share/zoneinfo/Asia/Jakarta /etc/localtime That is if your box ran CentOS and you want the Time Zone in WIT (GMT+7)
XEN 3.2.0 on Debian Etch
For server function which is not requiring a huge dedicated resources, virtualization become an efficient option. With virtualization we could divide physical hardware nodes to be used by several Virtual Server each having their own function, their own shared resource (dedicated RAM in XEN case). You could look google up for detailed info on XEN, [...]
Basic Network Configuration in CentOS