Archive for the ‘Drupal’ Category

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’;

Comments (2)

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

Getting fields from mysql table using code file drupal,mysql,php

Many times it is needed to get the structure of table in PHP file or drupal module.There may be conditions that you dont have got admin user name and passwords for cpanel/phpmyadmin.In such cases you must have idea how to know the structure using a small PHP code.you can get connection info for mysql from [...]

Leave a Comment

ffmpeg video When I submit a node, a thumbnail gets created, but a 0 byte FLV file is created that is unusable…

ffmpeg video When I submit a node, a thumbnail gets created, but a 0 byte FLV file is created that is unusable…

Leave a Comment