How to Allow MySQL Client to Connect to Remote MySQL server

Issue: How do I allow a MySQL client to connect to a MySQL database server?

Solution: By default, MySQL does not allow remote clients to connect to the MySQL database.
If you try to connect to a remote MySQL database from your client system, you will get the “Host is not allowed to connect to this MySQL server” message as shown below.

$ mysql -h 192.168.1.8 -u root -p
Enter password:
ERROR 1130: Host '192.168.1.4' is not allowed to connect to this MySQL server

You can also validate this by doing telnet to 3306 mysql port as shown below, which will also give the same “host is not allowed to connect to this MySQL server” error message.

$ telnet 192.168.1.8 3306
host 192.168.1.4 is not allowed to connect to this mysql server

If you want to allow a specific client ip-address (for example: 192.168.1.4) to access the MySQL database running on a server, you should execute the following command on the server that is running the MySQL database.

$ mysql -u root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';
mysql> FLUSH PRIVILEGES;

Also, update firewall rules to make sure port# 3306 is open on the server that is running the MySQL database.


After the above changes, when you try to connect to the MySQL database from a remote client, you’ll not get the “Host is not allowed to connect to this MySQL server” error message any more.

How To Install VMWare Tools v4 on Ubuntu 12.04 LTS Server

How To Install VMWare Tools v4 on Ubuntu 12.04 LTS Server and 12.10 Server

Written: March 13, 2012
Originally posted by: Justin Schier
Last Updated: October 24, 2012
Tested With: Ubuntu 12.10 Server, Ubuntu 12.04 LTS Server, Ubuntu 12.04.1 LTS Server, Ubuntu 11.10 Server

All the guides I found on the Internet, including VMWare’s website were outdated in some way, so I decided to write a guide of my own. I just went through these steps from start to finish on a fresh server and had no problems. In about 5 minutes, you will be able to install VMWare Tools on Ubuntu Server.

1. Use Install VMWare Tools option in VMWare Client to attach media
    
2. Update the server
   
   sudo apt-get -y update sudo apt-get -y upgrade

   1 2	sudo apt-get -y update sudo apt-get -y upgrade

3. Create the mount point
   
   sudo mkdir -p /media/cdrom

   1	sudo mkdir -p /media/cdrom

4. Mount the ISO
   
   sudo mount /dev/cdrom /media/cdrom

   1	sudo mount /dev/cdrom /media/cdrom

   
   You should see the message: mount: block device /dev/sr0 is write-protected, mounting read-only
5. Change Directory
   
   cd /media/cdrom

   1	cd /media/cdrom

6. Copy the tar file to your /tmp directory
   
   sudo cp VM*.tar.gz /tmp

   1	sudo cp VM*.tar.gz /tmp

7. Install Build tools if necessary
   
   sudo apt-get -y install linux-headers-server build-essential

   1	sudo apt-get -y install linux-headers-server build-essential

8. Change Directory
   
   cd /tmp

   1

   cd /tmp

9. Unmount the ISO
   
   sudo umount /media/cdrom

   1	sudo umount /media/cdrom

10. Expand the tar
    
    sudo tar xzvf VM*.tar.gz

    1	sudo tar xzvf VM*.tar.gz

11. Change Directory
    
    cd vmware-tools-distrib

    1	cd vmware-tools-distrib

12. To prevent a potential error in the install script on Ubuntu 11.10+, create a special directory
    Unable to create symlink “/usr/lib64/libvmcf.so” pointing to file ”/usr/lib/vmware-tools/lib64/libvmcf.so/libvmcf.so”.
    
    sudo mkdir -p /usr/lib64

    1	sudo mkdir -p /usr/lib64

13. Run the Install Script. The -d flag automatically answers the default to all questions. To customize it, just omit the -d.
    
    sudo ./vmware-install.pl -d

    1	sudo ./vmware-install.pl -d

14. Reboot
    
    sudo reboot

    1	sudo reboot

Let me know if this worked for you!
Also, please follow me on Twitter: @justinschier

This is "How to do Computing" for everyday usage ...

Manually uninstalling VMware Workstation from Linux hosts

Manually uninstalling VMware Workstation from Linux

VMWare Workstation doesn't ship in a deb, so it isn't registered in dpkg (which is why you can't find it in the software center). It does have an install and uninstall utility though.

To uninstall VMWare Workstation, you will need to run

#vmware-installer --uninstall-product vmware-workstation

Details

This article provides steps for manually removing VMware Workstation when the uninstaller script or RPM package fails to remove the product automatically.

Solution

Note: Log into the host using the root account to execute the terminal commands in this article. If running Ubuntu, the root account is not available by default. Prepend all commands with sudo,or switch to root using this command:

sudo su -

Warning: This command provides unrestricted access to the operating system. It is possible to cause damage to the system when using this access level.

1. Open a command prompt. For more information, see Opening a command or shell prompt (1003892). Type the commands as indicated in the steps of this procedure.
   
2. Shut down all VMware applications and services.
   
   /etc/init.d/vmware stop
   
   
3. Verify that all processes have stopped:
   
   lsmod | grep vm
   
   Note: A zero must be listed beside VMware related modules to indicate that they are no longer running.
   
   
4. Move the VMware libraries to the /tmp directory:
   
   cd /lib/modules/kernel_version/misc
mv vm* /tmp
   
   Note: If the kernel has ever been updated, you must check and move the files from multiple paths. Substitute the kernel version where indicated above.
   
   
5. Unload the kernel modules:
   
   rmmod vmnet.o
rmmod vmmon.o
rmmod vmci.o
rmmod vmblock.o
rmmod vmppuser.o
   
   
6. Remove the VMware startup scripts:
   
   RedHat and Most Distributions:
   rm /etc/rc.d/init.d/rc2.d/*vmware*
rm /etc/rc.d/init.d/rc3.d/*vmware*
rm /etc/rc.d/init.d/rc5.d/*vmware*
rm /etc/rc.d/init.d/rc6.d/*vmware*
   
   Ubuntu:
   
   rm /etc/rc2.d/*vmware*
rm /etc/rc3.d/*vmware*
rm /etc/rc5.d/*vmware*
rm /etc/rc6.d/*vmware*
   
   Note: If you are using a different Linux distribution, substitute the correct path in the commands.
   
   
7. Remove the remaining VMware files and directories:
   
   rm -rf /etc/vmware*
rm /usr/bin/vmware-usbarbitrator
rm /usr/bin/vmnet*
rm -r /usr/lib/vmware*
rm -r /usr/share/doc/vmware*
   
   
8. If an RPM package was used to install the VMware product, complete these steps to delete the RPM database entry:
   
   rpm -qa | grep VMware
   
   A list of VMware packages is presented. Copy the exact package name for the next step and paste it into the command where indicated.
   
   
9. Remove the VMware packages:
   
   rpm --erase --nodeps VMware_Package_Name

How the Internet Works ..Explained Here

Got files separed from norm HTML

After meet up with team members we decide to migrate the site from norm HTML to PHP, the all projetc will take quite a while to finish, but so far the foundations, of the project are already laid down.. Quite interesting to see how this process is unfolding down ...

• Cut all the code and past in a separated document
• Save the new document with a different header name with .php file extension.
• Then import the content of the heading document into the main html document using the include* function - [ include is part of php library ]

Seems like all gone as we were expecting, but bear in mind that we faced some bugs when we tried to apply this approach the first time  ... Here it goes the output still getting the original content but keeping all the information rendered on server..

Here follows a screen shoot of the file the way it was before it been changed .. All the HTML markup in just one page ..

The First Digital Weapon Ever Made .. All build in Code

I got stuck to on Oracle DataBase Developer apps

Dear Readers, 


Over a period of one entire, month I've being put off by Linux ubuntu 11.10, to install the sqldeveloper package. Every single time I've tried to do it, I got errors ... 


Today finally I managed to find the solution.. Someone had the same problem as me and posted a solution in one forum, so I followed their instructions and got mine working.. Thank you to this guy.. 


Really saved the day.. 


So, I decide to honour him and post his solution here. 


"Hi guys, just got a quick question: 

I need to install Oracle's SQL Developer since I need to use the program for a database unit at Uni. Anyway, if you've tried to use it before you'd realise that there is only a .rpm installer available for it (no .deb). So I tried to convert it to .deb using alien.  When I "sudo alien --scripts" the .rpm I get: error: incorrect format: unknown tag mkdir: cannot create directory `sqldeveloper-2.1.1.64.45': 


File exists unable to mkdir sqldeveloper-2.1.1.64.45: at /usr/share/perl5/Alien/Package.pm line 257.  
Basically, I'm asking, does anyone know what I'm doing wrong here? I've never used alien before since I've never had a need to convert a .rpm before. I also tried installing and running Java JDK and SQL Developer under Wine, but was unsuccessful with that as well :( Anyway, thanks for taking your time to read and (hopefully) help with this ;) 


Oh and I'm using Ubuntu 10.04 32bit, if that helps? 


; -->poltak July 22nd, 2010, 07:49 AM Ah, crud <-- [That's the name of the guy that created the post]. 
Managed to solve this problem with the help of another more-advanced-than-me linux user. 


Anyway, I'll write up how we got it sorted without needing to convert an rpm package to deb just so if anyone else has this same problem in the future and googles this or something... 
First make sure you have Java JDK installed. I used openjdk (open-source alternative to the official Sun Java jdk thingie). Download the "Oracle SQL Developer for other platforms" from the Oracle site (http://www.oracle.com/technology/software/products/sql/index.html)and then extract it into its own folder. 


Then in terminal, cd to the extracted directory and: sudo sh sqldeveloper.sh 
It'll ask you to type the pathname of your J2SE installation. 


Mine turned out to be "/usr/lib/jvm/java-6-openjdk". Then press enter and you should be right and it will boot up and work the exact same as it does under Windows or OS X. 


 Hopefully this helps another linux newbie out one day down the track :)"

This is the end result on my computer ..Finally working 
 :-)