Recently upgraded mysql to version 4.1.10, found a lot of questions:
1) Remote access;
Because the new version of the encryption algorithm is different, if the party will prompt if it adds a user to remote IP under the mysql-user table.
Client Does Not Support Authentication Protocol problem.
The whole process:
MySQL> grant all privileges on *. * to root @ "%" Identified by 'rootpp'
mysql> update mysql.user set password = Old_password ('rootpp') where host = '%' and user = 'root';
2) Character set;
Because there is no such problem at 4.1 below, it will cause a prompt when some of the field types of some tables are different.
ILLEGAL MIX of Collations (UTF8_GENERAL_CI, IMPLICIT) AND (Latin1_Swedish_ci, Coercible) for Operation 'Substr_index'
mistake.
This is if it is passed under the SQL command
MySQL> Show Full Column from table will find that the character set of the two fields is different.
Use
Alter Table `Tname` Change`s. Varchar (15) Character set latin1 not null.
(Suppose is changed to the character, and the character set category is latin1 latin1)
