Thread: mysql problem that i can't understand?

Results 1 to 4 of 4
  1. #1 mysql problem that i can't understand? 
    Middle Finger is Here


    Join Date
    Feb 2012
    Age
    31
    Posts
    2,546
    Thanks given
    377
    Thanks received
    502
    Rep Power
    162
    I was trying to connect to a remote mysql server,i was not able to connect to it as a result of which connection through my host IP address is blocked.

    This is the exception that i am getting java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'hosthere' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

    How do i use mysqladmin flush-hosts i am not able to understand.Where do i write it.Is it in the command prompt.Can anyone guide me.
    Hi
    Reply With Quote  
     

  2. #2  
    Donator
    nexusprime's Avatar
    Join Date
    Aug 2014
    Posts
    57
    Thanks given
    1
    Thanks received
    1
    Rep Power
    0
    You need to change the variable 'hosthere' to your either localhost if your hosting yourself (ie xampp) or if its a remote server add the ip of the remote server in 'hosthere'. Then login to the cPanel for your database host and add the IP address from your RsPs host (VPS or your own) to the list of allowed Remote MySQL connections (in cPanel)
    Reply With Quote  
     

  3. #3  
    Donator
    Jonasingame's Avatar
    Join Date
    Jan 2013
    Posts
    197
    Thanks given
    7
    Thanks received
    1
    Rep Power
    11
    Quote Originally Posted by Braveyy View Post
    I was trying to connect to a remote mysql server,i was not able to connect to it as a result of which connection through my host IP address is blocked.

    This is the exception that i am getting java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'hosthere' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

    How do i use mysqladmin flush-hosts i am not able to understand.Where do i write it.Is it in the command prompt.Can anyone guide me.
    mysqli_connect('Localhost', 'user', 'password', 'database');
    Reply With Quote  
     

  4. #4  
    Registered Member
    _Ali's Avatar
    Join Date
    Apr 2014
    Posts
    382
    Thanks given
    67
    Thanks received
    147
    Rep Power
    252
    Quote Originally Posted by Braveyy View Post
    I was trying to connect to a remote mysql server,i was not able to connect to it as a result of which connection through my host IP address is blocked.

    This is the exception that i am getting java.sql.SQLException: Data source rejected establishment of connection, message from server: "Host 'hosthere' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

    How do i use mysqladmin flush-hosts i am not able to understand.Where do i write it.Is it in the command prompt.Can anyone guide me.
    Let me know if you're still having problems.
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 2
    Last Post: 09-07-2014, 03:38 AM
  2. A problem that i dont understand..
    By flamehair9 in forum Models
    Replies: 4
    Last Post: 08-09-2012, 11:36 PM
  3. Replies: 11
    Last Post: 03-04-2009, 04:47 PM
  4. MySQL Problem
    By rmb7 in forum Help
    Replies: 1
    Last Post: 03-03-2009, 02:23 AM
  5. Replies: 25
    Last Post: 01-30-2009, 11:43 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •