Ttgjyuk

I'm trying to install mysql to my new laptop and I'm getting these funny errors.

Renaming removed key_buffer and myisam-recover options (if present)
Cannot stat file /proc/2801/fd/1023: Permission denied
Cannot stat file /proc/2812/fd/1023: Permission denied
Cannot stat file /proc/2816/fd/1023: Permission denied
Cannot stat file /proc/2846/fd/7: Permission denied
Cannot stat file /proc/2846/fd/8: Permission denied
Cannot stat file /proc/2846/fd/9: Permission denied
Cannot stat file /proc/2846/fd/10: Permission denied
Cannot stat file /proc/2846/fd/11: Permission denied
Cannot stat file /proc/2846/fd/12: Permission denied
Cannot stat file /proc/2846/fd/56: Permission denied
Cannot stat file /proc/2846/fd/57: Permission denied
Cannot stat file /proc/2846/fd/1023: Permission denied
Cannot stat file /proc/2861/fd/6: Permission denied
Cannot stat file /proc/2861/fd/7: Permission denied
Cannot stat file /proc/2861/fd/8: Permission denied
Cannot stat file /proc/2861/fd/9: Permission denied
Cannot stat file /proc/2861/fd/10: Permission denied
Cannot stat file /proc/2861/fd/11: Permission denied
Cannot stat file /proc/2873/fd/4: Permission denied
Cannot stat file /proc/2873/fd/6: Permission denied
Cannot stat file /proc/2873/fd/7: Permission denied
Cannot stat file /proc/2873/fd/8: Permission denied
Cannot stat file /proc/2879/fd/6: Permission denied
Cannot stat file /proc/2879/fd/7: Permission denied
Cannot stat file /proc/2879/fd/8: Permission denied
Cannot stat file /proc/2879/fd/9: Permission denied
Cannot stat file /proc/2879/fd/10: Permission denied
Cannot stat file /proc/2879/fd/11: Permission denied
Cannot stat file /proc/2879/fd/15: Permission denied
Cannot stat file /proc/2879/fd/16: Permission denied
dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
 Package mysql-server-5.7 is not configured yet.

I uninstalled and reinstalled mysql about 4 times, and the same thing happens. I have another lamp stack running fine on my older server, any tips? Thanks!

You may need to install the libaio library if it is not already present on your system:

how to check if libaio is installed (quickly)

$ apt-cache policy libaio1

If it's installed, it will display the version installed, if it's not, it will display the lines of text. If it is installed then skip Install libaio and goto step-1.

Install libaio

$ sudo apt-get install libaio1 libaio-dev

Note: use the following commands in order to fix all the dependencies for libaio1, libmecab2 and so on.

$ sudo aptitude update 
$ sudo aptitude upgrade

Note: Make sure that aptitude has been installed in Ubuntu.

Figure-1: Install libaio1

Step 1 Get MySQL APT Repository

The MySQL package version that comes with Ubuntu default repositories is not the latest version. If you need to install the latest version of MySQL database, you may want to install its repository in Ubuntu.
You can also use the command line to download, changing the version number of the package.

$ cd /tmp/ && wget [https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb][2]

Then run the commands below to install

$ sudo dpkg -i mysql-apt-config_0.8.10-1_all.deb

When you run the commands above, you should get a config prompt. Just select OK as shown in the image below.

MySQL APT Repo features MySQL Server along with a variety of MySQL components. You may select the appropriate product to choose the version that you wish to receive.

Step 2: Install MySQL 8.0.13 Server and Client.

Now that the repository is installed, run the commands below to install

$ sudo apt update
$ sudo apt install mysql-server mysql-client

There are also packages with server-core and client-core in the package names. These
contain binaries only and are installed automatically by the standard packages. Installing them by themselves will not result in a functioning MySQL setup.

If you are being warned of unmet dependencies by dpkg, you can fix them using apt-get:

$ sudo apt-get -f install # Fix/correct the system with any broken dependencies in place.
$ cd ~

Here are where the files are installed on the system:

• All configuration files (like my.cnf) are under /etc/mysql
  


• All binaries, libraries, headers, etc., are under /usr/bin and
  /usr/sbin
  


• The data directory is under /var/lib/mysql
  

Warning: Debian distributions of MySQL are also provided by other vendors. Be aware that they may differ from those built by Oracle in features, capabilities, and conventions (including communication setup), and that the instructions in this manual do not necessarily apply to installing them. The vendor's instructions should be consulted instead.

When you run the commands above, you should get a config prompt. Just select OK as shown in the image below. But unfortunately, my observation was, MySQL was not supporting Cosmic Cuttlefish (Ubuntu 18.10), the installation was trying to abort, but you can select Ubuntu Bionic (18.04) and go ahead with installation. Use Up arrow and select ubuntu bionic (18.04) as shown in figure-1.

Figure-2: Select ubuntu bionic (18.04) in the absence of ubuntu cosmic (18.10)

MySQL APT Repo features MySQL Server along with a variety of MySQL components. You may select the appropriate product to choose the version that you wish to receive.

Figure-3: Select appropriate product

During the installation, you should be prompted to create and confirm a MySQL root password.

Figure-4: Enter password

Figure-5: Re-Enter password

Also, you confirm whether you want to use the new password encryption feature. it’s recommended.

Figure-6: password encryption feature

Figure-7: Configuring mysql communuty server

Special Notes on Upgrading the Shared Client Libraries

• You can install the shared client libraries from MySQL APT repository
  by the following command (see Installing Additional MySQL Products
  and Components with APT for more details):shell> sudo apt-get install libmysqlclient20




• If you already have the shared client libraries installed from you
  Linux platform's software repository, it can be updated by the MySQL
  APT repository with its own package by using the same command (see
  Replacing the Native Distribution by an APT Update for more details).



• After updating MySQL using the APT repository, applications compiled
  with older versions of the shared client libraries should continue to
  work.

To install the shared client libraries:

$ sudo apt-get install libmysqlclient18

Figure-8: install the shared client libraries

The MySQL services should start automatically after installation, check its status to ensure that it is up and running.

$ sudo service mysql status

After that, MySQL should be installed, you can logon by running the commands:

$ sudo mysql -u root -p

You should see MySQL welcome screen shown below:

Figure-8: Login into mysql

That how to install the latest version of MySQL on Ubuntu! Enjoy!!