This is the step for standard security implementation to a fresh MySQL installation; it will;
If you answer Y (Yes) to all question. Notice the error log on the output below is because this is not the first time I ran it.
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;
This is when you want the spesific user to have all access to all database from anywhere (username@%)
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)
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, like these URLs;
http://xen.org Xen opensource site
http://en.wikipedia.org/wiki/Xen Xen on Wikipedia
This article will sums the steps required to install Xen 3.2.0 release inside a Debian Etch Box. The installation will begin on the node with base install + of course ssh server, configure and install the Host Domain (Dom0) and then creates Guest (DomU) using xen-tools from http://xen-tools.org.
Basic Network Configuration in CentOS
The file you have to keep an eye on CentOS for your box basic networking configuration is /etc/sysconfig/network and /etc/sysconfig/network-scripts/ifcfg-eth0 or /etc/sysconfig/network-scripts/ifcfg-eth0:x for the alias network Interface. Below are the example of output in My CentOS box, /24 IP Block assumed.
Read More »