permissions in information_schema

Can somebody tell me why the last command bellow doesn't works? mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql GRANT SUPER,REPLICATION CLIENT,SELECT

Re: permissions in information_schema

MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Darvin Denmian [mailto:darvin.denm

FLUSH LOCAL LOGS

Hello ! Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: FLUSH LOCAL LOGS

Thanks Paul you opened my eyes !!! On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois paul.dub...@oracle.com wrote: On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote: Hello ! Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ? Yes. http://dev.mysql.com/doc/refman/5.1/en

Re: Queries not in Cache

Can somebody help me with this? Thanks! On Thu, May 6, 2010 at 10:39 AM, Darvin Denmian darvin.denm...@gmail.com wrote: Hello, I've activated the query_cache in Mysql with the variable query_cache_limit value to 1 MB. My question is: How to know what queries wasn't cached because

Queries not in Cache

Hello, I've activated the query_cache in Mysql with the variable query_cache_limit value to 1 MB. My question is: How to know what queries wasn't cached because they have exceeded the value of query_cache_limit? **Sorry for my Brazilian Englihs :( Thanks! -- MySQL General Mailing List For

Innodb Update_time

Hello List, how can i get table update_time using innodb engine? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Comparing Data

Hello, i need to know : there is a way to compare data between Mysql Master and Mysql Slave. We had some problems with replication and do not know if the data is intact. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Comparing Data

Thanks Craig, i'll test this tool. On Thu, Dec 11, 2008 at 12:54 PM, Craig Dunn [EMAIL PROTECTED] wrote: Darvin Denmian wrote: Hello, i need to know : there is a way to compare data between Mysql Master and Mysql Slave. We had some problems with replication and do not know if the data

Logging all Access

I wonder if there is the possibility of registering the users' access to the server Mysql. Something similar to the command last of Unix-like systems. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Logging all Access

... Regards, Andy Darvin Denmian wrote: I wonder if there is the possibility of registering the users' access to the server Mysql. Something similar to the command last of Unix-like systems. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql