[OK]Missing file bin/mysqld when installing a generic binary of mysql

Kurokishin · 2022-06-05 20:39:55

I'm trying to install mysql 8.0.29 from a .tar.gz file because the AUR version isn't updated and my professor uses this tool specifically (that's why I'm not using MariaDB). Following the installation process from MySQL Installation Guide everything went fine until I tried to execute

bin/mysqld --initialize --user=mysql

An error message was given saying this bash: bin/mysqld: No such file or directory. With that, I tried to create a directory with that path but the error still remains. Any idea on how to solve this problem?

Last edited by Kurokishin (2022-06-05 21:53:14)

Trilby · 2022-06-05 20:47:09

Kurokishin wrote:

I'm trying to install mysql 8.0.29 from a .tar.gz file because the AUR version isn't updated

The version in the AUR is 8.0.28. Do you really need the change added in that one subversion update? Would it even be relevant on your system(s)?

For the actual error, what is your current working directory when you run that command? You'd be far better off using the absolute path rather than trying to use a relative path.

Also which source did you use for the tar file, and exactly how did you extract it?

Last edited by Trilby (2022-06-05 20:53:14)

Kurokishin · 2022-06-05 20:52:12

Well...not really, but since I already started trying to install this version I kinda got intrigued as per why it's not working.

