Re: permissions in information_schema

> and tables (a view of only your stuff) > > Makes sense ??? > > Rolando A. Edwards > 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...

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,SELEC

Re: FLUSH LOCAL LOGS

Thanks Paul you opened my eyes !!! On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois 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.c

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: Queries not in Cache

Can somebody help me with this? Thanks! On Thu, May 6, 2010 at 10:39 AM, Darvin Denmian 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

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

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

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:http://lists.mys

Re: Logging all Access

> and it logs each SQL statement received from clients ..." > > 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 &

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 PROTECTE