Kurinchi Blogger Scribbles …


Archive for March, 2010

Mar 12
2010

Ubuntu: Configure PHPMyAdmin in Simple Steps

Last updated: March 17th, 2010

$ sudo apt-get install phpmyadmin

For versions 7.10 and up, choose “Apache 2″ from the screen “Configuring phpmyadmin”

If everything goes fine, you can access phpmyadmin from
http://servername/phpmyadmin

If you have created users in MySQL, you can use those credentials to log into the database. The basic admin account is “admin” with no password.

Phpmyadmin defaults to requiring you to login after 1800 seconds of inactivity.

» MySQL Create User, Grant Rights http://kurinchilamp.kurinchilion.com/2009/04/mysql-create-user-grant-rights.html

Mar 09
2010

Linux: Port configuration for multiple network interfaces on the same server

Last updated: March 17th, 2010

Edit ports.conf file and configure the port number for the different IP’s configured for network interfaces

Listen 192.168.1.100:8001
Listen 192.168.1.200:8002

Mar 07
2010

Apache: Where to put site configuration settings?

Last updated: March 17th, 2010

/etc/apache2/conf.d/ and /etc/apache2/sites-enabled are the two locations from where configuration settings are ready by apache

Apache configuration file has two lines (listed below) in /etc/apache2/apache2.conf which does that

# Include generic snippets of statements
Include /etc/apache2/conf.d/

# Include the virtual host configurations:
Include /etc/apache2/sites-enabled/

Mar 05
2010

Ubuntu: Configuring Virtual Hosts to listen on different ports

Last updated: March 17th, 2010

Files to check
- /etc/apache2/ports.conf
- /etc/apache2/apache2.conf

Consider the ServerName to be “myserver”. Check /etc/hosts for an entry

127.0.0.1 localhost
192.168.1.100 myserver.com myserver

(more…)

Mar 01
2010

MySQL Clear Screen Window

Last updated: March 17th, 2010

To clear the screen content in MySQL use the command

mysql> \! clear

Usage of “\!” tells MySQL to pass the command to Linux OS to handle the request.

If you are in a Windows environment (DOS prompt), to pass the control to the OS you can use the command

mysql>system cls


Valid HTML 4.01 Strict  Valid HTML 4.01 Strict