Table 'mysql.proc' doesn't exist

[Vieri]

Levei o seguinte erro ao criar uma procedure.

Table 'mysql.proc' doesn't exist

pesquisando descobri que se trata de problema com privilégios(não enxergar a tabela) e/ou versão das tabelas de privilégios de sistema.

O seguinte link : http://dev.mysql.com/doc/refman/5.0/en/mys...ege-tables.html

demostra fazer um upgrade nestas tabelas, mas como comecei a mecher no mysql a alguns dias, mais precisamente 3 dias.

Apesar de ser um DBA experiente , fico com pé atrás.

minha versão: 5.0.34-enterprise-gpl bate com a do link.

alguém me da um apoio neste sentido?

[]s

[Denis Courcy]

Oi,'Vieri'!

O banco mysql é nativo do servidor de banco MySQL e é responsável pela guarda dos usuários, controles de acesso, etc.

Tem certeza que quer mexer aí?

[Vieri]

Caro amigo,

o problema é que não existe a tabela mysql.proc,

já atualizei o catalogo conforme o link mas não adiantou.

Agora me falaram que falata rodar um mysql upgrade , mas ele não encontra o mysql_check

Me falaram também que é caso de simplemente criar, a tabela proc na munheca.

trab hà 3 anos com Oracle... confesso que estou assutado com essa fragilidade do mysql,

caso não seja fragilidade, alguém pode dar uma luz do que seja.

[]s...

[Denis Courcy]

Oi, 'Vieri'

A tabela proc existe, sim, no banco mysql. É responsável pela guarda das storage procedures.

Sua estrutura é:

CREATE TABLE `proc` (                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
          `db` char(64) character set utf8 collate utf8_bin NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
          `name` char(64) NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
          `type` enum('FUNCTION','PROCEDURE') NOT NULL,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
          `specific_name` char(64) NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
          `language` enum('SQL') NOT NULL default 'SQL',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
          `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL default 'CONTAINS_SQL',                                                                                                                                                                                                                                                                                                                                                                                                                             
          `is_deterministic` enum('YES','NO') NOT NULL default 'NO',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
          `security_type` enum('INVOKER','DEFINER') NOT NULL default 'DEFINER',                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
          `param_list` blob NOT NULL,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
          `returns` char(64) NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
          `body` longblob NOT NULL,                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         
          `definer` char(77) character set utf8 collate utf8_bin NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
          `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,                                                                                                                                                                                                                                                                                                                                                                                                                                                               
          `modified` timestamp NOT NULL default '0000-00-00 00:00:00',                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
          `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE') NOT NULL default '',  
          `comment` char(64) character set utf8 collate utf8_bin NOT NULL default '',                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
          PRIMARY KEY  (`db`,`name`,`type`)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
        ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'