Error installing MySQL

Asked by Luis M.Jacinto

Ubuntu 22.04

After Installing MySQL in Terminal and run got this error:
luis@l-System-luisj:~$ sudo mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
luis@l-System-luisj:~$sudo systemctl start mysql.service
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.
luis@l-System-luisj:~$

Please help to correct this
Thank you

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Solved by:
Luis M.Jacinto
Solved:
Last query:
Last reply:
Revision history for this message
Manfred Hampl (m-hampl) said :
#1

What about following the instructions given:

See "systemctl status mysql.service" and "journalctl -xeu mysql.service" for details.

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#2

Following the instructions the result follows keeps repeat the same send only part.
I don’t understand what it means need help to correct what is wrong.

luis@l-System-luisj:~$ systemctl status mysql.service
× mysql.service - MySQL Community Server
     Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Wed 2023-02-22 09:29:04 SAST; 2h 37min ago
    Process: 23819 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 23827 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
   Main PID: 23827 (code=exited, status=1/FAILURE)
     Status: "Server shutdown complete"
      Error: 2 (No such file or directory)
        CPU: 290ms

Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Feb 22 09:29:04 l-System-luisj systemd[1]: Stopped MySQL Community Server.
Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Start request repeated too quickly.
Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 22 09:29:04 l-System-luisj systemd[1]: Failed to start MySQL Community Server.
luis@l-System-luisj:~$ journalctl -xeu mysql.service
Feb 22 09:29:04 l-System-luisj systemd[1]: Stopped MySQL Community Server.
░░ Subject: A stop job for unit mysql.service has finished
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A stop job for unit mysql.service has finished.
░░
░░ The job identifier is 5868 and the job result is done.
Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Start request repeated too quickly.
Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'.
Feb 22 09:29:04 l-System-luisj systemd[1]: Failed to start MySQL Community Server.
░░ Subject: A start job for unit mysql.service has failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A start job for unit mysql.service has finished with a failure.
░░
░░ The job identifier is 5868 and the job result is failed.
lines 807-829/829 (END)
Feb 22 09:29:04 l-System-luisj systemd[1]: Stopped MySQL Community Server.
░░ Subject: A stop job for unit mysql.service has finished
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A stop job for unit mysql.service has finished.
░░
░░ The job identifier is 5868 and the job result is done.
Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Start request repeated too quickly.
Feb 22 09:29:04 l-System-luisj systemd[1]: mysql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'.
Feb 22 09:29:04 l-System-luisj systemd[1]: Failed to start MySQL Community Server.
░░ Subject: A start job for unit mysql.service has failed
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A start job for unit mysql.service has finished with a failure.
░░
░░ The job identifier is 5868 and the job result is failed.

Revision history for this message
Manfred Hampl (m-hampl) said :
#3

Are you sure that the configuration of the mySQL server is correct?

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#4

I never configure mySQL it was just after installing and run sudo mysql that the error come.

Revision history for this message
Bernard Stafford (bernard010) said :
#5
Revision history for this message
Luis M.Jacinto (ljacinto) said :
#6

I follow the suggestion but nothing come correct still got problems
Mysql is not installed but something stops the installation.
Is there something can help this be fixed

luis@l-System-luisj:~$ sudo apt install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mysql-server-8.0 : Depends: mysql-server-core-8.0 (= 8.0.28-0ubuntu4) but 8.0.32-0ubuntu0.22.04.2 is to be installed
                    Recommends: libhtml-template-perl but it is not going to be installed
                    Recommends: mecab-ipadic-utf8 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
luis@l-System-luisj:~$ sudo service mysql status
Unit mysql.service could not be found.
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#7

For diagnostic purposes, what is the output of the commands

uname -a
lsb_release -crid
sudo dpkg --audit
apt policy mysql-server-8.0 mysql-server-core-8.0 libhtml-template-perl mecab-ipadic-utf8
apt --simulate install libhtml-template-perl mecab-ipadic-utf8

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#8

