Query execute thread cannot connect to Mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • FNA access
    New Member
    • Jun 2007
    • 36

    #1

    Query execute thread cannot connect to Mysql

    Hello all,

    I am relitivley new to mySQL. I started by downloading from the mySQL site.
    I then downloaded mySQL administrator and mySQL Query browser.
    With my set up I got a user root with a specified password.

    I created a DB(school) . When I log into mySQL Query browser with root connection, I see all my tables etc. I even see the information_sch ema.
    I can select anything from anything.

    I set up a new user (student)that has select, update, insert, create, drop, delete privileges on my new DB(school).

    I created a table in school called courses and filled it with test data.

    I created a new connection called stuconnect for my user student

    When I log into query browser using student, I get into the query browser and I can see my school db, and courses table. I can however see the information_sch ema stuff to.

    (I don't like that, I don't want users to have access to that information)

    When I try and execute a query:

    [CODE=mysql]Select * from school.courses;[/CODE]

    I get the error :

    Query execute thread cannot connect to Mysql,

    Am I missing something ???

    Thanks in advance
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    Try executing this query on command line.

    Comment

    • Atli
      Recognized Expert Expert
      • Nov 2006
      • 5062

      #3
      Hi.

      All users can see the 'INFORMATION_SC HEMA' table. It contains details on everything that user has access to, like table and column information.
      It is different for each user, depending on what privileges he has been granted.

      Each user should not be able to see or change anything there unless he has been granted the privileges to do so by the normal SQL statements.

      Comment

      • FNA access
        New Member
        • Jun 2007
        • 36

        #4
        Sorry it took me so long to get back. Between work, school, and side projects I've been pretty busy.

        Thank you for the clarification on information schema table, that makes sense.

        I should have been able to figure that out myself.

        Thank goodness for you guys.

        Comment

        Working...