<br /><path-to-mysql>/bin/mysql.exe -f --user=<username> --password="<password>" --host="<host>" mysql<br />ALTER TABLE user type=MyISAM;<br />ALTER TABLE db type=MyISAM;<br />ALTER TABLE host type=MyISAM;<br />ALTER TABLE func type=MyISAM;<br />ALTER TABLE columns_priv type=MyISAM;<br />ALTER TABLE tables_priv type=MyISAM;<br /><br />alter table user change password password char(16) NOT NULL;<br />alter table user add File_priv enum('N','Y') NOT NULL;<br /><br />CREATE TABLE if not exists func (<br /> name char(64) DEFAULT '' NOT NULL,<br /> ret tinyint(1) DEFAULT '0' NOT NULL,<br /> dl char(128) DEFAULT '' NOT NULL,<br /> type enum ('function','aggregate') NOT NULL,<br /> PRIMARY KEY (name)<br />);<br /><br />alter table user add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL;<br />alter table host add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL;<br />alter table db add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') NOT NULL,add Index_priv enum('N','Y') NOT NULL,add Alter_priv enum('N','Y') NOT NULL;<br /><br /># The statements below might generate errors - ignore them<br />UPDATE user SET Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv;<br />UPDATE db SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv;<br />UPDATE host SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv;<br /><br />ALTER TABLE user<br />ADD ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL,<br />ADD ssl_cipher BLOB NOT NULL,<br />ADD x509_issuer BLOB NOT NULL,<br />ADD x509_subject BLOB NOT NULL;<br />ALTER TABLE user MODIFY ssl_type enum('','ANY','X509', 'SPECIFIED') NOT NULL;<br /><br />CREATE TABLE IF NOT EXISTS tables_priv (<br /> Host char(60) DEFAULT '' NOT NULL,<br /> Db char(60) DEFAULT '' NOT NULL,<br /> User char(16) DEFAULT '' NOT NULL,<br /> Table_name char(60) DEFAULT '' NOT NULL,<br /> Grantor char(77) DEFAULT '' NOT NULL,<br /> Timestamp timestamp(14),<br /> Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL,<br /> Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,<br /> PRIMARY KEY (Host,Db,User,Table_name)<br />);<br />CREATE TABLE IF NOT EXISTS columns_priv (<br /> Host char(60) DEFAULT '' NOT NULL,<br /> Db char(60) DEFAULT '' NOT NULL,<br /> User char(16) DEFAULT '' NOT NULL,<br /> Table_name char(60) DEFAULT '' NOT NULL,<br /> Column_name char(59) DEFAULT '' NOT NULL,<br /> Timestamp timestamp(14),<br /> Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL,<br /> PRIMARY KEY (Host,Db,User,Table_name,Column_name)<br />);<br /><br /><br />ALTER TABLE columns_priv change Type Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL;<br /><br />alter table func add type enum ('function','aggregate') NOT NULL;<br /><br />alter table user<br />add Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER alter_priv,<br />add Super_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Show_db_priv,<br />add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Super_priv,<br />add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Create_tmp_table_priv,<br />add Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Lock_tables_priv,<br />add Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Execute_priv,<br />add Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Repl_slave_priv;<br /><br /># The statements below might generate errors - ignore them<br />update user set show_db_priv= select_priv, super_priv=process_priv, execute_priv=process_priv, create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=file_priv where user<>"";<br /><br />alter table user<br />add max_questions int(11) NOT NULL AFTER x509_subject,<br />add max_updates int(11) unsigned NOT NULL AFTER max_questions,<br />add max_connections int(11) unsigned NOT NULL AFTER max_updates;<br /><br />alter table db<br />add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,<br />add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL;<br />alter table host<br />add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL,<br />add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL;<br />