luis@l-System-luisj:~$ uname -a
Linux l-System-luisj 5.19.0-32-generic #33~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Mon Jan 30 17:03:34 UTC 2 x86_64 x86_64 x86_64 GNU/Linux
luis@l-System-luisj:~$ lsb_release -crid
Distributor ID: Ubuntu
Description: Ubuntu 22.04.2 LTS
Release: 22.04
Codename: jammy
luis@l-System-luisj:~$ sudo dpkg --audit
[sudo] password for luis:
luis@l-System-luisj:~$ apt policy mysql-server-8.0 mysql-server-core-8.0 libhtml-template-perl mecab-ipadic-utf8
mysql-server-8.0:
  Installed: (none)
  Candidate: 8.0.28-0ubuntu4
  Version table:
     8.0.28-0ubuntu4 500
        500 http://ftp.belnet.be/ubuntu jammy/main amd64 Packages
mysql-server-core-8.0:
  Installed: 8.0.32-0ubuntu0.22.04.2
  Candidate: 8.0.32-0ubuntu0.22.04.2
  Version table:
 *** 8.0.32-0ubuntu0.22.04.2 100
        100 /var/lib/dpkg/status
     8.0.28-0ubuntu4 500
        500 http://ftp.belnet.be/ubuntu jammy/main amd64 Packages
libhtml-template-perl:
  Installed: (none)
  Candidate: 2.97-1.1
  Version table:
     2.97-1.1 500
        500 http://ftp.belnet.be/ubuntu jammy/main amd64 Packages
        500 http://ftp.belnet.be/ubuntu jammy/main i386 Packages
mecab-ipadic-utf8:
  Installed: (none)
  Candidate: 2.7.0-20070801+main-3
  Version table:
     2.7.0-20070801+main-3 500
        500 http://ftp.belnet.be/ubuntu jammy/main amd64 Packages
        500 http://ftp.belnet.be/ubuntu jammy/main i386 Packages
luis@l-System-luisj:~$ apt --simulate install libhtml-template-perl mecab-ipadic-utf8
NOTE: This is only a simulation!
      apt needs root privileges for real execution.
      Keep also in mind that locking is deactivated,
      so don't depend on the relevance to the real current situation!
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl mecab-ipadic mecab-utils
Suggested packages:
  libipc-sharedcache-perl
The following NEW packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl mecab-ipadic mecab-ipadic-utf8 mecab-utils
0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
Inst libcgi-pm-perl (4.54-1 Ubuntu:22.04/jammy [all])
Inst libfcgi0ldbl (2.4.2-2build2 Ubuntu:22.04/jammy [amd64])
Inst libfcgi-perl (0.82+ds-1build1 Ubuntu:22.04/jammy [amd64])
Inst libcgi-fast-perl (1:2.15-1 Ubuntu:22.04/jammy [all])
Inst libfcgi-bin (2.4.2-2build2 Ubuntu:22.04/jammy [amd64])
Inst libhtml-template-perl (2.97-1.1 Ubuntu:22.04/jammy [all])
Inst mecab-utils (0.996-14build9 Ubuntu:22.04/jammy [amd64])
Inst mecab-ipadic (2.7.0-20070801+main-3 Ubuntu:22.04/jammy [all])
Inst mecab-ipadic-utf8 (2.7.0-20070801+main-3 Ubuntu:22.04/jammy [all])
Conf libcgi-pm-perl (4.54-1 Ubuntu:22.04/jammy [all])
Conf libfcgi0ldbl (2.4.2-2build2 Ubuntu:22.04/jammy [amd64])
Conf libfcgi-perl (0.82+ds-1build1 Ubuntu:22.04/jammy [amd64])
Conf libcgi-fast-perl (1:2.15-1 Ubuntu:22.04/jammy [all])
Conf libfcgi-bin (2.4.2-2build2 Ubuntu:22.04/jammy [amd64])
Conf libhtml-template-perl (2.97-1.1 Ubuntu:22.04/jammy [all])
Conf mecab-utils (0.996-14build9 Ubuntu:22.04/jammy [amd64])
Conf mecab-ipadic (2.7.0-20070801+main-3 Ubuntu:22.04/jammy [all])
Conf mecab-ipadic-utf8 (2.7.0-20070801+main-3 Ubuntu:22.04/jammy [all])
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#9

mysql-server-core-8.0:
  Installed: 8.0.32-0ubuntu0.22.04.2
  Candidate: 8.0.32-0ubuntu0.22.04.2
  Version table:
 *** 8.0.32-0ubuntu0.22.04.2 100
        100 /var/lib/dpkg/status
     8.0.28-0ubuntu4 500
        500 http://ftp.belnet.be/ubuntu jammy/main amd64 Packages

It seems that you are missing "jammy-updates" and "jammy-security" in your list of repositories (eventually also "jammy-backports").

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#10

There no "jammy-security” or "jammy-backports" in Repositories.
Need help how to insert these two.

Revision history for this message
Manfred Hampl (m-hampl) said :
#11

Open Update-manager and click on settings (or run the command software-properties-gtk) and switch to the "updates" tab.
What do you see there?

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#12

I took a screenshot don’t know how to add here.

Revision history for this message
Manfred Hampl (m-hampl) said :
#13

There is no need for posting a screen shot, just tell whether you see "jammy-security” and "jammy-backports" on that screen

In comment #10 you wrote 'There no "jammy-security” or "jammy-backports" in Repositories.'

You should enable these repositories (and eventually also "jammy-backports").

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#14

Now I am confused.
In Update-manager "updates" tab read from the top:
Snap package updates are checked routinely and installed automatically
Foe other packages, list system has: Basic Security Maintenance
     Active until 21/04/2027
There is nothing refer to “jammy-security” or "jammy-backports"

In Other Software the entry's it ends /”jammy main” and /”jammy main (Sourece Code)”.
Again there no reference to “jammy-security” or "jammy-backports"

Revision history for this message
Manfred Hampl (m-hampl) said :
#15

You are right. I was not aware that this function has been removed in the newest version of software-properties-gtk (which I hadn't installed on my own system yet).

I suggest adding the jammy-updates and jammy-security repositories manually.

What is the output of the command

cat -n /etc/apt/sources.list

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#16

luis@l-System-luisj:~$ cat -n /etc/apt/sources.list
     1 deb http://ftp.belnet.be/ubuntu/ jammy main universe restricted multiverse
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#17

What happened to your sources.list file? It should be about 50 lines! Did you modify it on purpose? Why?

Revision history for this message
Manfred Hampl (m-hampl) said :
#18

In which part of the world are you located?
Your user settings in launchpad tell about South Africa, but the server in your current sources.list file is in Belgium.

A typical sources.list file (for South Africa) looks like this:

# deb cdrom:[Ubuntu 20.04.4 LTS _Focal Fossa_ - Release amd64 (20220223)]/ focal main restricted

# See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
# newer versions of the distribution.
deb http://za.archive.ubuntu.com/ubuntu/ jammy main restricted
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy main restricted

## Major bug fix updates produced after the final release of the
## distribution.
deb http://za.archive.ubuntu.com/ubuntu/ jammy-updates main restricted
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy-updates main restricted

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team. Also, please note that software in universe WILL NOT receive any
## review or updates from the Ubuntu security team.
deb http://za.archive.ubuntu.com/ubuntu/ jammy universe
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy universe
deb http://za.archive.ubuntu.com/ubuntu/ jammy-updates universe
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy-updates universe

## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
## team, and may not be under a free licence. Please satisfy yourself as to
## your rights to use the software. Also, please note that software in
## multiverse WILL NOT receive any review or updates from the Ubuntu
## security team.
deb http://za.archive.ubuntu.com/ubuntu/ jammy multiverse
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy multiverse
deb http://za.archive.ubuntu.com/ubuntu/ jammy-updates multiverse
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy-updates multiverse

## N.B. software from this repository may not have been tested as
## extensively as that contained in the main release, although it includes
## newer versions of some applications which may provide useful features.
## Also, please note that software in backports WILL NOT receive any review
## or updates from the Ubuntu security team.
deb http://za.archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse
# deb-src http://za.archive.ubuntu.com/ubuntu/ jammy-backports main restricted universe multiverse

## Uncomment the following two lines to add software from Canonical's
## 'partner' repository.
## This software is not part of Ubuntu, but is offered by Canonical and the
## respective vendors as a service to Ubuntu users.
deb http://archive.canonical.com/ubuntu jammy partner
# deb-src http://archive.canonical.com/ubuntu jammy partner

deb http://security.ubuntu.com/ubuntu jammy-security main restricted
# deb-src http://security.ubuntu.com/ubuntu jammy-security main restricted
deb http://security.ubuntu.com/ubuntu jammy-security universe
# deb-src http://security.ubuntu.com/ubuntu jammy-security universe
deb http://security.ubuntu.com/ubuntu jammy-security multiverse
# deb-src http://security.ubuntu.com/ubuntu jammy-security multiverse

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#19

I am located in South Africa (Durban).
In repositories there is place to find best place sources.list for my setup and it gave me
the Belgium I was surprise but accepted.

Now I have another problem I thick broke repositories.
While adding “jammy-updates” something went wrong Software Update don’t open starting
Synaptic it gives this error:

E: Malformed entry 1 in list file/etc/apt/sources.list.d/archive_uri-
http_archive_ubuntu.com_ubuntu_-jammy.list (Component)
E: The list of sources could not be read.
E:_cache→open()failed, please report

Apologize for this mistake, and thank you for the help.

Revision history for this message
Manfred Hampl (m-hampl) said :
#20

What have you done to add jammy-updates?
What is now the output of

cat -n /etc/apt/sources.list

cat -n /etc/apt/sources.list.d/archive_uri-http_archive_ubuntu.com_ubuntu_-jammy.list

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#21

luis@l-System-luisj:~$ cat -n /etc/apt/sources.list
     1 deb http://ftp.belnet.be/ubuntu/ jammy main universe restricted multiverse
luis@l-System-luisj:~$ cat -n /etc/apt/sources.list.d/archive_uri-http_archive_ubuntu.com_ubuntu_-jammy.list

I want to change the server to local to fix averything.

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#22

CORRECTION

luis@l-System-luisj:~$ cat -n /etc/apt/sources.list
     1 deb http://ftp.belnet.be/ubuntu/ jammy main universe restricted multiverse
luis@l-System-luisj:~$ cat -n /etc/apt/sources.list.d/archive_uri-http_archive_ubuntu.com_ubuntu_-jammy.list
cat: /etc/apt/sources.list.d/archive_uri-http_archive_ubuntu.com_ubuntu_-jammy.list: No such file or directory
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#23

Already asked in comment #20
What have you done (or tried) to add jammy-updates?

In comment #18 I have already given the example contents which I think will be adequate for your system.
I suggest that you edit the /etc/apt/sources.list file and replace its contents with the contents of comment #18 (minus the first six lines of explanation; starting with "# deb...")

Are there any files inside the directory /etc/apt/sources.list.d/ ?

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#24

On adding jammy-updates I use “deb http://archive.ubuntu.com/ubuntu/ jammy-updates” this broke
Software Update and opening Synaptic gives the error mention before.
About editing /etc/apt/sources.list I use Text Editor delete “deb http://ftp.belnet.be/ubuntu/ jammy main universe restricted multiverse: add deb http:// jammy main restricted the Save button is grey and does nothing
Files on the directory etc/apt/source.list.d/ there are 16.

Revision history for this message
Manfred Hampl (m-hampl) said :
#25

I assume when trying to add
“deb http://archive.ubuntu.com/ubuntu/ jammy-updates”
you used wrong quote characters. ( ” instead of " )

Please provide the full output that you receive for the following command:

grep -v nonexistingstring /etc/apt/sources.list /etc/apt/sources.list.d/*.list

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#26

Been away for few days come back on the job.
Don't remember what quotes characters I use on adding jammy-updates.

luis@l-System-luisj:~$ grep -v nonexistingstring /etc/apt/sources.list /etc/apt/sources.list.d/*.list
/etc/apt/sources.list:deb http://ftp.belnet.be/ubuntu/ jammy main universe restricted multiverse
/etc/apt/sources.list.d/archive_uri-http_archive_ubuntu_com_ubuntu_-jammy.list:deb http://archive.ubuntu.com/ubuntu/ jammy-updates
/etc/apt/sources.list.d/archive_uri-http_archive_ubuntu_com_ubuntu_-jammy.list:# deb-src http://archive.ubuntu.com/ubuntu/ jammy-updates
/etc/apt/sources.list.d/archive_uri-http_archive_ubuntu_com_ubuntu_-jammy.list:deb http://archive.ubuntu.com/ubuntu/ jammy-security
/etc/apt/sources.list.d/archive_uri-http_archive_ubuntu_com_ubuntu_-jammy.list:# deb-src http://archive.ubuntu.com/ubuntu/ jammy-security
/etc/apt/sources.list.d/bablu-boy-ubuntu-nutty-jammy.list:deb https://ppa.launchpadcontent.net/bablu-boy/nutty/ubuntu/ jammy main
/etc/apt/sources.list.d/bablu-boy-ubuntu-nutty-jammy.list:# deb-src https://ppa.launchpadcontent.net/bablu-boy/nutty/ubuntu/ jammy main
/etc/apt/sources.list.d/jentiger-moratai-ubuntu-mediatools-jammy.list:deb https://ppa.launchpadcontent.net/jentiger-moratai/mediatools/ubuntu/ jammy main
/etc/apt/sources.list.d/jentiger-moratai-ubuntu-mediatools-jammy.list:# deb-src https://ppa.launchpadcontent.net/jentiger-moratai/mediatools/ubuntu/ jammy main
/etc/apt/sources.list.d/michael-gruz-ubuntu-canon-jammy.list:# deb https://ppa.launchpadcontent.net/michael-gruz/canon/ubuntu/ jammy main
/etc/apt/sources.list.d/michael-gruz-ubuntu-canon-jammy.list:# deb-src https://ppa.launchpadcontent.net/michael-gruz/canon/ubuntu/ jammy main
/etc/apt/sources.list.d/michael-gruz-ubuntu-canon-stable-jammy.list:# deb https://ppa.launchpadcontent.net/michael-gruz/canon-stable/ubuntu/ jammy main
/etc/apt/sources.list.d/michael-gruz-ubuntu-canon-stable-jammy.list:# deb-src https://ppa.launchpadcontent.net/michael-gruz/canon-stable/ubuntu/ jammy main
/etc/apt/sources.list.d/michael-gruz-ubuntu-canon-trunk-jammy.list:# deb https://ppa.launchpadcontent.net/michael-gruz/canon-trunk/ubuntu/ jammy main
/etc/apt/sources.list.d/michael-gruz-ubuntu-canon-trunk-jammy.list:# deb-src https://ppa.launchpadcontent.net/michael-gruz/canon-trunk/ubuntu/ jammy main
/etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-jammy.list:# deb https://ppa.launchpadcontent.net/thierry-f/fork-michael-gruz/ubuntu/ jammy main
/etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-jammy.list:# deb-src https://ppa.launchpadcontent.net/thierry-f/fork-michael-gruz/ubuntu/ jammy main
/etc/apt/sources.list.d/webupd8team-ubuntu-java-jammy.list:# deb https://ppa.launchpadcontent.net/webupd8team/java/ubuntu/ jammy main
/etc/apt/sources.list.d/webupd8team-ubuntu-java-jammy.list:# deb-src https://ppa.launchpadcontent.net/webupd8team/java/ubuntu/ jammy main
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#27

Already written in comment #23:

In comment #18 I have already given the example contents which I think will be adequate for your system.
I suggest that you edit the /etc/apt/sources.list file and replace its contents with the contents of comment #18 (minus the first six lines of explanation; starting with "# deb...")

Repeating and giving step-by-step instructions:

Open a terminal window

Issue the command
sudo gedit /etc/apt/sources.list

In the editor window that opens after entering your password (when requested, to confirm an administrative action) delete the line of text that is there and paste everything from comment #18 into the edit window (minus the first six lines).
Save the file and close the editor.

In the terminal window issue the following commands:
sudo rm /etc/apt/sources.list.d/archive_uri-http_archive_ubuntu_com_ubuntu_-jammy.list
sudo rm /etc/apt/sources.list.d/michael-gruz-ubuntu-canon-jammy.list
sudo rm /etc/apt/sources.list.d/michael-gruz-ubuntu-canon-stable-jammy.list
sudo rm /etc/apt/sources.list.d/michael-gruz-ubuntu-canon-trunk-jammy.list
sudo rm /etc/apt/sources.list.d/thierry-f-ubuntu-fork-michael-gruz-jammy.list:
sudo rm /etc/apt/sources.list.d/webupd8team-ubuntu-java-jammy.list

Finally execute the commands
sudo apt update
ls -l /etc/apt/sources.list.d/
and copy/paste the output that we can see the results.

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#28

souces.list page opens delete the line of text then notice the errors in Terminal had to Close Terminal

luis@l-System-luisj:~$ sudo gedit /etc/apt/sources.list
[sudo] password for luis:

(gedit:9830): dconf-WARNING **: 07:21:14.346: failed to commit changes to dconf: Failed to execute child process “dbus-launch” (No such file or directory)

(gedit:9830): dconf-WARNING **: 07:21:14.351: failed to commit changes to dconf: Failed to execute child process “dbus-launch” (No such file or directory)

(gedit:9830): dconf-WARNING **: 07:21:14.742: failed to commit changes to dconf: Failed to execute child process “dbus-launch” (No such file or directory)

(gedit:9830): dconf-WARNING **: 07:21:14.742: failed to commit changes to dconf: Failed to execute child process “dbus-launch” (No such file or directory)

(gedit:9830): dconf-WARNING **: 07:21:14.742: failed to commit changes to dconf: Failed to execute child process “dbus-launch” (No such file or directory)

Revision history for this message
Manfred Hampl (m-hampl) said :
#29

"... had to Close Terminal"

Why did you close the terminal window?

Those messages are warnings that can be ignored.
Just modify the contents of /etc/apt/sources.list as written above.

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#30

luis@l-System-luisj:~$ ls -l /etc/apt/sources.list.d/
total 40
-rw-r--r-- 1 root root 110 Mar 3 07:36 archive_uri-http_archive_ubuntu_com_ubuntu_-jammy.list.save
-rw-r--r-- 1 root root 150 Mar 3 07:36 bablu-boy-ubuntu-nutty-jammy.list
-rw-r--r-- 1 root root 150 Mar 3 07:36 bablu-boy-ubuntu-nutty-jammy.list.save
-rw-r--r-- 1 root root 174 Mar 3 07:36 jentiger-moratai-ubuntu-mediatools-jammy.list
-rw-r--r-- 1 root root 174 Mar 3 07:36 jentiger-moratai-ubuntu-mediatools-jammy.list.save
-rw-r--r-- 1 root root 158 Mar 3 07:36 michael-gruz-ubuntu-canon-jammy.list.save
-rw-r--r-- 1 root root 172 Mar 3 07:36 michael-gruz-ubuntu-canon-stable-jammy.list.save
-rw-r--r-- 1 root root 170 Mar 3 07:36 michael-gruz-ubuntu-canon-trunk-jammy.list.save
-rw-r--r-- 1 root root 176 Mar 3 07:36 thierry-f-ubuntu-fork-michael-gruz-jammy.list.save
-rw-r--r-- 1 root root 154 Mar 3 07:36 webupd8team-ubuntu-java-jammy.list.save
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#31

Do some cleanup:

sudo rm /etc/apt/sources.list.d/*.list.save

And then back to the other problem, what is now the output of the commands

sudo apt update
sudo apt install mysql-server

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#32

luis@l-System-luisj:~$ sudo rm /etc/apt/sources.list.d/*.list.save
[sudo] password for luis:
luis@l-System-luisj:~$ sudo apt update
Hit:1 http://archive.canonical.com/ubuntu jammy InRelease
Hit:2 http://security.ubuntu.com/ubuntu jammy-security InRelease
Hit:3 http://za.archive.ubuntu.com/ubuntu jammy InRelease
Hit:4 http://za.archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:5 https://ppa.launchpadcontent.net/bablu-boy/nutty/ubuntu jammy InRelease
Hit:6 http://za.archive.ubuntu.com/ubuntu jammy-backports InRelease
Hit:7 https://ppa.launchpadcontent.net/jentiger-moratai/mediatools/ubuntu jammy InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
99 packages can be upgraded. Run 'apt list --upgradable' to see them.
luis@l-System-luisj:~$ sudo apt install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl mecab-ipadic mecab-ipadic-utf8
  mecab-utils mysql-client-8.0 mysql-common mysql-server-8.0
Suggested packages:
  libipc-sharedcache-perl mailx tinyca
The following NEW packages will be installed:
  libcgi-fast-perl libcgi-pm-perl libfcgi-bin libfcgi-perl libfcgi0ldbl libhtml-template-perl mecab-ipadic mecab-ipadic-utf8
  mecab-utils mysql-client-8.0 mysql-common mysql-server mysql-server-8.0
0 upgraded, 13 newly installed, 0 to remove and 99 not upgraded.
Need to get 8,481 kB/8,513 kB of archives.
After this operation, 57.1 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 mysql-common all 5.8+1.0.8 [7,212 B]
Get:2 http://za.archive.ubuntu.com/ubuntu jammy-updates/main amd64 mysql-server-8.0 amd64 8.0.32-0ubuntu0.22.04.2 [1,427 kB]
Get:3 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 libcgi-pm-perl all 4.54-1 [188 kB]
Get:4 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 libfcgi0ldbl amd64 2.4.2-2build2 [28.0 kB]
Get:5 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 libfcgi-perl amd64 0.82+ds-1build1 [22.8 kB]
Get:6 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 libcgi-fast-perl all 1:2.15-1 [10.5 kB]
Get:7 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 libfcgi-bin amd64 2.4.2-2build2 [11.2 kB]
Get:8 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 libhtml-template-perl all 2.97-1.1 [59.1 kB]
Get:9 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 mecab-utils amd64 0.996-14build9 [4,850 B]
Get:10 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 mecab-ipadic all 2.7.0-20070801+main-3 [6,718 kB]
Get:11 http://za.archive.ubuntu.com/ubuntu jammy/main amd64 mecab-ipadic-utf8 all 2.7.0-20070801+main-3 [4,384 B]
Fetched 8,481 kB in 7s (1,225 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 257501 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.8_all.deb ...
Unpacking mysql-common (5.8+1.0.8) ...
Selecting previously unselected package mysql-client-8.0.
Preparing to unpack .../mysql-client-8.0_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Setting up mysql-common (5.8+1.0.8) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-8.0.
(Reading database ... 257528 files and directories currently installed.)
Preparing to unpack .../00-mysql-server-8.0_8.0.32-0ubuntu0.22.04.2_amd64.deb ...
Unpacking mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Selecting previously unselected package libcgi-pm-perl.
Preparing to unpack .../01-libcgi-pm-perl_4.54-1_all.deb ...
Unpacking libcgi-pm-perl (4.54-1) ...
Selecting previously unselected package libfcgi0ldbl:amd64.
Preparing to unpack .../02-libfcgi0ldbl_2.4.2-2build2_amd64.deb ...
Unpacking libfcgi0ldbl:amd64 (2.4.2-2build2) ...
Selecting previously unselected package libfcgi-perl:amd64.
Preparing to unpack .../03-libfcgi-perl_0.82+ds-1build1_amd64.deb ...
Unpacking libfcgi-perl:amd64 (0.82+ds-1build1) ...
Selecting previously unselected package libcgi-fast-perl.
Preparing to unpack .../04-libcgi-fast-perl_1%3a2.15-1_all.deb ...
Unpacking libcgi-fast-perl (1:2.15-1) ...
Selecting previously unselected package libfcgi-bin.
Preparing to unpack .../05-libfcgi-bin_2.4.2-2build2_amd64.deb ...
Unpacking libfcgi-bin (2.4.2-2build2) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../06-libhtml-template-perl_2.97-1.1_all.deb ...
Unpacking libhtml-template-perl (2.97-1.1) ...
Selecting previously unselected package mecab-utils.
Preparing to unpack .../07-mecab-utils_0.996-14build9_amd64.deb ...
Unpacking mecab-utils (0.996-14build9) ...
Selecting previously unselected package mecab-ipadic.
Preparing to unpack .../08-mecab-ipadic_2.7.0-20070801+main-3_all.deb ...
Unpacking mecab-ipadic (2.7.0-20070801+main-3) ...
Selecting previously unselected package mecab-ipadic-utf8.
Preparing to unpack .../09-mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb ...
Unpacking mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../10-mysql-server_8.0.32-0ubuntu0.22.04.2_all.deb ...
Unpacking mysql-server (8.0.32-0ubuntu0.22.04.2) ...
Setting up libfcgi0ldbl:amd64 (2.4.2-2build2) ...
Setting up libcgi-pm-perl (4.54-1) ...
Setting up libfcgi-bin (2.4.2-2build2) ...
Setting up libhtml-template-perl (2.97-1.1) ...
Setting up mecab-utils (0.996-14build9) ...
Setting up mysql-client-8.0 (8.0.32-0ubuntu0.22.04.2) ...
Setting up libfcgi-perl:amd64 (0.82+ds-1build1) ...
Setting up mysql-server-8.0 (8.0.32-0ubuntu0.22.04.2) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 12093
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Setting up mecab-ipadic (2.7.0-20070801+main-3) ...
Compiling IPA dictionary for Mecab. This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix : 100% |###########################################|

done!
update-alternatives: using /var/lib/mecab/dic/ipadic to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up libcgi-fast-perl (1:2.15-1) ...
Setting up mecab-ipadic-utf8 (2.7.0-20070801+main-3) ...
Compiling IPA dictionary for Mecab. This takes long time...
reading /usr/share/mecab/dic/ipadic/unk.def ... 40
emitting double-array: 100% |###########################################|
/usr/share/mecab/dic/ipadic/model.def is not found. skipped.
reading /usr/share/mecab/dic/ipadic/Others.csv ... 2
reading /usr/share/mecab/dic/ipadic/Auxil.csv ... 199
reading /usr/share/mecab/dic/ipadic/Conjunction.csv ... 171
reading /usr/share/mecab/dic/ipadic/Noun.place.csv ... 72999
reading /usr/share/mecab/dic/ipadic/Adnominal.csv ... 135
reading /usr/share/mecab/dic/ipadic/Noun.nai.csv ... 42
reading /usr/share/mecab/dic/ipadic/Noun.csv ... 60477
reading /usr/share/mecab/dic/ipadic/Noun.org.csv ... 16668
reading /usr/share/mecab/dic/ipadic/Verb.csv ... 130750
reading /usr/share/mecab/dic/ipadic/Interjection.csv ... 252
reading /usr/share/mecab/dic/ipadic/Noun.adjv.csv ... 3328
reading /usr/share/mecab/dic/ipadic/Adj.csv ... 27210
reading /usr/share/mecab/dic/ipadic/Noun.adverbal.csv ... 795
reading /usr/share/mecab/dic/ipadic/Prefix.csv ... 221
reading /usr/share/mecab/dic/ipadic/Adverb.csv ... 3032
reading /usr/share/mecab/dic/ipadic/Postp.csv ... 146
reading /usr/share/mecab/dic/ipadic/Noun.verbal.csv ... 12146
reading /usr/share/mecab/dic/ipadic/Postp-col.csv ... 91
reading /usr/share/mecab/dic/ipadic/Suffix.csv ... 1393
reading /usr/share/mecab/dic/ipadic/Noun.proper.csv ... 27328
reading /usr/share/mecab/dic/ipadic/Symbol.csv ... 208
reading /usr/share/mecab/dic/ipadic/Noun.demonst.csv ... 120
reading /usr/share/mecab/dic/ipadic/Noun.others.csv ... 151
reading /usr/share/mecab/dic/ipadic/Noun.number.csv ... 42
reading /usr/share/mecab/dic/ipadic/Filler.csv ... 19
reading /usr/share/mecab/dic/ipadic/Noun.name.csv ... 34202
emitting double-array: 100% |###########################################|
reading /usr/share/mecab/dic/ipadic/matrix.def ... 1316x1316
emitting matrix : 100% |###########################################|

done!
update-alternatives: using /var/lib/mecab/dic/ipadic-utf8 to provide /var/lib/mecab/dic/debian (mecab-dictionary) in auto mode
Setting up mysql-server (8.0.32-0ubuntu0.22.04.2) ...
Processing triggers for man-db (2.10.2-1) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
luis@l-System-luisj:~$

Revision history for this message
Manfred Hampl (m-hampl) said :
#33

This looks good. I do not see any error any more and MySQL seems to be installed and running.

Revision history for this message
Luis M.Jacinto (ljacinto) said :
#34

Thank you for the great help from you as always and a great service from this forum.