asp.net - Cannot create a stored procedure using MySQL -

so may little vague i'm running layer after layer of problems here. each "fix" find on google presents me problem. laying things out anyway, i've bought windows hosting package in order produce asp.net application backed mysql server. i'm used mssql should workable , nicer open source.

the first problem noticed (recently installed) copy of mysql workbench mysql server 5.7 not let me connect db whatsoever. tables refuse load , greeted with: #1548 - cannot load mysql.proc. table corrupted

from there, thought "ok that's fine, i'll use web admin tool" in case phpmyadmin. have 0 experience phpmyadmin in past looks ok , preinstalled in control panel. started off creating first 5 tables. went smoothly , have 5 tables in database, 1 of them has data may view running "select * account_type".

all seems good, go create procedure i'm want use in order test application. procedure return string based on tinyint user enters. procedure looks this:

drop procedure if exists `getaccounttypename`; delimiter $$ create procedure `getaccounttypename`(dimaccounttypeid) begin  declare dimaccounttypeid tinyint default 0  select accounttypename account_type accounttypeid = dimaccounttypeid  end $$  delimiter ; 

seems fine me (being more experienced ms sql) returns same error own local copy of mysql workbench did! cannot load mysql.proc. table corrupted

everything read on internet points being issue need upgrade mysql.... have no idea how upgrade seeing in control panel here. instead feel there must other issue, tables have data still show data , created them yesterday, don't see how of corrupted.

i tried looking @ using

use mysql; show create table mysql.proc; 

as i've seen suggested, returns error of: #1044 - access denied user 'birdy'@'%' database 'mysql' (birdy username). don't know if source of problems, can run other query sans create procedure fine.

next thought here "hey if can mysql workbench connect , work can ignore control panel". isn't fruitful either, here attempts @ running upgrade commands: http://i.imgur.com/yg1hkrq.png (for passsword, should using windows one? mysql birdy username password? not sure which...)

the real question here anyway pretty "help!". source of problem "cannot create mysql query using phpmyadmin" though , little story here should diagnose that. appreciate these issues :)

edit: got mysql_upgrade run still, no dice. doesn't fix problems, still looks this: http://i.imgur.com/njpnrzw.png

edit 2: i'm giving on now, switching db on mssql , sticking know best. reinstalling db wasn't helpful , neither upgrade web hosts. anyway guys

connect mysql server root user, drop table proc , create one:

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` longblob not null,   `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','no_engine_substitution','pad_char_to_full_length') not null default '',   `comment` text character set utf8 collate utf8_bin not null,   `character_set_client` char(32) character set utf8 collate utf8_bin default null,   `collation_connection` char(32) character set utf8 collate utf8_bin default null,   `db_collation` char(32) character set utf8 collate utf8_bin default null,   `body_utf8` longblob,   primary key (`db`,`name`,`type`) ) engine=myisam default charset=utf8 comment='stored procedures'