Hi list, I've a question about the database privilege and the Mysql.db table. If i do something like this : GRANT SELECT ON MYDB.* TO [EMAIL PROTECTED]; ( i'm using MyISAM tables ... ) And if MYDB contains something like 100 tables, could this make me problems ?
In fact, i have errors like this : Failed to connect to database: 1044 Error: Access denied for user: '[EMAIL PROTECTED]' to database 'MYDB' 2006 : MySQL server has gone away All is working well, except sometimes i have such errors each day during a small period of time and all is going back well later ... I see that restarting the serveur could help me but i don't know why ... All connections are through TCP / IP on a private 100Mb LAN. Extract of my.cnf : [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve skip-host-cache [...] Here : http://www.mysql.com/doc/en/Access_denied.html I've find something : << Another reason for this error on Linux is that you are using a binary MySQL version that is compiled with a different glibc version than the one you are using >> It's true, i'm using mysql-3.23.54a-pc-linux-i686.tar.gz and the system is Red Hat 7.2 with red hat buggy glibc. This could be my problem ? Please, i need to solve my problem ... Perhaps i'm not alone having this problem ... Did someone hear ( and understand ) me ? Thanks David --------------------------------------------------------------------- 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
