HOW TO ACCESS MYSQL SERVER FROM ANOTHER COMPUTER OUTSIDE OF LOCALHOST

In this discussion I will explain how to access the MySQL server that are on different computers. Mysql default does not allow other users to access outside pc is installed, therefore, to access the MySQL database server itself from outside the host, we have to change a few settings mysql itself (my.cnf). and add the settings in iptables. As do the following:

1. First we need to edit the configuration file to accept and bind mysql remote connection to your server. How to do this by editing your my.conf file located on unix systems in / etc / my.conf or / etc / mysql / my.conf.
Example Run through the terminal:

vmlokal @ hobit: ~ $ sudo nano /etc/mysql/my.cnf then change the default bind-address (127.0.0.1) in the locker with your eth0 ip (ip customize to your local area network.
Example:
# Instead of skip-networking the default is now to listen only on
# Localhost the which is more compatible and is not less secure.
bind-address = 10.10.3.2

After that save and restart the service mysql-server.
Examples in ubuntu:
vmlokal @ hobit: ~ $ sudo restart /etc/init.d/mysql

2. Now we make remote configuration for mysql, we have to give access to this server to another machine. Example:
mysql -uroot -pMyPass
CREATE DATABASE mydb;
# Grant permissions to the root from any host:
GRANT ALL PRIVILEGES ON *. * TO root @ '%' IDENTIFIED BY 'mypassword';

3. Now the root user has been granted access from any host, now add the iptables for port 3306 to receive input from outside the host. Examples root login via:
/ Sbin / iptables -A INPUT -i eth0 -p tcp -destination-port 3306 -j ACCEPT

4. After that we try with mysql client application to try to test the connection from outside the host, here I use navicat as mysql client application.

Read More...!

EASY STEPS OF WEB DISSECTING

For a webmaster know the ins and outs as well as a series of web systems is quite important. At least, to learn how to the system work to be able to detect early damage throughout the system as possible.

Abongo a powerful new Webmaster Tool kit is free Webmaster Tools and Investigative Reports Including enhanced DNS, Provider, Whois, World Ping, Tracert and more from thirteen locations around the world that is very useful is able to display the location of a complete web server with a DNS address, host, Whois and Pagerank in search engines like Google and others.

Many Organizations change how they present content based on the user's geolocation. To see an example of this in action, do an investigation of BMW.com DNS Abongo. Then cycle through the various spiders using the city search links in the header and you'll see how BMW changes how it presents content based on where the query comes from. To the best of my knowledge, Abongo is the only tool in the world that can show this sort of thing.

To runis very easy, just visit Abongo and enter the name of the web to be studied. Then press a tab key to find out the address of the DNS as DNS, Whois to find out the name of the owner of the web as well as other important information.

One of the advantages of Abongo is able to display the information as accurate as possible with a simple display, making it easy to learn and understand the system that works on the web, so that we can emulate.

In other words, through Abongo we can know the location of the name server, web server, email server, even if there's a sub-domain. By knowing the location of the server then we can choose the best location for our website server.

In addition to very useful for webmasters, information displayed http://abongo.com particularly useful for prospective advertisers who will advertise. With the help Abongo, the Advertiser will not go wrong choosing the web as a place of installation of the ad so that it can effectively and efficiently. Good luck!

Read More...!

SONG YOUTUBE DOWNLOAD IN MP3 FORMAT

If you are happy with a song on youtube that are still in the form of videos and want to download it in MP3 form, the following steps are pretty easy.

Visit the web: http://www.youtube-mp3.org/ Then enter the url in the box convert. Then press the Convert button, wait until the download is complete.

Read More...!

TO MAKE PHOTO LANDSCAPE WITH BOAT FOREGROUND

Creating landscape photographs with foreground boat, sometimes making the photographers difficulty in determining the proper angle viewfinder for adjusting the position of the boat with the open sea landscape background. Especially, if the photographer wanted a visual display that match or at least closer to the concept that has been reflected in the idea. So what's the solution? It's easy, but it takes time and patience:

1. Take picture not on the first visit to the site, to get a full understanding of locations ranging from the direction of the sun rising and setting, character waves and surface currents, the position of reefs and distant islands, seas horizon or there are some parts of the mainland such as palm trees that lined, mangrove, etc.

2. Get to know the fishermen at the site, especially the owner of the boat. There is usually a boat owner himself, and fishermen who operate often different people with boat owners. Minimal acquainted with fishing boats have the right set of positions that we wish to make the foreground, if it is to get familiar with the boat owner needs more time.

3. Strive introduction to fishing at the site has a very good quality, because the quality of this introduction we can ask them to put the boat according to the concept that we want, not just photographing a boat that was leaning against the risk of spurious composition also look spurious.

4. Do not hesitate to shell out tens or hundreds of thousands in the process of this introduction: to buy cigarettes or other things that can bind either the introduction. Even if the quality of introduction has been a friendship, they will be easily as well as a natural models for our photographs, including driving the boat in a position that we want for the sake of a photo concept, including they will give a lot of information about the special moments in nature location we do not know or we are unable to estimate even armed with our knowledge of the geology, geography, measure wind speed and direction etc. Including them is necessarily willing to take us to the cool spots that we never knew before.

Read More...!

ENJOY THE SOPHISTICATION OF COMMUNICATION VIA SKYPE

Skype is a communications program with peer to peer technology that allows us to make phone calls (video calls), chat, file transfer to other Skype users all over the world when we are connected to the Internet.

Facilities vary on Skype are free and some are paid, all depending on the sophistication of the facility. However, the most popular of all these facilities is the ‘video call’ that allows us to speak via video with our speaker. To use the facility, the following tutorial:
1. Go to Registration page at http://www.skype.com/go/register?intcmp=join
2. Fill in the registration form there (If there is trouble, do not hesitate to ask)
3. The contents of all cultivated, but which required only that there is the star sign (*)
4. When finished, click "I Agree - Continue"
5. After that you will be offered if you want to buy credits, credits the goal here so that we can call to HP or a home phone. If you do not want to, just select "No thanks, I'd like to download"
6. We go to the download step. Download skype at http://www.skype.com/go/getskype-full, and then install.

Next, install an additional program called SplitCam through the following steps:
1. SplitCam program download (searching ) on Google or download from http://www.splitcamera.com/downloading.htm
2. SplitCam program installed on the laptop.
3. Attach an external camera via firewire or USB. And press the source button to connect with the camera.

And then, open an internet connection with a signal up/down at least 1.2 MGB. Open skype. And input id Continues. Settings to open the tool.... and video settings... to then open skype connection to connect with SplitCam After that stage carried live call video call to the destination id.. good luck!

Read More...!