Filezilla - Response:530 Sorry, the maximum number of clients (n) from your host are already connected

Filezilla - Response:530 Sorry, the maximum number of clients (n) from your host are already connected

Solution 1 - 
Open filezilla.
File -> site manager -> select your 'My Sites' entry -> transfer settings -> uncheck the check box "Limit number of simultaneous connections"

Try again.

Solution 2 -
Close all connections of same site. Do not open multiple filezilla instances for same site.

Restart filezilla.

Create mysql user for remote host log in

Log into mysql server from remote host

I am showing you a method to create mysql user for remote login.

I am going to give it all privileges so be careful. The details should not be given in wrong hands.

Create a user using following commands. Select any username and any password of your choice.

mysql> GRANT USAGE ON *.* TO 'new-username'@'%' IDENTIFIED BY 'new-password';

Now run this command. Use same username and password which you used in above command.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'above-username'@'%' IDENTIFIED BY 'above-password' WITH GRANT OPTION;

Restart mysql.

Suppose my username is elex and password is linuxamination. My system's IP is 192.168.1.7. Now another user of my LAN whose IP is 192.168.1.8 wants to connect to my system's mysql server.

The other user should open it's terminal and run following command.

# mysql -h 192.168.1.7 -u elex -p'linuxamination'

Now 1.8 is  logged into my mysql server. Since user elex has full privileges so 1.8 can update/drop any database.

ERROR 1130 (HY000): Host is not allowed to connect to this MySQL server

ERROR 1130 (HY000): Host is not allowed to connect to this MySQL server

If you are trying to log into mysql server of remote host and you are getting this error, there can be several reasons that you are getting this.

1) You can not log in with blank/No password on remote host  otherwise it gives following error

ERROR 1045 (28000): Access denied for user 'username'@'hostname' (using password: NO)
Generally root account does not have password and you use blank password to log into root account but there must be a password to log into remote host mysql server.
Do not change it with no password attribute just like your localhost. It is very important that remote host must have mysql password otherwise it would be biggest security loop hole.

2) If you have created new user and you have set password for it. Now it is time to check hostname. If you are logging into mysql server of remote host, you must be using IP for it's hostname. If hostname is localhost, you can not log into the mysql server. This host name is for users of the server, it is not for remote host.

3)  If hostname is IP of the server, still you can not log into the mysql server. This host name is for users of the server, still it is not for remote host.

4) Port 3306 should be opened on remote host and if server is RHEL, Fedora, CentOS or similar one. The port should be defined in IP table rules.

Host name should be '%' as well as username and password both should be defined for the host name or you can say A user should have host name '%' to log into mysql server on remote host.

Now you can log into mysql server on remote host using IP.

Set the proper permission(create/drop database, create/drop table etc) for this user using 

privileges options.

click on the image for readable view.

In this example, username is admin101 & admin11, password is admin and hostname is %. Now anyone can log in from remote host into this mysql server using IP as a hostname and above given username & password.

Be careful about privileges. User can misuse if you are not careful enough.

# mysql -h 192.168.1.7 -u admin101 -p'admin'

where 192.168.1.7 is IP of the remote server

admin101 is username of mysql user on remote host

admin is password for this user.

There is no space between -p & '

For mysql remote login, Read this.