MySQL for Excel: Export data to MySQL (max_allowed_packet and ODBC@localhost problems) -


hi i'm trying export data excel sheet mysql using mysql excel add-in, got error: packets larger max_allowed_packet not allowed. searched online , tried this: link; mysqld command gets executed, when run 'mysql --max_allowed_packet=32m' got error: access denied user 'odbc'@'localhost' (using password: no). following other posts tried mysql -u root -p. can enter password , prompt change this: mysql>. should do? inside prompt cannot run mysql --max_allowed_packet=32m, , if exit bin folder, running command still gives me access denied message.


Comments