Friday 15 August 2014
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:
to:Code:bind-address = 127.0.0.1
make sure mysql is running:Code:#bind-address = 127.0.0.1
if not, start it:Code:/etc/init.d/mysql status
check if the ubuntu firewall is runningCode:/etc/init.d/mysql start
if it is, allow mysqlCode:sudo ufw status
Code:sudo ufw allow mysql
Possibly a security precaution. You could try adding a new administrator account:
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”. |
Tuesday 8 July 2014
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 !!...
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 !!...
Friday 13 June 2014
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.
#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.
Tuesday 22 April 2014
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 :)
Subscribe to:
Posts (Atom)
How to Create a Ansible Lab on your Local Machine using Vagrant in 5 min using ChatGPT
This is an exciting experiment of mine as DevOps. As I am experimenting with the Tools available ... So, the quest is to " Vagrantfile ...
-
How To Hide and unhide the hard disk Volumes using CMD Commands : First check how many drives are there in my computer and then s...
-
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...
-
Issue: You go to activate Microsoft Office 2010 and you receive a message stating, “Your copy of Microsoft Office Professional Plus 2010 ca...