Thank you for your reply, Adam.

I analysed your log files a little bit and I noticed something that may
be the root cause of your problems here.  Your DpkgTerminalLog.txt file
contains the following excerpt:

...
Paramétrage de mysql-server-8.0 (8.0.26-0ubuntu0.20.04.2) ...
mysqld: Error on realpath() on '/home/adamSQL/Documents' (Error 2 - No such 
file or directory)
mysqld will log errors to /var/log/mysql/error.log
Warning: Unable to start the server.
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
...

Note the "mysqld: Error on realpath() on '/home/adamSQL/Documents'
(Error 2 - No such file or directory)" message.  Upon inspecting your
mysql.cnf, I saw this line:

secure_file_priv = /home/adamSQL/Documents

The "secure_file_priv" option is used to limit the effect of data import
and export operations.  According to MySQL's manual:

If set to the name of a directory, the server limits import and export
operations to work only with files in that directory. The directory must
exist; the server does not create it.

In your case, the directory /home/adamSQL/Documents doesn't exist.

I am assuming that you explicitly added the "security_file_priv" option
to your mysql.cnf, and that you understand what it does.  It seems like
you just need to re-create the /home/adamSQL/Documents directory and try
to start the service again.

I am almost sure that this is not a bug but rather a local configuration
issue.  I will set the status to Incomplete again; feel free to revert
it back to New if/when you have more information about the issue.

Thank you.

** Changed in: mysql-8.0 (Ubuntu)
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1939395

Title:
  package mysql-server 8.0.26-0ubuntu0.20.04.2 failed to
  install/upgrade: circular symlink to configuration file

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1939395/+subscriptions


-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to