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 Edit MySQL connection Error

    Cannot connect to MySQL server over network

Check /etc/my.cnf and make sure you are listening for outside connections. edit the line that starts with bind-address

change:

Code:

bind-address = 127.0.0.1

to:

Code:

#bind-address = 127.0.0.1

make sure mysql is running:

Code:

/etc/init.d/mysql status

if not, start it:

Code:

/etc/init.d/mysql start

check if the ubuntu firewall is running

Code:

sudo ufw status

if it is, allow mysql

Code:

sudo ufw allow mysql

    **************************************************************************

Possibly a security precaution. You could try adding a new administrator account: mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> WITH GRANT OPTION; mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> WITH GRANT OPTION; Although as Pascal and others have noted it's not a great idea to have a user with this kind of access open to any IP. If you need an administrative user, use root, and leave it on localhost. For any other action specify exactly the privileges you need and limit the accessibility of the user as Pascal has suggest below. From the MySQL FAQ: If you cannot figure out why you get Access denied, remove from the user table all entries that have Host values containing wildcards (entries that contain '%' or '_' characters). A very common error is to insert a new entry with Host='%' and User='some_user', thinking that this allows you to specify localhost to connect from the same machine. The reason that this does not work is that the default privileges include an entry with Host='localhost' and User=''.  Because that entry has a Host value 'localhost' that is more specific than '%', it is used in preference to the new entry when connecting from localhost! The correct procedure is to insert a second entry with Host='localhost' and User='some_user', or to delete the entry with Host='localhost' and User=''. After deleting the entry, remember to issue a FLUSH PRIVILEGES statement to reload the grant tables. See also Section 5.4.4, “Access Control, Stage 1: Connection Verification”.

Having Problems to restart uBuntu 12.04 LTS workstation

Yesterday I have installed Ubuntu 12.04 on one of my testing workstations, orignally it came with Windows 7 pre-installed 2 SSD disks in a fake software Raid...

I have totatly removed Windows 7, deleted the partition and installed Ubuntu 12.04 LTS .. But, after installing Ubuntu the machine boots but do not show any signal of ubuntu ..

Its just a dark screen .. I tried to use live CD to repair the grub but with not avail...

Here is what I have from Ubuntu Boot repair tool --- >> I have taken off the script and guide to troubleshoot the ubuntu bootup, instead, I have place them into a file and you can download from and read it locally

Its hosted on Google drive here please download it !!... 

How to Install vsftpd on Ubuntu and Add New User

Warning: FTP is inherently insecure. If you must use FTP, consider securing your FTP connection with SSL/TLS. Otherwise, it is best to use SFTP, a secure alternative to FTP.

The first two letters of vsftpd stand for "very secure" and the program was built to have strongest protection against possible FTP vulnerabilities.

Step One—Install vsftpd

You can quickly install vsftpd on your virtual private server in the command line:

sudo apt-get install vsftpd

Once the file finishes downloading, the VSFTP will be on your droplet. Generally speaking, it is already configured with a reasonable amount of security. However, it does provide access on your VPS to anonymous users.

Step Two—Configure vsftpd

Once vsftpd is installed, you can adjust the configuration.

Open up the configuration file:

sudo nano /etc/vsftpd.conf

The biggest change you need to make is to switch the Anonymous_enable from YES to NO:

anonymous_enable=NO

Prior to this change, vsftpd allowed anonymous, unidentified users to access the server's files. This is useful if you are seeking to distribute information widely, but may be considered a serious security issue in most other cases.

After that, uncomment the local_enable option, changing it to yes and, additionally, allow the user to write to the directory.

local_enable=YES

write_enable=YES

Finish up by uncommenting command to chroot_local_user. When this line is set to Yes, all the local users will be jailed within their chroot and will be denied access to any other part of the server.

chroot_local_user=YES

Save and Exit that file.

Because of a recent vsftpd upgrade, vsftpd is "refusing to run with writable root inside chroot". A handy way to address this issue to is to take the following steps:

Create a new directory within the user's home directory

mkdir /home/username/files

Change the ownership of that file to root

chown root:root /home/username

Make all necessary changes within the "files" subdirectory

Then, as always, restart:

sudo service vsftpd restart

Step Three—Access the FTP server

Once you have installed the FTP server and configured it to your liking, you can now access it.

