--- mysql.spec	2015-11-11 10:44:46.000000000 -0800
+++ mysql.spec.good	2021-10-19 14:13:18.348177361 -0700
@@ -457,6 +457,7 @@
 %{?el7:%patch0 -p1}
 
 %build
+export CMAKE_INSTALL_PREFIX=/usr/local
 # Fail quickly and obviously if user tries to build as root
 %if 0%{?runselftest}
 if [ "x$(id -u)" = "x0" ] ; then
@@ -478,7 +479,7 @@
     --with-readline \
     --without-debug \
     --enable-shared \
-    --localstatedir=/var/lib/mysql \
+    --localstatedir=/usr/local/lib/mysql \
     --with-unix-socket-path=/var/lib/mysql/mysql.sock \
     --with-mysqld-user="mysql" \
     --with-extra-charsets=all \
@@ -504,6 +505,7 @@
     --with-named-thread-libs="-lpthread" \
 %endif
     --disable-dependency-tracking
+  sed -i -e 's|\"\/usr|"/usr/local|' build/include/my_config.h
   make %{?_smp_mflags}
   popd
 )
@@ -525,9 +527,12 @@
     -DFEATURE_SET="%{feature_set}" \
     -DWITH_EMBEDDED_SERVER=1 \
     -DWITH_EMBEDDED_SHARED_LIBRARY=1 \
+    -DCMAKE_INSTALL_PREFIX="%{_prefix}" \
     %{?ssl_option} \
     -DCOMPILATION_COMMENT="%{compilation_comment_release}" \
     -DMYSQL_SERVER_SUFFIX="%{?server_suffix}"
+  sed -i -e '/INSTALL/ s|\"\/usr|"/usr/local|' include/config.h
+  sed -i -e '/INSTALL/ s|\"\/usr|"/usr/local|' include/my_config.h
   echo BEGIN_NORMAL_CONFIG ; egrep '^#define' include/config.h ; echo END_NORMAL_CONFIG
   make %{?_smp_mflags} VERBOSE=1
   popd && popd
@@ -561,10 +566,13 @@
            -DFEATURE_SET="%{feature_set}" \
            -DWITH_EMBEDDED_SERVER=1 \
            -DWITH_EMBEDDED_SHARED_LIBRARY=1 \
+	   -DCMAKE_INSTALL_PREFIX="%{_prefix}" \
            %{?ssl_option} \
            %{?mecab_option} \
            -DCOMPILATION_COMMENT="%{compilation_comment_debug}" \
            -DMYSQL_SERVER_SUFFIX="%{?server_suffix}"
+  sed -i -e '/INSTALL/ s|\"\/usr|"/usr/local|' include/config.h
+  sed -i -e '/INSTALL/ s|\"\/usr|"/usr/local|' include/my_config.h
   echo BEGIN_DEBUG_CONFIG ; egrep '^#define' include/config.h ; echo END_DEBUG_CONFIG
   make %{?_smp_mflags} VERBOSE=1
 )
@@ -590,15 +598,20 @@
            -DFEATURE_SET="%{feature_set}" \
            -DWITH_EMBEDDED_SERVER=1 \
            -DWITH_EMBEDDED_SHARED_LIBRARY=1 \
+	   -DCMAKE_INSTALL_PREFIX="%{_prefix}" \
            %{?ssl_option} \
            %{?mecab_option} \
            -DCOMPILATION_COMMENT="%{compilation_comment_release}" \
            -DMYSQL_SERVER_SUFFIX="%{?server_suffix}"
+  sed -i -e '/INSTALL/ s|\"\/usr|"/usr/local|' include/config.h
+  sed -i -e '/INSTALL/ s|\"\/usr|"/usr/local|' include/my_config.h
   echo BEGIN_NORMAL_CONFIG ; egrep '^#define' include/config.h ; echo END_NORMAL_CONFIG
   make %{?_smp_mflags} VERBOSE=1
 )
 
 %install
+export CMAKE_INSTALL_PREFIX=/usr/local
+mkdir -p %{buildroot}/usr/local
 %if 0%{?compatlib}
 # Install compat libs
 dirs="libmysql libmysql_r"
@@ -839,7 +852,7 @@
 %attr(644, root, root) %{_datadir}/mysql/magic
 %if 0%{?systemd}
 %attr(644, root, root) %{_unitdir}/mysqld.service
-%attr(644, root, root) %{_prefix}/lib/tmpfiles.d/mysql.conf
+%attr(644, root, root) /usr/lib/tmpfiles.d/mysql.conf
 %else
 %attr(755, root, root) %{_sysconfdir}/init.d/mysqld
 %endif