INNODB database size

2006-04-25 Thread Todd Smith
Hello I have inherited an INNODB database. I am new to MySQL and may not be describing my problem correctly so any suggestions or questions are welcome. I have data files named ib_data_00 through ib_data_14 all of which are 2.0G. I also have ib_data_15 which is 26G. I am receiving errors saying

Show Grants problem

2006-04-13 Thread Todd Smith
Hello Does anyone know why a user would show up in a select from user query but not in a show grants command. What I am trying to say is I tried SHOW GRANTS FOR 'user1'@'%' and received that there is no such grant defined for 'user1'... But when I run SELECT * FROM user WHERE User =