Turning on logging SQL-Commands
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, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Grants, rights, permissions
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: Permissions: duwtAnonymous Any All Databases: Hosts: Permissions: Any 192.168.107.0/24 All Now, if I understand correctly I might connect to database "duwt" as user "tps" from any host. But trying this I can't connect to database "duwt". Why? -- Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote access to MySQL
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 | +--+ | GRANT ALL PRIVILEGES ON *.* TO ''@'10.2.107.0/255.255.255.0' | +--+ 1 row in set (0.00 sec) -- Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote access to MySQL
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 access anymore to any of the databases except on the server itself accessing via localhost. Any idea how to bring this back to work to allow access to whole subnet 10.2.107.0/255.255.255.0 would be appreciated! -- Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php