Saturday, April 19, 2014

Clean URL Enabling in Drupal 7

To enable clean url in Drupal 7, we need to do two primary steps

1. Drpal home directory should have a .htaccess file.
2. Uncomment the RewriteBase line in the .htaccess file.

# If your site is running in a VirtualDocumentRoot at http://example.com/,
  # uncomment the following line:
   RewriteBase /

Then we need to check the clean url and save it (admin/config/search/clean-urls) 

Monday, February 3, 2014

Access MYSQL in network

To to access the MYSQL in network machine we need to following below steps

Step 1. Enable Port(3306) and host accesible in network by enableing port and host firewall. Step 1 is detailed with screenshot below
Step 2.  Create new mysql user with password. Scripts given below

Before executing below sql, replace the bind-address from 127.0.0.1 to your actual computer name in my.ini file
Eg: bind-address=inp-balat

After that restart the mysql server and execute below lines.
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%'; 


To enable port and host to be accessible in network follow below stepa as per the screenshot