Turning on logging SQL-Commands

2002-05-06 Thread Thomas Schweikle
Hi! Can I turn on logging of all SQL-Commands send by one particular client on the server side? Turning on logging for all clients seems to be possible. Does it work for one client only too? -- Thomas - Before posting, plea

Grants, rights, permissions

2002-05-01 Thread Thomas Schweikle
Hi! I am having some trubble understanding, how permissions work with MySQL: I've set up user, database, and host permissions: User: Hosts:PW: Permissions: tps Any pwAll Anonymous 192.168.107.204 ''None Database: User: Hosts: Perm

Re: Remote access to MySQL

2002-03-16 Thread Thomas Schweikle
Hi! An: [EMAIL PROTECTED] Kopie: Thema: Remote access to MySQL > Thomas, show me the output of following statement: > SHOW GRANTS FOR 'your_user'@'your_host'; > +--+ | Grants for @10.2.107.0/255.255.255.0

Remote access to MySQL

2002-03-15 Thread Thomas Schweikle
Hi! I want to access various databases on a MySQL server remotely. I've set up an entry in the "mysql.user" table to allow access to mysql for all hosts in subnet 10.2.107.0/255.255.255.0. First this worked fine. Then my server moved from address 10.2.107.24 to 10.2.107.204. Now I do not have ac