Archive for November, 2008

connecting to Mysql using ODBC windows drivers within ASP code file

Many times in ASP or dot net we may need to connect to a mysql database.For making a connection to mysql database we need to install mysql connector for windows which you can download from:-..

Leave a Comment

log in mysql from command prompt windows to access database and change passwords grant privialiges Create users

First of all you should know how you can add users in mysql databases:-

* Using CREATE USER and/or GRANT commands
* Inserting a new record into the mysql.user table

First let’s see how to use the CREATE USER command:-

CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]

e.g

mysql>CREATE USER ‘myuser’@'localhost’ IDENTIFIED BY ‘mypassword’;

Leave a Comment

mod_rewrite enabling url reqriting on apache and iss server windows and linux

URL reqriting is Simple Rewriting Your URLS (links) Also Redirecting Them To Known URLS.e.g you’ll make the link : view_my_profile.html –> Is Redirected to function.php?op=3
so instead of the link “function.php?op=3″ Which isn’t enough describing itself we’ll make the link “view_my_profile.html” Which is very describtive.Why using mod_reqrite?. Now see if your site has more than 10,000 Links (Dynamic Website) , do you think we would make 10,000 html files ??

=>Of course Not , and here’s the Use Of Mod-Rewrite. We can achive dynamic pages from code and rewrite their URL using this module.

=>well simply This is Very very useful for search Engines to correctly index Your website and gather keywords, we’ll talk about this in details in “Search Engine Optimization Tips”

Leave a Comment

Firefox EC2 UI Elasticfox plugin extension for Managing Amazon EC2 Images

Firefox EC2 UI for Managing Amazon EC2 Images
Firefox provides easy plugin for managing EC2 images in a GUI method.You can download elastiic fox extension from firefox site.
The instructions for creating an Amazon EC2 image walk through the use of command line tools which is really great. Learning how to do it this way is important [...]

Leave a Comment