Movatterモバイル変換

If problems occur, such as that the newmysqld server does not start, verify that you do not have an oldmy.cnf file from your previous installation. You can check this with the--print-defaults option (for example,mysqld --print-defaults). If this command displays anything other than the program name, you have an activemy.cnf file that affects server or client operation.

If, after an upgrade, you experience problems with compiled client programs, such asCommands out of sync or unexpected core dumps, you probably have used old header or library files when compiling your programs. In this case, check the date for yourmysql.h file andlibmysqlclient.a library to verify that they are from the new MySQL distribution. If not, recompile your programs with the new headers and libraries. Recompilation might also be necessary for programs compiled against the shared client library if the library major version number has changed (for example, fromlibmysqlclient.so.15 tolibmysqlclient.so.16).

If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, useDROP FUNCTION to drop the loadable function, and then useCREATE FUNCTION to re-create the loadable function with a different nonconflicting name. The same is true if the new version of MySQL implements a built-in function with the same name as an existing stored function. SeeSection 9.2.5, “Function Name Parsing and Resolution”, for the rules describing how the server interprets references to different kinds of functions.