mysql grant privileges

mysql> CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'localhost' WITH GRANT OPTION;
mysql> CREATE USER 'user_name'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'%' WITH GRANT OPTION;

Site traffic source and medium

Hi,

Today learn google analytic, traffic source and medium.

Source / Medium. 

Source: the origin of your traffic, such as a search engine (like, google,bing,yahoo) or a domain (irctc.co.in). 

Medium: the general category of the source, (for example, organic search (organic), cost-per-click paid search (cpc), web referral (referral), email campaign). 

Solved Mix match content issue

Hi,

Daily I've received new experience, today fixed mix and match content in blog.

Searched and found WordPress plugin.

Installed activities Really secure SSL plugin and resolved the issue.

Note. If anyone using cloudflare SSL certificate and use cloudflare plugin.

Have a good day!

Rewrite rule in iis

N numbers of  4xx series and 5xx series rewrite rul map in iis and web.config.

WordPress in IIS

Hi,

Yes, Possible WordPress, PHP, MySQL in IIS and windows environment.

I've difference experience to the implementation of the blog in IIS.

Please follow points,

Devops role

Devops role,

1.work collaboratively with software engineering to deploy and operate our systems.
2.Help automate and streamline our operations and processes.
3.Build and maintain tools for deployment, monitoring and operations. 4.And troubleshoot and resolve issues in our dev, test and production environments.

Sql Server - Find the Size of Database File and Find the Size of Log File

use below script to find the size of the DB

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = '<<your database name>>'
GO