Saturday 17 May 2014

Top 10 Best Places to Get Free Images For Your Websites

Google Images is the best place to get a huge collection of results but the main problem is that you are actually violating some ones copyright. You cannot use those images for commercial purpose, and that ares are actually hosted on Google server so these are already indexed.

Best places to get free images for your websites


Getting free high quality images for your blog and sites are not a tough work, there are dozens of websites which offers free images that are really of good quality. I have gone through some of websites which makes your task really easy.

freeimages.com

This is one of the biggest repositories of free images that has a library of almost 400,000 images covering every topics and is the best place to search for free images.

morguefile.com

Here you will get high quality images for your website for which you don't need to pay fee, but you cannot claim ownership of the images.

imcreator.com 

This website also has a collection of high quality images that are free for commercial use. It offers new way to create your websites and webpages which offer to choose design, make changes and publish it to the world.

stockvault.net

It is a stock sharing website where photographers, designers and students share their photographs, graphics and image files with each other for free. It has a collections of high resolution photographs for professional and non-commercial purpose.

pixabay.com

Here you will find and share images free of copyrights. Here all pictures are published under cco and  can copy, modify, distribute and use the images, even for commercial purposes, all without asking permission and without paying attribution.

pdpics.com

Pdpics.com is a repository of thousands of free public domain pictures and photographs. Use these stock photos freely in any project.

unsplash.com

 Here you will get a hugh collection of high resolution photographs for your website. All images are under cco license and you are free to use them in your own fashion.

picjumbo.com


Here you will get high quality well categorized images for your personal and commercial use. 
READ MORE ...

Sunday 11 May 2014

How to Reset Forgotten MySQL Root Password

For every database administrator it is essential to know the methods of  resetting root password in case if it is forgotten by them. For mysql, the system administrator is called root. You will use the mysqladmin utility from a command line to set the new password. Notice that there are two commands to be run.

MySQL Root Password Settings

Syntax:

mysqladmin -u root password “newpassword”

mysqladmin -u root -h host_name password “newpassword”

Example:

mysqladmin -u root password ws8dr8as3

mysqladmin -u root -h localhost password ws8dr8as3

You will also want to restart the database server after running this command

sudo /etc/init.d/mysql restart

How to change MySQL user password using UPDATE command in MySQL?

mysql> UPDATE user SET password=PASSWORD('newpassword') WHERE user='santosh';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Change MySQL root user password using mysql command:

MySQL stores username and passwords in user table inside MySQL database. You can directly update or change the password using the following method for the user santosh.

Login to mysql server, type the following command at shell prompt:
$ mysql -u root -p

Use mysql database (type command at mysql> prompt):

mysql> use mysql;
Change password for user santosh, enter:

mysql> update user set password=PASSWORD("NEWPASSWORD") where User='santosh';
Finally, reload the privileges:

mysql> flush privileges;
mysql> quit

READ MORE ...

How to Find Out Current MySQL Server Version Number

mysqladmin is a powerful tool for database administrator which is used for determining various configuration details of MySQL server. One of the most important feature of this command is to find out mysql server version number from command line under UNIX / Linux operating systems..


You can use the mysqladmin command to get version information from server as follows:


Open vi terminal and type the following command (for remote server login over ssh session):

$ mysqladmin -u root -p version

This will show the current version number of MySQL Database
READ MORE ...