Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Query Browser can't connect

Discussion in 'General Discussion' started by kingmoore, Dec 20, 2006.

  1. kingmoore

    kingmoore Member

    Joined:
    Dec 19, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Hello, I recently downloaded mySQL Query Browser 1.2.6b from the mySQL website and wanted to use it to test some things out on our webserver running WHM/cPanel.

    I am having problems connecting and I am not sure why. Here is the error message:

    I'm not sure what the issue is. I have gone into cPanel and said to allow access from host 125.236.%.%. My current IP falls under this range. Should the error message say I am trying to log in with the '%' wildcards in the username? That seems strange.

    I am running mySQL 4.0.27

    I checked to make sure I was using the correct mySQL port

    Does anyone else use this tool? Any ideas? Thanks
     
    #1 kingmoore, Dec 20, 2006
  2. nickp666

    nickp666 Well-Known Member

    Joined:
    Jan 28, 2005
    Messages:
    769
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    /dev/null
    does the user you are logging in as actually have rights over that database?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 nickp666, Dec 20, 2006
  3. kingmoore

    kingmoore Member

    Joined:
    Dec 19, 2006
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Yes, I am logging in with the same user/pass that I am using in my PHP scripts to connect.
     
    #3 kingmoore, Dec 20, 2006
  4. aralis

    aralis Member

    Joined:
    Dec 22, 2006
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    151
    Location:
    Lubbock TX
    MySQL only uses three methods of authentication:
    Permission, User/Pass, IP address.

    1. Check and make sure that you added a user and pass. double check them.
    2. Make sure that you added a Database.
    3. Make sure you added that user to that Database with full permissions.
    4. Make sure your IP address is in the access hosts.

    You seem you have the correct syntax for your IP address but go ahead and try putting it in again as your full IP without wildcards. If you check all of that and you still can't log in you are going to have to provide us more detail.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 aralis, Dec 26, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL Query Browser
  1. suganthanatwork

    Lost connection to MySQL server during query error

    suganthanatwork, Jan 25, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    799
    dave321
    Feb 1, 2018
  2. TragedyStruck

    SOLVED "Lost connection to MySQL server during query" with Python App

    TragedyStruck, Aug 11, 2017, in forum: Database Discussion
    Replies:
    3
    Views:
    4,930
    cPanelMichael
    Aug 28, 2017
  3. RobNH

    MySQLi - Too Many Connections Error due to Amazon AWS

    RobNH, Jun 21, 2018 at 7:47 AM, in forum: Database Discussion
    Replies:
    5
    Views:
    40
    Infopro
    Jun 21, 2018 at 10:03 AM
  4. geekbaaz

    Multiple cPanel servers with a common MySQL server?

    geekbaaz, Jun 21, 2018 at 3:24 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    56
    cPanelMichael
    Jun 21, 2018 at 11:32 AM
  5. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018 at 11:46 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    46
    cPanelMichael
    Jun 21, 2018 at 10:31 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice