![]() ![]() Preparationīefore doing anything else, I took a backup of the databases using the mysqldump tool. It's actually relatively newly created as it was installed using the Web Platform Installer late last year, so it's surprising it's such an out-dated version, especially as tools like MySQL Workbench aren't able to connect to it! The instructions for upgrading a Windows instance of MySQL are a starting point, but they don't cover some of the errors that I've seen during the process, so here's the steps I took to achieve this. Socket = /usr/local/mysql/data/mysqld.I've got a very old instance of MySQL kicking around (5.1.73 - released in December 2013) that's due for an upgrade. cnf files there, so if you need stuff like sockets or anything else, you can put my.cnf in /usr/local/mysql/ and any regular directives there, for example: If you have followed above tutorial, then your mysql base dir is /usr/local/mysql/ and it would seek. Shell> cp support-files/rver /etc/init.d/rver Shell> bin/mysqld -initialize -user=mysql Shell> ln -s full-path-to-mysql-VERSION-OS mysql Shell> useradd -r -g mysql -s /bin/false mysql Sudo dpkg -i mysql-testsuite_5.7.30-1ubuntu18.04_bĪfter a lot of struggle I've managed to install and use it in the following way,įrom mysql download archive, download generic 5.7, it's best if you first navigate to /usr/local/ so sudo su Sudo dpkg -i mysql-community-server_5.7.30-1ubuntu18.04_b Sudo dpkg -i mysql-community-client_5.7.30-1ubuntu18.04_b Sudo dpkg -i mysql-community-source_5.7.30-1ubuntu18.04_b I think the order is : sudo dpkg -i mysql-common_5.7.30-1ubuntu18.04_b Package: mysql-serverįirst I removed mysql from my pc remove Mysql Prevent upgrading to MySQL 8 - thanks to NSwanson7 in this post sudo nano /etc/apt/preferences.d/mysqlĪdd the following content in the above created file. I used the following to secure the MySQL installation Sudo apt install -f mysql-server=5.7.30-1ubuntu18.04 Sudo apt install -f mysql-community-server=5.7.30-1ubuntu18.04 ![]() sudo apt install -f mysql-client=5.7.30-1ubuntu18.04 Then I traced my steps backwards - installed mysql-community-server and then mysql-server. I tried to install this one, and it worked. I tried installing the later, it failed again, requesting mysql-client. Basically, I tried installing mysql-server - it failed requesting mysql-community-server. Otherwise errors similar to the ones in my original question, are displayed. I don't know why, but without the following, it gave an error while installing mysql-community-server and failed. Run the command bellow and select MySQL 5.7 from the list: sudo dpkg-reconfigure mysql-apt-config Sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb This commented out all entries in /etc/apt//mysql.list (created according to Kulfy's answer in this post) So, I installed mysql-apt-config as a helper. As you will see, I don't understand why some things worked and some didn't. I managed to make it work! I am not an experienced Linux user, therefore please feel free to comment/edit/improve my answer. I also tried the suggestions in this post and also this one (what I thought could work).Ĭan you please point me in the right direction? Mysql-server : Depends: mysql-server-5.7 but it is not going to be installedĮ: Unable to correct problems, you have held broken packages. The following packages have unmet dependencies: The following information may help to resolve the situation: Requested an impossible situation or if you are using the unstableĭistribution that some required packages have not yet been created The output of the above command is: Reading package lists. I used the following command to install mysql-server. The output of apt-cache policy mysql-server I was able to install mysql-client, but not mysql-server. I followed Kulfy's steps in this post to install MySQL 5.7 on Ubuntu 20.04. I am trying to install MySQL 5.7 on a fresh Ubuntu 20.04 installation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |