Hello,
sorry for my english :-)
I've a db named "controlloscatole" on my PC which has IP: 192.168.50.195
I've created a user which hasn't generic privileges but he has
only SELECT privilege to "controlloscatole":
GRANT USAGE ON * . * TO "rep_ammin"@ "%"IDENTIFIED BY "***************"WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
REVOKE ALL PRIVILEGES ON `controlloscatole` . * FROM "rep_ammin"@ "%";
REVOKE GRANT OPTION ON `controlloscatole` . * FROM "rep_ammin"@ "%";
GRANT SELECT ON `controlloscatole` . * TO "rep_ammin"@ "%";
If i try to access to controlloscatole as rep_ammin:
* via MysqlCC
*host: localhost all is ok.
*host: 192.168.50.195 ERROR 2003: Can't connect on
192.168.50.195 (10061)
* via phpmyadmin
*http://localhost/mysql/ all is ok
*http://192.168.50.195/mysql/ ALL IS OK!!
* via ODBC
*host: localhost all is ok.
*host: 192.168.50.195 ERROR 2003: Can't connect on
192.168.50.195 (10061)
So if i try to connect to my db as rep_ammin from my PC i've no problem.
On the contrary nobody in my office can do that... via Access (ODBC) or MysqlCC.
Have you any idea to resolv my problem please?
Thank you very much :-)
PS I use mysql from easyphp on winXP...