Try the following steps to add the MySQL repository to your list and install MySQL 8.0. I have not tested this, but according to the docs it should work (unless I made a typing mistake).
Install the MySQL GPG Public key to your APT keyring: (also see this post)
sudo apt-key adv --keyserver keys.gnupg.net --recv-keys 5072E1F5
Add the MySQL Xenial Repo to ...
after some google searching it turns out that what I needed to do to resolve this issue was the following
sudo apt-get install libmysqlclient-dev
Now my Perl based mysql scripts seem to be working just fine.
The MySQL JDBC driver default behavior apparently changed when updating the OS.
The previous driver turned off transaction auto commits for Java batch updates - manually adding/running setAutoCommit(false) on the data connection dropped the run time back to normal (apparently it was running atomic transactions for 1000 some inserts).
This is a good example ...
I faced same error due to problem in my upgrade from ubuntu 18.04 to Ubuntu 20.04. What I did is get MariaDB instead also make sure when you do purge MySQL and if asked to remove databases in the directory, click on "No". It would not delete the databases so you will have your old databases and no data loss.
I used these commands:
sudo apt-get ...
As @mariaczi found out, the problem is, that there isn't enough RAM for MySQL to start.
I tried to add swap space, but without success. Maybe this is not possible on my virtual server.
I finally ended up with adding the following to /etc/my.cnf:
After that, I restarted the server and I was able to use MySQL.
With heavy adoption of systemd as system manager and init system for debian based distributions like ubuntu , we can now use systemctl commands to prevent a service from automatically starting at boot.
for example :
sudo systemctl disable apache2
To start using it when required , you can use:
sudo systemctl start apache2
To stop using it, you can use:
There is a problem clearly stated (I copied the relevant parts):
mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
[ERROR] Failed to access directory for --secure-file-priv.
Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /va
Please take a look at https://wiki....
This is what I did, in ubuntu terminal i located mysql by typing in
For which I got an output
Further mysql was inside lampp as well, i located it by
mysql -u root -p -h 127.0.0.1 -e "select @@socket"
For which I got an output
Then i typed in
and pressed enter to open as root,...
There is thing thig called as dependency. When you install a software, it might depend on some other extra package to provide some system calls or some service. When you remove this software, and the extra packages are no longer needed by any software, then it is safe to remove these packages also.
In your case, when it says following packages were ...
The line in etc/apt/sources.list.d/trusty.list that is generating the component misspelt in sources.list error message is for a trusty repository and you are using bionic (18.04). Remove the line in /etc/apt/sources.list.d/mysql.list the contains the string http://repo.mysql.com/apt/ubuntu trusty by preceding it with a # character in order to turn it into a ...
This is not really a answer to your question, but I had similar problem with mysql-server after upgrade of my Ubuntu server (18.04 -> 20.04).
2020-10-03T16:07:22.635008Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-10-03T16:07:23.415771Z 0 [Warning] [MY-011068] [Server] The syntax '...