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:
Expand|Select|Wrap|Line Numbers
- Select * from school.courses;
Query execute thread cannot connect to Mysql,
Am I missing something ???
Thanks in advance