You can reach an FTP server in the browser by typing the domain name into the address bar and logging in with the appropriate ID. Keep in mind, you will only be able to access the user's home directory.

ftp://example.com

Alternatively, you can reach the FTP server on your virtual server through the command line by typing:

ftp example.com

Then you can use the word, "exit," to get out of the FTP shell.

Adding New Users To vsftpd

I found it rather strange that there arent any good tutorial that can explain how to add new users to vftpd. Google gives few results but most of them are trial and error method. So i decided to write this post after spending 1 hr trying to accomplish this simple task.

#edit /etc/vsftpd.conf or /opt/etc/vsftpd.conf
Open the vsftpd.conf file and search for chroot_list_enable=YES
Make sure it is YES. Do the same for the following variables
chroot_list_file=/etc/vsftpd.chroot_list or /opt/etc/vsftpd.chroot_list
chroot_list_enable=YES
Save and close the file

Create vsftpd.chroot_list in /etc/ or /opt/etc/
Add the username you want to export to ftp.
IMP: The user must already be a system user with a valid passwd. You must be able to find /home/
If the user you want to add is not a system user then create that user first before editing the above file.
#adduser 
#passwd 

Restart the vsftpd server using /etc/init.d/vsftpd restart or service vsftpd restart
Now you can log into ftp using the new user.

Read Media .vob Files on Ubuntu

Finally I figured out how to do it. These are the steps:

• Create a subdirectory called VIDEO_TS and move all files there.
• Create an DVD ISO file by executing:

genisoimage -iso-level 1 -dvd-video -volset-size 1 -o output.iso root_folder

• Mount the DVD ISO by executing:

sudo mount -t iso9660 -o loop output.iso /media/cd/

The result will be a compatible ISO image which can be played using any video player (Totem, MPlayer, Dragon, etc.).

For those ones who are too ubuntufied, you can use K3B to create a DVD project and select "Create image only" before burn it.

Anyway, thanks for the answers. This site is too different from what I was used to in StackOverflow though, I have to say. It seems that some of you just read the title of the questions before answering. Maybe my English is too bad :)

How to Change Office 2010 License Key

Issue: You go to activate Microsoft Office 2010 and you receive a message stating, “Your copy of Microsoft Office Professional Plus 2010 cannot be activated because the specified Product Key has already been activated the maximum number of times permitted for your software license as specified in the Microsoft Software License Terms.”

The solution is to change the product key to another product key. I will show you three different methods of changing the License Key

Method 1

Open “regedit”

Navigate the registry to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Registration\ and delete the whole “Registration” key located under the “14.0″ key

Right click “Registration”

Select “Delete”

Press “Yes”

Close Regedit, Restart an Office 2010 application. You should be prompted to reenter your License Key

Method 2

Open to Microsoft Word

Press “File”

Press “Help”

Select “Change Product Key” (this option was not here on my installation, I used Method 1)

Method 3

Click on Start Menu > Control Panel > Programs and Features (or Add/Remove Programs, depending on your operating system).

Click on your product, e.g. Microsoft Office Professional Plus 2010

Click “Change” on the top menu.

Select the option to “Enter a Product Key.”

Press “Continue”

Changing your Product Key

Once you complete one of the Methods listed above you should be able to change your Product Key

Enter the appropriate product key from the top of this page and click “Continue.”

Accept the agreement

Press “Continue”

Configuration will occur

Press “Close”

Select “I want to activate the software over the Internet (recommended)”

Press “Next”

Your product should activate successfully

Press “Close”

OpenVPN Client Configuration on Ubuntu 12.04

OpenVPN Client Configuration on Ubuntu 12.04

To use the Ubuntu as OpenVPN client, install these packages:

sudo apt-get install network-manager-openvpn

sudo apt-get install network-manager-openvpn-gnome

Select the “Edit Connections” from Network Manager GUI:

From the VPN tab, click on ‘Add‘ button:

Select OpenVPN as the VPN Connection Type and press “Create“:

Enter all the required information like OpenVPN’s server ip address/name as the “Gateway“, “Type” to “Certificates (TLS)“, locate and point your “User Certificate” , “CA Certificate“ and “Private Key“. Also click on “Advanced” button:

Enable compression or other special settings as per your requirement:

Connect to the VPN:

If everything go well, it will show you the success message:

Check your interface configuration, you will find one new interface named “tun0” something:

ifconfig

Hope this will help you!