Upgrade MySql 5 to 8?
- Thread starter alipour66m
- Start date
Hi John,
This works for the usual creating a user through the DA interface. However it's not working when I use admin backup and transfer to bring sites in from another server. Do the new user methods need to be implemented in the transfer functions of DA, or do I need to change a setting on the old server before creating the backup there?
This works for the usual creating a user through the DA interface. However it's not working when I use admin backup and transfer to bring sites in from another server. Do the new user methods need to be implemented in the transfer functions of DA, or do I need to change a setting on the old server before creating the backup there?
Hi Folks,
I did update from 5.7 to 8.0.
Besides that i run the follow php versions:
php 7.2.20
php2 7.1.30
php3 7.3.7
php4 7.0.33
I updated everything with CB 2.0.
I make use of Installatron to control applications on the server.
After the update i get errors about the authentication (2054). This come from the new authentication proces of mysql 8 (sha265).
As of the moment of writing, php mysqli doesn't support this by now. To fix this i set the follow in /etc/my.cnf and /etc/my.cnf.rpmnew:
default-authentication-plugin=mysql_native_password
This fixed the problems. I thought it is an nice fix to know for anyone who have the same issues.
I did update from 5.7 to 8.0.
Besides that i run the follow php versions:
php 7.2.20
php2 7.1.30
php3 7.3.7
php4 7.0.33
I updated everything with CB 2.0.
I make use of Installatron to control applications on the server.
After the update i get errors about the authentication (2054). This come from the new authentication proces of mysql 8 (sha265).
As of the moment of writing, php mysqli doesn't support this by now. To fix this i set the follow in /etc/my.cnf and /etc/my.cnf.rpmnew:
default-authentication-plugin=mysql_native_password
This fixed the problems. I thought it is an nice fix to know for anyone who have the same issues.
Theo Lodewijk
Verified User
- Joined
- Feb 5, 2020
- Messages
- 17
[root@mail custombuild]# ./build mysql
Found /usr/local/directadmin/custombuild/mysql/mysql-community-client-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-devel-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-server-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Stopping mysqld ...
Updating MySQL 8.0.17 to 8.0.17
warning: mysql-community-client-8.0.17-1.el8.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-8.0.17-1.e################################# [ 20%]
2:mysql-community-libs-8.0.17-1.el8################################# [ 40%]
3:mysql-community-client-8.0.17-1.e################################# [ 60%]
4:mysql-community-server-8.0.17-1.e################################# [ 80%]
5:mysql-community-devel-8.0.17-1.el################################# [100%]
[/usr/lib/tmpfiles.d/mdadm.conf:1] Line references path below legacy directory /var/run/, updating /var/run/mdadm → /run/mdadm; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/pesign.conf:1] Line references path below legacy directory /var/run/, updating /var/run/pesign → /run/pesign; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/radvd.conf:1] Line references path below legacy directory /var/run/, updating /var/run/radvd → /run/radvd; please update the tmpfiles.d/ drop-in file accordingly.
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
/var/lib/mysql/mysql does not exist, running clean mysql data installation...
2020-04-06T00:58:32.184667Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 28104
2020-04-06T00:58:35.251060Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=32M'.
2020-04-06T00:58:35.251065Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-04-06T00:58:35.251198Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-04-06T00:58:36.520771Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Error setting root pass using /usr/bin/mysqladmin. Trying SET PASSWORD.
Setting password: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'evg7EhOOekPcW';
*********************************
We seem to have an error when trying to SET PASSWORD FOR 'root'@'localhost'
*********************************
[root@mail custombuild]#
Found /usr/local/directadmin/custombuild/mysql/mysql-community-client-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-devel-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-server-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Stopping mysqld ...
Updating MySQL 8.0.17 to 8.0.17
warning: mysql-community-client-8.0.17-1.el8.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql-community-common-8.0.17-1.e################################# [ 20%]
2:mysql-community-libs-8.0.17-1.el8################################# [ 40%]
3:mysql-community-client-8.0.17-1.e################################# [ 60%]
4:mysql-community-server-8.0.17-1.e################################# [ 80%]
5:mysql-community-devel-8.0.17-1.el################################# [100%]
[/usr/lib/tmpfiles.d/mdadm.conf:1] Line references path below legacy directory /var/run/, updating /var/run/mdadm → /run/mdadm; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/mysql.conf:23] Line references path below legacy directory /var/run/, updating /var/run/mysqld → /run/mysqld; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/pesign.conf:1] Line references path below legacy directory /var/run/, updating /var/run/pesign → /run/pesign; please update the tmpfiles.d/ drop-in file accordingly.
[/usr/lib/tmpfiles.d/radvd.conf:1] Line references path below legacy directory /var/run/, updating /var/run/radvd → /run/radvd; please update the tmpfiles.d/ drop-in file accordingly.
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
/var/lib/mysql/mysql does not exist, running clean mysql data installation...
2020-04-06T00:58:32.184667Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.17) initializing of server in progress as process 28104
2020-04-06T00:58:35.251060Z 0 [ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=32M'.
2020-04-06T00:58:35.251065Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2020-04-06T00:58:35.251198Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-04-06T00:58:36.520771Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Error setting root pass using /usr/bin/mysqladmin. Trying SET PASSWORD.
Setting password: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'evg7EhOOekPcW';
*********************************
We seem to have an error when trying to SET PASSWORD FOR 'root'@'localhost'
*********************************
[root@mail custombuild]#
[ERROR] [MY-000067] [Server] unknown variable 'query_cache_size=32M'.
[ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
looks like you are trying not to update but to upgrade mysql
[ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
looks like you are trying not to update but to upgrade mysql
Theo Lodewijk
Verified User
- Joined
- Feb 5, 2020
- Messages
- 17
I have find the solution and posted on https://forum.directadmin.com/threads/mysql-8-0.60999/#post-312051