While using MySQL connector/Net V6 and it's membership provider, the provider doesn't create tables it requires automaticly. After searching through internet, I got the solution. An extra attribute should be specified in order to create the schema automaticly.

More...

Today I was asked by my client to resize a text field in a MySql database. MySql provides an easy way to resize or modify any column in your table using alter table .. modify syntax. alter table Articles modify Title varchar (255) ;(table name and column names are changed!)Here the column `Title` from the table `Articles` is modified to a varchar of the length 255. Note: if the column's length was more than 255, all the values in the columns will be truncated to fit the current size. You can use this statement to modify any datatype, not just varchars.To verify that all went well, run the explain tablename command before and after executing the alter table modify statement.