The currenct directory is /usr/local/mysql, i guess this is the full path... (I'm running the commands as root as it was told so in the installation guide)

I extracted the file using

tar zxvf

and got it from https://dev.mysql.com/downloads/mysql/ the file called All Operating Systems (Generic) (Architecture Independent), Compressed TAR Archive

Last edited by Kurokishin (2022-06-05 21:07:01)

loqs · 2022-06-05 21:02:10

If you wanted to update the PKGBUILD to 8.0.29

git diff
diff --git a/PKGBUILD b/PKGBUILD
index 2191850..1f07945 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -6,7 +6,7 @@
 
 pkgname=('mysql' 'libmysqlclient' 'mysql-clients')
 pkgbase=mysql
-pkgver=8.0.28
+pkgver=8.0.29
 pkgrel=1
 pkgdesc="Fast SQL database server, community edition"
 arch=('x86_64')
@@ -22,7 +22,7 @@ source=("https://cdn.mysql.com/Downloads/MySQL-8.0/${pkgbase}-boost-${pkgver}.ta
         "mysqld_service.patch"
         "systemd-tmpfiles.patch"
         "systemd-sysusers.conf")
-sha256sums=('6dd0303998e70066d36905bd8fef1c01228ea182dbfbabc6c22ebacdbf8b5941'
+sha256sums=('fd34a84c65fc7b15609d55b1f5d128c4d5543a6b95fa638569c3277c5c7bb048'
             '6bc24ae510f6b6bbad6b3edda2d0028b29292937b482274a4c2fae335f4de328'
             'e1c23fa0971a13d998f2790379b68c475438d05b6d6f2691b99051dbf497567f'
             '203dcd22fea668477ac7123dbd9909fae72d3d07f8855417a669a9c94db072ae'
@@ -167,7 +167,7 @@ package_mysql(){
   rm "${pkgdir}/usr/lib/libmysqlclient.a"
   rm "${pkgdir}/usr/lib/libmysqlclient.so"
   rm "${pkgdir}/usr/lib/libmysqlclient.so.21"
-  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.2.28"
+  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.2.29"
   rm "${pkgdir}/usr/lib/libmysqlservices.a"
   rm "${pkgdir}/usr/lib/pkgconfig/mysqlclient.pc"
   rmdir "${pkgdir}/usr/lib/pkgconfig"

Kurokishin · 2022-06-05 21:11:26

I think that solution applies only if I had mysql installed in the first place? Which is not the case.

Trilby · 2022-06-05 21:13:36

I don't see that file on the page you linked to. Further, there is no way an "all operating system / generic" tarball would run on linux. There are linux-specific tarballs. If you must go the manual route (you really shouldn't), then you'd need to download one that matches your OS and architecture. Even at that, those builds are for older versions of glibc and thus may not run at all on arch.

In any case, if you want help identifying the proximate cause of the error message you are getting, you need to provide an actual link to the material you downloaded. If it wasn't a precombiled binary tarball (which sounds like), that would explain the error.

EDIT: I did find a tarball with the name you indicated - but it was under the "source code" category. You are following directions written for a precompiled binary download, but you didn't download a precompiled binary.

EDIT 2: Loqs solution does not require having mysql already installed. It is a patch to the PKGBUILD in order to build and install the most current subversion ... which you really don't need. No offense, but given the direction of this conversation, you do not appear remotely qualified to try building your own mysql system. Use the AUR package.

Last edited by Trilby (2022-06-05 21:16:52)

loqs · 2022-06-05 21:15:49

bsdtar -tf mysql-8.0.29-linux-glibc2.12-x86_64.tar.xz | grep mysqld
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqldump
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld-debug
mysql-8.0.29-linux-glibc2.12-x86_64/include/mysqld_error.h
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqld_multi.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqld_safe.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqldump.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.29-linux-glibc2.12-x86_64/man/man8/mysqld.8
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld_multi
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqld_safe
mysql-8.0.29-linux-glibc2.12-x86_64/bin/mysqldumpslow
mysql-8.0.29-linux-glibc2.12-x86_64/support-files/mysqld_multi.server

Kurokishin · 2022-06-05 21:47:19

Ok, I will follow your advice. Thanks for your help.

Muflone · 2022-06-09 09:15:59

loqs wrote:

If you wanted to update the PKGBUILD to 8.0.29

git diff
diff --git a/PKGBUILD b/PKGBUILD
index 2191850..1f07945 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -6,7 +6,7 @@
 
 pkgname=('mysql' 'libmysqlclient' 'mysql-clients')
 pkgbase=mysql
-pkgver=8.0.28
+pkgver=8.0.29
 pkgrel=1
 pkgdesc="Fast SQL database server, community edition"
 arch=('x86_64')
@@ -22,7 +22,7 @@ source=("https://cdn.mysql.com/Downloads/MySQL-8.0/${pkgbase}-boost-${pkgver}.ta
         "mysqld_service.patch"
         "systemd-tmpfiles.patch"
         "systemd-sysusers.conf")
-sha256sums=('6dd0303998e70066d36905bd8fef1c01228ea182dbfbabc6c22ebacdbf8b5941'
+sha256sums=('fd34a84c65fc7b15609d55b1f5d128c4d5543a6b95fa638569c3277c5c7bb048'
             '6bc24ae510f6b6bbad6b3edda2d0028b29292937b482274a4c2fae335f4de328'
             'e1c23fa0971a13d998f2790379b68c475438d05b6d6f2691b99051dbf497567f'
             '203dcd22fea668477ac7123dbd9909fae72d3d07f8855417a669a9c94db072ae'
@@ -167,7 +167,7 @@ package_mysql(){
   rm "${pkgdir}/usr/lib/libmysqlclient.a"
   rm "${pkgdir}/usr/lib/libmysqlclient.so"
   rm "${pkgdir}/usr/lib/libmysqlclient.so.21"
-  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.2.28"
+  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.2.29"
   rm "${pkgdir}/usr/lib/libmysqlservices.a"
   rm "${pkgdir}/usr/lib/pkgconfig/mysqlclient.pc"
   rmdir "${pkgdir}/usr/lib/pkgconfig"

thanks for the patch :-D

Package just updated in the AUR

Last edited by Muflone (2022-06-11 23:31:49)

Arch Linux

#1 2022-06-05 20:39:55

[OK]Missing file bin/mysqld when installing a generic binary of mysql

#2 2022-06-05 20:47:09

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#3 2022-06-05 20:52:12

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#4 2022-06-05 21:02:10

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#5 2022-06-05 21:11:26

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#6 2022-06-05 21:13:36

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#7 2022-06-05 21:15:49

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#8 2022-06-05 21:47:19

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

#9 2022-06-09 09:15:59

Re: [OK]Missing file bin/mysqld when installing a generic binary of mysql

Board footer