Ubuntu Server Running MySQL 5.7 Errors on Plugin Starting

(Doc ID 2240736.1)

Last updated on MARCH 06, 2017

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.


On : 5.7 version, Error Messages

When attempting to start the MySQL Server,
the following error occurs.

017-02-22T14:44:57.983057-06:00 0 [Note] Execution of init_file '/var/lib/mysql-files/rX8rJCm6rl' started.
2017-02-22T14:44:57.984084-06:00 2 [ERROR] 1125 Function 'auth_socket' already exists
2017-02-22T14:44:57.984248-06:00 0 [Note] Execution of init_file '/var/lib/mysql-files/rX8rJCm6rl' ended.

The issue can be reproduced at will with the following steps:
1. Install packages on Debian system
2. Move data to a non-standard path e.g. /opt/mysqldata
3. Attempt to restart MySQL service with the system startup scripts

The issue has the following business impact:
Due to this issue, users cannot effectively manage the service through standard administration scripts and practices.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms