Solved yesterday I installed mysql 8.0.36 fine, I uninstalled it using its uninstaller, install today fails with error


sdowney717

Well-known member
Member
VIP
Local time
1:57 PM
Posts
1,063
OS
windows 11
how to fix this?
I am experimenting with different versions of MySQL
I installed 8.0.36, uninstalled it
Then installed 5.1
uninstalled it,
Then tried to install 8.0.36 and I get failure.
I rebooted did not help, no MySQL is currently installed.

Perhaps after installing MySQL, you need a windows wipeout to start fresh!

This MSI installer goes on to the web to download a huge package.
But it never gets anywhere. Could it be their website is full of errors today?

try it , and it wont install unless you tell it when it works

1710248177238.png
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
@sdowney717


I would install 5.1 again, and then use REVO to uninstall it... make sure to do the "scan for leftovers".
Then... try and install 8.0.36





Some programs leave behind some registry entries that the installer of the new version can read.
Especially on paid software.

Over the years... I've just relied on REVO to get all the leftover bits, after an uninstall.
I just gave up, relying on a program's uninstaller to do the job properly.

Another option is to restore from a backup made before you started playing around with MySQL versions.



Could also be that their server is having problems, or that the internet glitched during the download?




Note: The only exception to my REVO method is 3rd party antivirus programs.
For them, I always Google for their "removal tool".
 
Last edited:

My Computers

System One System Two

  • OS
    Win 11 Home ♦♦♦22631.3737 ♦♦♦♦♦♦♦23H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® [May 2020]
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    Asus Pro WS X570-ACE (BIOS 4702)
    Memory
    G.Skill (F4-3200C14D-16GTZKW)
    Graphics Card(s)
    EVGA RTX 2070 (08G-P4-2171-KR)
    Sound Card
    Realtek ALC1220P / ALC S1220A
    Monitor(s) Displays
    Dell U3011 30"
    Screen Resolution
    2560 x 1600
    Hard Drives
    2x Samsung 860 EVO 500GB,
    WD 4TB Black FZBX - SATA III,
    WD 8TB Black FZBX - SATA III,
    DRW-24B1ST CD/DVD Burner
    PSU
    PC Power & Cooling 750W Quad EPS12V
    Case
    Cooler Master ATCS 840 Tower
    Cooling
    CM Hyper 212 EVO (push/pull)
    Keyboard
    Ducky DK9008 Shine II Blue LED
    Mouse
    Logitech Optical M-100
    Internet Speed
    300/300
    Browser
    Firefox (latest)
    Antivirus
    Bitdefender Internet Security
    Other Info
    Speakers: Klipsch Pro Media 2.1
  • Operating System
    Windows XP Pro 32bit w/SP3
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® (not in use)
    CPU
    AMD Athlon 64 X2 5000+ (OC'd @ 3.2Ghz)
    Motherboard
    ASUS M2N32-SLI Deluxe Wireless Edition
    Memory
    TWIN2X2048-6400C4DHX (2 x 1GB, DDR2 800)
    Graphics card(s)
    EVGA 256-P2-N758-TR GeForce 8600GT SSC
    Sound Card
    Onboard
    Monitor(s) Displays
    ViewSonic G90FB Black 19" Professional (CRT)
    Screen Resolution
    up to 2048 x 1536
    Hard Drives
    WD 36GB 10,000rpm Raptor SATA
    Seagate 80GB 7200rpm SATA
    Lite-On LTR-52246S CD/RW
    Lite-On LH-18A1P CD/DVD Burner
    PSU
    PC Power & Cooling Silencer 750 Quad EPS12V
    Case
    Generic Beige case, 80mm fans
    Cooling
    ZALMAN 9500A 92mm CPU Cooler
    Mouse
    Logitech Optical M-BT96a
    Keyboard
    Logitech Classic Keybooard 200
    Internet Speed
    300/300
    Browser
    Firefox 3.x ??
    Antivirus
    Symantec (Norton)
    Other Info
    Still assembled, still runs. Haven't turned it on for 13 years?
@sdowney717


I would install 5.1 again, and then use REVO to uninstall it... make sure to do the "scan for leftovers".
Then... try and install 8.0.36





Some programs leave behind some registry entries that the installer of the new version can read.
Especially on paid software.

Over the years... I've just relied on REVO to get all the leftover bits, after an uninstall.
I just gave up, relying on a program's uninstaller to do the job properly.



Could also be that their server is having problems, or that the internet glitched during the download?
Revo is nice get rid of a lot of things like registry entries etc...
Revo deletes all mysql stuff.
But I am stuck as for some reason I can not install any newer myql servers anymore.
It appears 5.1 installed ok as it uses a different kind of installer
5.5 and up installs give internal error failure
But I did have 8.0.36 installed yesterday

Maybe someone will like to try these install-uninstalls on their PC?
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
Revo is nice get rid of a lot of things like registry entries etc...
Revo deletes all mysql stuff.
But I am stuck as for some reason I can not install any newer myql servers anymore.
It appears 5.1 installed ok


Then restore from a backup made before all this messing around started?
I do this all the time after I'm done "testing" things. Even those times when nothing breaks.


Backup software is my... Time Machine. :D



Whatever you're doing... remember, today is patch Tuesday. ^^
 

My Computers

System One System Two

  • OS
    Win 11 Home ♦♦♦22631.3737 ♦♦♦♦♦♦♦23H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® [May 2020]
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    Asus Pro WS X570-ACE (BIOS 4702)
    Memory
    G.Skill (F4-3200C14D-16GTZKW)
    Graphics Card(s)
    EVGA RTX 2070 (08G-P4-2171-KR)
    Sound Card
    Realtek ALC1220P / ALC S1220A
    Monitor(s) Displays
    Dell U3011 30"
    Screen Resolution
    2560 x 1600
    Hard Drives
    2x Samsung 860 EVO 500GB,
    WD 4TB Black FZBX - SATA III,
    WD 8TB Black FZBX - SATA III,
    DRW-24B1ST CD/DVD Burner
    PSU
    PC Power & Cooling 750W Quad EPS12V
    Case
    Cooler Master ATCS 840 Tower
    Cooling
    CM Hyper 212 EVO (push/pull)
    Keyboard
    Ducky DK9008 Shine II Blue LED
    Mouse
    Logitech Optical M-100
    Internet Speed
    300/300
    Browser
    Firefox (latest)
    Antivirus
    Bitdefender Internet Security
    Other Info
    Speakers: Klipsch Pro Media 2.1
  • Operating System
    Windows XP Pro 32bit w/SP3
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® (not in use)
    CPU
    AMD Athlon 64 X2 5000+ (OC'd @ 3.2Ghz)
    Motherboard
    ASUS M2N32-SLI Deluxe Wireless Edition
    Memory
    TWIN2X2048-6400C4DHX (2 x 1GB, DDR2 800)
    Graphics card(s)
    EVGA 256-P2-N758-TR GeForce 8600GT SSC
    Sound Card
    Onboard
    Monitor(s) Displays
    ViewSonic G90FB Black 19" Professional (CRT)
    Screen Resolution
    up to 2048 x 1536
    Hard Drives
    WD 36GB 10,000rpm Raptor SATA
    Seagate 80GB 7200rpm SATA
    Lite-On LTR-52246S CD/RW
    Lite-On LH-18A1P CD/DVD Burner
    PSU
    PC Power & Cooling Silencer 750 Quad EPS12V
    Case
    Generic Beige case, 80mm fans
    Cooling
    ZALMAN 9500A 92mm CPU Cooler
    Mouse
    Logitech Optical M-BT96a
    Keyboard
    Logitech Classic Keybooard 200
    Internet Speed
    300/300
    Browser
    Firefox 3.x ??
    Antivirus
    Symantec (Norton)
    Other Info
    Still assembled, still runs. Haven't turned it on for 13 years?
Then restore from a backup made before all this messing around started?
I do this all the time after I'm done "testing" things. Even those times when nothing breaks.


Backup software is my... Time Machine. :D
yes, I do have a complete backup made before all this mysql.
I am gong to try the 5.7 server on a different pc first
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
yes, I do have a complete backup made before all this mysql.
I am gong to try the 5.7 server on a different pc first



Excellent plan... break everything you're gonna break... then restore from a backup, when you're finished. ^^
I'm serious, by the way.

I "break" stuff all the time... then I just erase all my boo-boos with a restore from a backup.
Best thing ever invented. :-)
 
Last edited:

My Computers

System One System Two

  • OS
    Win 11 Home ♦♦♦22631.3737 ♦♦♦♦♦♦♦23H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® [May 2020]
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    Asus Pro WS X570-ACE (BIOS 4702)
    Memory
    G.Skill (F4-3200C14D-16GTZKW)
    Graphics Card(s)
    EVGA RTX 2070 (08G-P4-2171-KR)
    Sound Card
    Realtek ALC1220P / ALC S1220A
    Monitor(s) Displays
    Dell U3011 30"
    Screen Resolution
    2560 x 1600
    Hard Drives
    2x Samsung 860 EVO 500GB,
    WD 4TB Black FZBX - SATA III,
    WD 8TB Black FZBX - SATA III,
    DRW-24B1ST CD/DVD Burner
    PSU
    PC Power & Cooling 750W Quad EPS12V
    Case
    Cooler Master ATCS 840 Tower
    Cooling
    CM Hyper 212 EVO (push/pull)
    Keyboard
    Ducky DK9008 Shine II Blue LED
    Mouse
    Logitech Optical M-100
    Internet Speed
    300/300
    Browser
    Firefox (latest)
    Antivirus
    Bitdefender Internet Security
    Other Info
    Speakers: Klipsch Pro Media 2.1
  • Operating System
    Windows XP Pro 32bit w/SP3
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built by Ghot® (not in use)
    CPU
    AMD Athlon 64 X2 5000+ (OC'd @ 3.2Ghz)
    Motherboard
    ASUS M2N32-SLI Deluxe Wireless Edition
    Memory
    TWIN2X2048-6400C4DHX (2 x 1GB, DDR2 800)
    Graphics card(s)
    EVGA 256-P2-N758-TR GeForce 8600GT SSC
    Sound Card
    Onboard
    Monitor(s) Displays
    ViewSonic G90FB Black 19" Professional (CRT)
    Screen Resolution
    up to 2048 x 1536
    Hard Drives
    WD 36GB 10,000rpm Raptor SATA
    Seagate 80GB 7200rpm SATA
    Lite-On LTR-52246S CD/RW
    Lite-On LH-18A1P CD/DVD Burner
    PSU
    PC Power & Cooling Silencer 750 Quad EPS12V
    Case
    Generic Beige case, 80mm fans
    Cooling
    ZALMAN 9500A 92mm CPU Cooler
    Mouse
    Logitech Optical M-BT96a
    Keyboard
    Logitech Classic Keybooard 200
    Internet Speed
    300/300
    Browser
    Firefox 3.x ??
    Antivirus
    Symantec (Norton)
    Other Info
    Still assembled, still runs. Haven't turned it on for 13 years?
I managed to get MySQL 5.1 DE working fine with using the 5.15 ODBC connector in my old VB6 database program I wrote.
It works fine on win11, including now the VB6 IDE

I had royally screwed up installing a MySQL 5.1 ALPHA ODBC connector and it kept crashing and crashing the VB6 IDE

I am gonna try the MySQL 8.0.36 DE on my laptop which has never seen a Mysql anything and see it if runs
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
installing MySQL 8.0.36 on the Dell 7530 laptop
working
1710257220372.png
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
??? MySql should install on any windows 64 bit operating system. If it isn’t, then you possibly broke something with all the messing around you do.
Would pay dearly to know why you want MySql installed. My guess is you’re trying to create the worlds largest world wide recepie book. OR you’re a AI droid wanting to memorise and catagorise infrmation on every human on the planet (Kind of like Rain Man)
 

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2 Build: 22631.3593
    Computer type
    PC/Desktop
    Manufacturer/Model
    Sin-built
    CPU
    Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz (4th Gen?)
    Motherboard
    ASUS ROG Maximus VI Formula
    Memory
    32.0 GB of I forget and the box is in storage.
    Graphics Card(s)
    Gigabyte nVidia GeForce GTX 1660 Super OC 6GB
    Sound Card
    Onboard
    Monitor(s) Displays
    4 x LG 23MP75 1 x 24" LG M38H 1 x 32" LF6300 TV Monitor 1 x Wacom Pro 22" Tablet
    Screen Resolution
    All over the place
    Hard Drives
    2 x WD something Something 8TB HDD's / 2 x WD something Something 4TB HDD's / 1 x EVO 1TB SSD / 2 x QVO 1TB SSD's / 1 x EVO 250 GB SSD / 2 x QVO 1TB (External Hub) / 1 x EVO 1TB (Portable Backup Case)
    PSU
    Silverstone 1500
    Case
    NZXT Phantom 820 Full-Tower Case
    Cooling
    Noctua NH-D15 Elite Class Dual Tower CPU Cooler / 6 x EziDIY 120mm / 2 x Corsair 140mm somethings / 1 x 140mm Thermaltake something / 2 x 200mm Corsair.
    Keyboard
    Corsair K95 / Logitech diNovo Edge Wireless
    Mouse
    Logitech G402 / G502 / Mx Masters / MX Air Cordless
    Internet Speed
    100/40Mbps
    Browser
    All sorts
    Antivirus
    Kaspersky Premium
    Other Info
    I’m on a horse.
  • Operating System
    Windows 11 Pro 22621.2215
    Computer type
    Laptop
    Manufacturer/Model
    LENOVO Yoga 7i EVO OLED 14" Touchscreen i5 12 Core 16GB/512GB
    CPU
    Intel Core 12th Gen i5-1240P Processor (1.7 - 4.4GHz)
    Memory
    16GB LPDDR5 RAM
    Graphics card(s)
    Graphics processor is an Intel Iris Xe
    Sound Card
    optimized with Dolby Atmos®
    Screen Resolution
    QHD 2880 x 1800 OLED
    Hard Drives
    M.2 512GB
    Other Info
    …still on a horse.
I managed to get MySQL 5.1 DE working fine with using the 5.15 ODBC connector in my old VB6 database program I wrote.
It works fine on win11, including now the VB6 IDE

I had royally screwed up installing a MySQL 5.1 ALPHA ODBC connector and it kept crashing and crashing the VB6 IDE

I am gonna try the MySQL 8.0.36 DE on my laptop which has never seen a Mysql anything and see it if runs
I do boo-boos all the time. It's part of learning.
 

My Computer

System One

  • OS
    Win11/10 Dual Boot
    Computer type
    Laptop
    Manufacturer/Model
    HP ENVY
    CPU
    i5 Core 7200U@2.50GHz
    Motherboard
    HP 81AD (U3E1)
    Memory
    12GB
    Graphics Card(s)
    Generic PnP Monitor (1920x1080@60Hz) Intel HD Graphics 620 (HP)
    Sound Card
    Conexant ISST audio
    Monitor(s) Displays
    Generic PnP Monitor
    Screen Resolution
    1536x864 pixels
    Hard Drives
    HGST HTS721010A9E630
    Case
    HP ENVY SILVER
    Cooling
    A fan.
    Keyboard
    USA
    Mouse
    Logitec Anywhere 2
    Internet Speed
    Good enough for me!
    Browser
    Firefox/Edge
    Antivirus
    Windows Defender

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2 Build: 22631.3593
    Computer type
    PC/Desktop
    Manufacturer/Model
    Sin-built
    CPU
    Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz (4th Gen?)
    Motherboard
    ASUS ROG Maximus VI Formula
    Memory
    32.0 GB of I forget and the box is in storage.
    Graphics Card(s)
    Gigabyte nVidia GeForce GTX 1660 Super OC 6GB
    Sound Card
    Onboard
    Monitor(s) Displays
    4 x LG 23MP75 1 x 24" LG M38H 1 x 32" LF6300 TV Monitor 1 x Wacom Pro 22" Tablet
    Screen Resolution
    All over the place
    Hard Drives
    2 x WD something Something 8TB HDD's / 2 x WD something Something 4TB HDD's / 1 x EVO 1TB SSD / 2 x QVO 1TB SSD's / 1 x EVO 250 GB SSD / 2 x QVO 1TB (External Hub) / 1 x EVO 1TB (Portable Backup Case)
    PSU
    Silverstone 1500
    Case
    NZXT Phantom 820 Full-Tower Case
    Cooling
    Noctua NH-D15 Elite Class Dual Tower CPU Cooler / 6 x EziDIY 120mm / 2 x Corsair 140mm somethings / 1 x 140mm Thermaltake something / 2 x 200mm Corsair.
    Keyboard
    Corsair K95 / Logitech diNovo Edge Wireless
    Mouse
    Logitech G402 / G502 / Mx Masters / MX Air Cordless
    Internet Speed
    100/40Mbps
    Browser
    All sorts
    Antivirus
    Kaspersky Premium
    Other Info
    I’m on a horse.
  • Operating System
    Windows 11 Pro 22621.2215
    Computer type
    Laptop
    Manufacturer/Model
    LENOVO Yoga 7i EVO OLED 14" Touchscreen i5 12 Core 16GB/512GB
    CPU
    Intel Core 12th Gen i5-1240P Processor (1.7 - 4.4GHz)
    Memory
    16GB LPDDR5 RAM
    Graphics card(s)
    Graphics processor is an Intel Iris Xe
    Sound Card
    optimized with Dolby Atmos®
    Screen Resolution
    QHD 2880 x 1800 OLED
    Hard Drives
    M.2 512GB
    Other Info
    …still on a horse.
yes, I got everything working on the 7530 dell laptop using mysql 8 database server and mysql 8 odbc connector with my vb6 program

I had to change one thing in my code in 48 places, the mysql server 8 cannot use TIMESTAMP(14) for a data type, has to be just TIMESTAMP. And that caused me a lot of trouble with myql 8 trying to figure things out. I would create databases, but the table creation statements would all error, leaving a mostly empty database. So when my compiled program ran on the win 11 laptop it also died hard with an error code that was useless to comprehend anything. Putting VB6 IDE on the laptop allowed me to step thru the program and see it in real time where the error happened.

link to issue I had on vbforums
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
I still dont have msql 8 on my desktop, but I don't need it here as I can use the laptop.
Mysql over the years of various versions has chosen to put it's database files all over the place without any consistancy.
Today with myql server 8, they put it under program data folder.
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
My experience is to install Mariadb rather than the oracle MySql version. The commands and syntax are the same but the thing always works properly too plus no problem in running a query on EXCEL to get data from Mariadb into EXCEL which can be quite useful at times.

Works on windows without problems. Install the obdc driver too.

Here's import into EXCEL from the standard test database classic models you can get from the web of customers table from the db. Just use in EXCEl get data ->from msquery

Screenshot 2024-03-13 102925.png


Cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
My experience is to install Mariadb rather than the oracle MySql version. The commands and syntax are the same but the thing always works properly too plus no problem in running a query on EXCEL to get data from Mariadb into EXCEL which can be quite useful at times.

Works on windows without problems. Install the obdc driver too.

Here's import into EXCEL from the standard test database classic models you can get from the web of customers table from the db. Just use in EXCEl get data ->from msquery

View attachment 90016


Cheers
jimbo
Interesting if the syntax is the exact same. I know MSSQL server and Mysql server are not the same. I coded my program using if statements for the things that differ, like if it is Mysql then do this sql command, or if MSSQL then do that one. Plus I figure the connection strings differ somewhat.
It is not like you can just swap one server for another, you have to reprogram things to make it work.

I would have to change a lot of coding to do it in my vb6 program.
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
Interesting if the syntax is the exact same. I know MSSQL server and Mysql server are not the same. I coded my program using if statements for the things that differ, like if it is Mysql then do this sql command, or if MSSQL then do that one. Plus I figure the connection strings differ somewhat.
It is not like you can just swap one server for another, you have to reprogram things to make it work.

I would have to change a lot of coding to do it in my vb6 program.
You don't need to change anything -- assuming you were using MySQL rather than the Ms SQL server

For example (type either mariadb or mysql on the command line).

Identical on Windows too !!!

I'd give it a shot. Try it on a Windows VM first if you are a bit dubious.

Screenshot_20240313_180955.png

cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
You don't need to change anything -- assuming you were using MySQL rather than the Ms SQL server

For example (type either mariadb or mysql on the command line).

Identical on Windows too !!!

I'd give it a shot. Try it on a Windows VM first if you are a bit dubious.

View attachment 90060

cheers
jimbo
HaHa, dont have to change anything? Here is a snippet of my code to begin connection to a database server

Private Sub Form_Load()

'formloads even when not called

cmdCreate.Enabled = False
cmdTest.Enabled = False
cmdFix.Enabled = False
cmdOK.Enabled = False

Set clsElastic = New clsElasticForms
clsElastic.Form = Me
'get the system settings
currHRes = GetDeviceCaps(hdc, HORZRES)
currVRes = GetDeviceCaps(hdc, VERTRES)

If currHRes < 800 Then
clsElastic.MinHeight = 4000
clsElastic.MinWidth = 6000
Me.Height = 4000
Me.Width = 6000
End If

If currHRes >= 800 And currHRes < 1024 Then
clsElastic.MinHeight = 4000
clsElastic.MinWidth = 6000
Me.Height = 4400
Me.Width = 6200
End If

If currHRes >= 1024 Then
clsElastic.MinHeight = 4000
clsElastic.MinWidth = 6000
Me.Height = 5000
Me.Width = 7000
End If

'save old good connection string
If frmLogon.Connectstring <> "" Then PreviousConn2 = frmLogon.Connectstring
If frmLogon.Connectstring <> "" Then PreviousConn = frmLogon.Connectstring

'no current connection then assign it
If frmLogon.Connectstring = "MySQL" Then
frmLogon.cnConnector.ConnectionString = "" & _
"Provider=MSDASQL.1;" & _
"DRIVER={MySQL ODBC 3.51 Driver};" & _
"DESC=;" & _
"DATABASE=;" & _
"SERVER=localhost;" & _
"UID=;" & _
"PASSWORD=;" & _
"PORT=;" & _
"OPTION=35;" & _
"STMT=;"
PreviousConn = frmLogon.cnConnector.ConnectionString
frmLogon.Connectstring = frmLogon.cnConnector.ConnectionString
End If

'test for MySql, if not present then load default
WhichOne = InStr(1, frmLogon.Connectstring, "MySQL")
If WhichOne = 0 Then
If frmLogon.dbasetype = "SQLServer" Or frmLogon.dbasetype = "" Then
'Now you know that this is a SQLServer string so reset it for MySQL use

PreviousConn = "" & _
"Provider=MSDASQL.1;" & _
"DRIVER={MySQL ODBC 3.51 Driver};" & _
"DESC=;" & _
"DATABASE=;" & _
"SERVER=localhost;" & _
"UID=;" & _
"PASSWORD=;" & _
"PORT=;" & _
"OPTION=35;" & _
"STMT=;"

End If
End If

On Error GoTo errhandler
'find the current provider
A1 = InStr(1, PreviousConn, "Provider=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(0).Text = Mid(PreviousConn, A1 + 9, A2 - A1 - 9)
End If

'find the current driver
A1 = InStr(1, PreviousConn, "DRIVER=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(1).Text = Mid(PreviousConn, A1 + 7, A2 - A1 - 7)
End If

'find the current server
A1 = InStr(1, PreviousConn, "SERVER=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(2).Text = Mid(PreviousConn, A1 + 7, A2 - A1 - 7)
End If

'find the current database name
' A1 = InStr(1, PreviousConn, "DATABASE=", vbTextCompare)
' A2 = InStr(A1, PreviousConn, ";")
' Combo1.AddItem Mid(PreviousConn, A1 + 9, A2 - A1 - 9)


'find the current user
A1 = InStr(1, PreviousConn, "UID=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(4).Text = Mid(PreviousConn, A1 + 4, A2 - A1 - 4)
End If

'find the current password
A1 = InStr(1, PreviousConn, "PASSWORD=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(5).Text = Mid(PreviousConn, A1 + 9, A2 - A1 - 9)
End If

'find the current password if password is empty, like not used, so look for pwd
If Text1(5).Text = "" Then
A1 = InStr(1, PreviousConn, "PWD=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(5).Text = Mid(PreviousConn, A1 + 4, A2 - A1 - 4)
End If
End If
If A1 = 0 Then Text1(5).Text = ""
'find the current port
A1 = InStr(1, PreviousConn, "PORT=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(6).Text = Mid(PreviousConn, A1 + 5, A2 - A1 - 5)
End If

'find the current option
A1 = InStr(1, PreviousConn, "OPTION=", vbTextCompare)
If A1 <> 0 Then
A2 = InStr(A1, PreviousConn, ";")
If A2 = 0 Then A2 = Len(PreviousConn)
Text1(7).Text = Mid(PreviousConn, A1 + 7, A2 - A1 - 7)
End If



'Text1(0).Text = 'provider
'Text1(1).Text = 'driver
'Text1(2).Text = 'server
'combo1.text = 'dbname used to be text1(3).text
'Text1(4).Text = 'uid
'Text1(5).Text = "" 'password
'Text1(6).Text = 'port
'Text1(7).Text = 'option

Exit Sub

errhandler:
Text1(0).Text = "MSDASQL.1" 'provider
Text1(1).Text = "{MySQL ODBC 3.51 Driver}" 'driver
Text1(2).Text = "localhost" 'server
'combo1.text = 'dbname used to be text1(3).text
Text1(4).Text = "" 'uid
Text1(5).Text = "" 'password
Text1(6).Text = "3306" 'port
Text1(7).Text = "35" 'option

End Sub
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
I got the mysql installer to install both 5.7 and 8.0.36 installed and working on this AMD PC where days ago it had failed with 'internal error'
And I did nothing to the PC, did not restore a clone, it just now installs fine, and I don't have a clue as to why it failed earlier, except that maybe it was their servers having an error as it does go and get binaries from the web as it is a web installer. Just my luck it happened that day whatever happened.

I have had mysql5.7 working for days, and just now installed mysql 8.0.36 at port 3307 with mysql 5.7 at port 3306
And both fully function as servers, can connect to either one or simulataneusly.

I also was able to use their workbench tool to do a wizard migration of a database from 5.7 to 8.0.36 both across my Lan from a 5.7 server to a 8.0.36 server on a different win 11 PC and on a single PC localhost to itself (this AMD machine).

I had been looking and trying to get the database off 5.7 and onto 8.0.36 and all online mentioned methods people crowed about working were DUDS. Complete failures.

Was happy to see their Workbench migration tool actually finally work to do it.
If anyone actually knows another way, let me know. Just following online forum guides, they so far, all were fails.

I marked solved, but really a better word is RESOLVED, as I don't know why it did what it did earlier, I can't solve that, just make guesses.
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
These kinds of problems with Windows are always related to the registry. You should do a complete cleaning of all keys/entries related to that program.
 

My Computer

System One

  • OS
    Windows 11 Pro 22H2
took me watching vid of how to use mysqldump for backup and restore of databases to understand it works. I tested it.
 

My Computer

System One

  • OS
    windows 11
    Computer type
    PC/Desktop
    Manufacturer/Model
    some kind of old ASUS MB
    CPU
    old AMD B95
    Motherboard
    ASUS
    Memory
    8gb
    Hard Drives
    ssd WD 500 gb
Back
Top Bottom