Archive: December, 2015

Reset MySQL Root Password in Windows

December 31, 2015 by Linux Guru

Filed under Database, MySQL, Window

Last modified July 15, 2016

Reset MySQL Root Password in Windows 1] Log in to your system as the “Administrator” user created in Windows setup. 2] Stop the MySQL service by clicking “Start,” “Control Panel,” “Administrative Tools,” “Services.” Scroll down to “MySQL.” Click “Stop.” 3] Open Notepad from the Start menu and enter the text: “UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root.’“ 4] Save the file to an easily accessed location …

Access denied for user ‘root’@’s4techno.com’ (using password: NO)-Linux OS

December 31, 2015 by Linux Guru

Filed under Database, MySQL

Last modified July 15, 2016

Access denied for user ‘root’ using password If you are getting this error message while accessing mysql from the shell then make sure that you have done $su – from the command prompt after that fire #mysql even if you are getting that error message then you need to reset the mysql password you can use following steps for it first locate your mysql’s hostname.pid …

Block /var/www/cgi-bin for unauthorized access

December 30, 2015 by Linux Guru

Filed under Application

Last modified July 15, 2016

Block /var/www/cgi-bin for unauthorized acces We need to update this in httpd.conf file. #<Directory “/var/www/cgi-bin”> #    AllowOverride None #    Options None #    Require all granted #</Directory> <Directory “/var/www/cgi-bin”> Order Deny,Allow Deny from all Allow from 127.0.0.1 </Directory> Note:  After that the above configuration we will get the mail regarding cgi-error but this is safe configuration so that nobody can get unauthorized access …

Convert packages between .deb and .rpm

December 29, 2015 by Linux Guru

Filed under Linux

Last modified July 15, 2016

Convert packages between .deb and .rpm The conversion tool that we will need is called “alien” and you can install it on Ubuntu by opening a terminal and running the following command: sudo apt-get install alien If you’re using Fedora or CentOS, you can install alien with: yum install alien Debian users can do this through: apt-get install alien Now let’s suppose that I want …

PHP / MySQL Web Application Migration Steps

December 29, 2015 by Linux Guru

Filed under Application, php

Last modified July 15, 2016

PHP / MySQL Web Application Migration Steps There is a lot more work involved in Server Migration. The thing is, not all information is stored in navigable files and folders, there is information stored elsewhere in the system, such as a database, and meta information tied into the existing file structures. This article will mention steps required to move a web application. Requirements You will …

Uninstall Xcode Completely on Mac OS

December 29, 2015 by Linux Guru

Filed under Unix

Last modified June 15, 2016

Uninstall Xcode Completely on Mac OS You need root access for running following command To uninstall developer tools/Xcode type in the following command in the terminal sudo /Developer/Library/uninstall-devtools –mode=all But beware, this completely removes Xcode and once it is gone, it’s gone. Of-course you can always reinstall it. So be sure of what you are doing.Beta version (e.g. Safari 4 beta) application create problem in …

Microsoft Bug OR Its Magic

December 29, 2015 by Linux Guru

Filed under Window

Last modified June 15, 2016

Microsoft Bug OR Its Magic Try this Magic… You will be surprised for it result. MAGIC #1 An Indian found that nobody can create a FOLDER anywhere on the Computer which can be named as “CON”. This is something funny and inexplicable? At Microsoft the whole Team, couldn’t answer why this happened! TRY IT NOW, IT WILL NOT CREATE A “CON” FOLDER MAGIC #2 For …

Choose UTM (Unified Threat Management) for your Network

December 28, 2015 by Linux Guru

Filed under Security

Last modified June 15, 2016

Choose UTM (Unified Threat Management) for your Network Following are some question when you evaluates UTM and choose one from many UTM boxes. 1] How Does the UTM Solution Perform? 2] Which Security Technologies Are Included? ✓ Firewall ✓ Application control ✓ IPsec and SSL VPN ✓ IPS (Intrusion prevention systems) ✓ Web content filtering ✓ Anti-spam ✓ Data loss/leakage protection ✓ Anti-virus and anti-spyware …

Backup PostgreSQL Databases Server With pg_dump command

December 28, 2015 by Linux Guru

Filed under Database

Last modified July 15, 2016

Backup PostgreSQL Databases Server With pg_dump command PostgreSQL is a one of the robust, open source database server. Like MySQL database server, it provides utilities for creating a backup. Step # 1: Login as a pgsql user Type the following command: $ su – pgsql Get list of database(s) to backup: $ psql -l Step # 2: Make a backup using pg_dump Backup database using …

Deploy ncurses and mcrypt extension in php5

December 28, 2015 by Linux Guru

Filed under Application, php

Last modified July 15, 2016

Deploy ncurses and mcrypt extension in php5 ncurses and mcrypt is in the EPEL repository. EPEL Repository Url:-  http://epel.mirror.net.in/epel/ [1] You need to copy link location from above base EPEL url like [root@test~]#rpm -Uvh http://epel.mirror.net.in/epel/6/x86_64/epic5-1.1.6-1.el6.x86_64.rpm then You can use yum utility. [root@test~]#yum install php-mcrypt [root@test~]#yum install php-pecl-ncurses OR [2]  Directly install packages using web site. mcrypt [root@test~]#rpm -Uvh http://epel.mirror.net.in/epel/6/x86_64/libmcrypt-2.5.8-9.el6.x86_64.rpm [root@test~]#rpm -Uvh http://epel.mirror.net.in/epel/6/x86_64/php-mcrypt-5.3.3-1.el6.x86_64.rpm ncurses #rpm -Uvh …