MySQL 8 Upgrade Instructions


  • | 967 points

    These are the exact instructions to upgrade MySQL to version 8 on Largon v.4.0.16 on Windows 10 1909 x64. If you have already ran Mysql in Laragon you can skip to step 3.

    BACK UP YOUR DATA FILE BEFORE YOU DO ANYTHING!

    1. Install Laragon
    2. Click Start All. This will create the mysql folder and files at C:\laragon\data\mysql
    3. Stop Laragon.
    4. Go to Quick Add Configuration (Menu->Tools->Quick add->Configuration)
    5. Uncomment the mysql-8.0 (Line 12, delete # sign)
    6. Edit the mysql version to current version. (Change mysql-8.0.13-winx64.zip TO mysql-8.0.20-winx64.zip )
    7. Save & Close file
    8. Go back to Quick Add and select mysql-8.0. Download will start.
    9. After download, go to Menu->Mysql->Version and select mysql-8.0.20-winx64
    10. Rename C:\laragon\data\mysql to C:\laragon\data\mysql-8 (BACK UP THE mysql FOLDER FIRST!!!!!)
    11. Click Start All Button
    12. If you get VCRUNTIME140_1 error, install updated Microsoft Visual C++ from https://aka.ms/vs/16/release/vc_redist.x64.exe
    13. Stop Laragon.
    14. Restart Laragon
    15. If Windows Firewall opens give permissions for mysql
    16. ALL DONE!

  • | 79 points

    Awesome!!! It work fine.
    Thanks very much.


  • | 216 points

    @benanamen thanks for the guide, worked fine, but after completing all these steps, you still have to close Laragon and re-start it before it works. Whether you are getting VCRUNTIME140_1 error or not we still have to do it, or else heidiSQL as well as phpMyadmin give connectivity error. Just wanted to point that out, it may be of use to some one facing this same problem.


  • | 967 points

    @bnbabu55 said in MySQL 8 Upgrade Instructions:

    you still have to close Laragon and re-start it before it works

    Did you not see step #13 and #14?


  • | 216 points

    @benanamen my bad, missed it in a hurry, thanks for pointing that out.


  • | 357 points

    I would like to share My solution for this I used 64bit version and its in my PC "D" drive with no mysql root password

    1.Install c++ redistribution package from Microsoft site "VC_redist.x64.exe"

    1. Download mysql8.0.x-winx64.zip archive
    2. Extract to "D:\laragon\bin\mysql" directory change drive letter accordingly
    3. Stop laragon and and select mysql8.0-winx64 version from Laragon Menu ->version->mysql-8.0.x-win64
    4. Now start the Service wait for few seconds to allow initialization
    5. Stop mysql server go to directory "D:\laragon\bin\mysql\mysql-8.0.x-winx64\bin" run "mysqld stop" this will stop sql
    6. Go to "D:\laragon\data" rename existing "mysql-8" folder to mysql.bk and rename "mysql" folder to mysql-8
    7. Stop Laragon and restart it again
    8. open cmd.exe as Administrator
    9. go to directory "D:\laragon\bin\mysql\mysql-8.0.x-winx64" run "mysql_upgrade.exe -u root -p" I didnt have password so i left it blank after -p
    10. Click Enter without password when prompted Wait for Few minutes to allow mysql do the upgrade
    11. now go to mysql terminal from Laragon enter comand "mysql -u root -p" Click Enter without password
      13.Now enter the following comand "ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';" replace NewPassword with your own one
      14.Now Restart Laragon again
    12. If you have Phpmyadmin installed it should work now if you dont have install it from add feature

    Chears


  • | 3022 points

    hey, i have a error, when i try execute mysql 8

    2021-04-08T04:27:11.034412Z 0 [System] [MY-010116] [Server] C:\laragon\bin\mysql\mysql-8.0.23-winx64\bin\mysqld (mysqld 8.0.23) starting as process 15080
    2021-04-08T04:27:11.093886Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
    2021-04-08T04:27:11.094795Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
    2021-04-08T04:27:12.087101Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.088253Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.089806Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__bookmark.ibd' OS error: 82
    2021-04-08T04:27:12.091081Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__bookmark because it could not be opened.
    2021-04-08T04:27:12.092446Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.093532Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.095140Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__central_columns.ibd' OS error: 82
    2021-04-08T04:27:12.096499Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__central_columns because it could not be opened.
    2021-04-08T04:27:12.097993Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.099313Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.101551Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__column_info.ibd' OS error: 82
    2021-04-08T04:27:12.103132Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__column_info because it could not be opened.
    2021-04-08T04:27:12.104631Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.105893Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.107414Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__designer_settings.ibd' OS error: 82
    2021-04-08T04:27:12.108854Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__designer_settings because it could not be opened.
    2021-04-08T04:27:12.110381Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.111493Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.113202Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__export_templates.ibd' OS error: 82
    2021-04-08T04:27:12.114649Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__export_templates because it could not be opened.
    2021-04-08T04:27:12.116535Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.118111Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.119707Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__favorite.ibd' OS error: 82
    2021-04-08T04:27:12.121129Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__favorite because it could not be opened.
    2021-04-08T04:27:12.122776Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.123950Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.125510Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__history.ibd' OS error: 82
    2021-04-08T04:27:12.128117Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__history because it could not be opened.
    2021-04-08T04:27:12.129794Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.133978Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.139488Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__navigationhiding.ibd' OS error: 82
    2021-04-08T04:27:12.159060Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__navigationhiding because it could not be opened.
    2021-04-08T04:27:12.169066Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.171419Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.173787Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__pdf_pages.ibd' OS error: 82
    2021-04-08T04:27:12.175894Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__pdf_pages because it could not be opened.
    2021-04-08T04:27:12.178124Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.179915Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.183573Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__recent.ibd' OS error: 82
    2021-04-08T04:27:12.186005Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__recent because it could not be opened.
    2021-04-08T04:27:12.188276Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.190558Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.193747Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__relation.ibd' OS error: 82
    2021-04-08T04:27:12.195844Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__relation because it could not be opened.
    2021-04-08T04:27:12.198108Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.201129Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.203820Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__savedsearches.ibd' OS error: 82
    2021-04-08T04:27:12.206083Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__savedsearches because it could not be opened.
    2021-04-08T04:27:12.210520Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.212584Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.218792Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__table_coords.ibd' OS error: 82
    2021-04-08T04:27:12.243128Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__table_coords because it could not be opened.
    2021-04-08T04:27:12.244995Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.246522Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.256590Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__table_info.ibd' OS error: 82
    2021-04-08T04:27:12.275500Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__table_info because it could not be opened.
    2021-04-08T04:27:12.287461Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.292904Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.297972Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__table_uiprefs.ibd' OS error: 82
    2021-04-08T04:27:12.309357Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__table_uiprefs because it could not be opened.
    2021-04-08T04:27:12.312807Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.314181Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.319388Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__tracking.ibd' OS error: 82
    2021-04-08T04:27:12.322741Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__tracking because it could not be opened.
    2021-04-08T04:27:12.324521Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.326083Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.327796Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__userconfig.ibd' OS error: 82
    2021-04-08T04:27:12.329610Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__userconfig because it could not be opened.
    2021-04-08T04:27:12.331423Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.333826Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.335951Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__usergroups.ibd' OS error: 82
    2021-04-08T04:27:12.337640Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__usergroups because it could not be opened.
    2021-04-08T04:27:12.339364Z 1 [ERROR] [MY-012611] [InnoDB] Operating system error number 3 in a file operation.
    2021-04-08T04:27:12.340841Z 1 [ERROR] [MY-012612] [InnoDB] The error means the system cannot find the path specified. It might be too long or it might not exist.
    2021-04-08T04:27:12.342698Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: '.\phpmyadmin\pma__users.ibd' OS error: 82
    2021-04-08T04:27:12.344602Z 1 [Warning] [MY-012019] [InnoDB] Ignoring tablespace phpmyadmin/pma__users because it could not be opened.
    2021-04-08T04:27:12.590144Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
    2021-04-08T04:27:12.594441Z 1 [ERROR] [MY-010781] [Server] Found .\mysql\index_stats.frm file in mysql schema. DD will create .ibd file with same name. Please rename table and start upgrade process again.
    2021-04-08T04:27:12.597464Z 1 [ERROR] [MY-010336] [Server] Found .frm file with same name as one of the Dictionary Tables.
    2021-04-08T04:27:12.599747Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
    2021-04-08T04:27:12.601310Z 0 [ERROR] [MY-013236] [Server] The designated data directory C:\laragon\data\mysql-8\ is unusable. You can remove all files that the server added to it.
    2021-04-08T04:27:12.604714Z 0 [ERROR] [MY-010119] [Server] Aborting
    2021-04-08T04:27:12.761414Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.23-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.
    2021-04-08T04:27:12.763468Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.


  • | 343 points

    @benanamen i'm using laragon portable v.5.0.0 210523 fresh download, when i follow step by step that your mention, in step 2 laragon not create the mysql folder because default using mysql-5 folder data/mysql is in bin/mysql5xxx/data/. When using mysql-8 it cannot start and need to upgrading.0_1627450610001_mysqld.log

    "mysqld: Table 'mysql.plugin' doesn't exist
    2021-07-28T05:33:49.248810Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure."

    anybody have solution to this?


  • | 343 points

    @Safie-Misri said in MySQL 8 Upgrade Instructions:

    @benanamen i'm using laragon portable v.5.0.0 210523 fresh download, when i follow step by step that your mention, in step 2 laragon not create the mysql folder because default using mysql-5 folder data/mysql is in bin/mysql5xxx/data/. When using mysql-8 it cannot start and need to upgrading.0_1627450610001_mysqld.log

    "mysqld: Table 'mysql.plugin' doesn't exist
    2021-07-28T05:33:49.248810Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure."

    anybody have solution to this?

    Ok, i just get the solution on this post: https://forum.laragon.org/topic/1766/laragon-4-0-16-mysql-8-0-18-mysql-cannot-start


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.