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

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

@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".

Ghot said:

@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

Revo Uninstaller Free

Download Revo Uninstaller Free helps you to uninstall software and remove unwanted programs easily. Remove all uninstall leftovers and traces

www.revouninstaller.com

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?

Click to expand...

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?

sdowney717 said:

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

Click to expand...

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.



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

Ghot said:

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.

Click to expand...

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

sdowney717 said:

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

Click to expand...

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.

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

installing MySQL 8.0.36 on the Dell 7530 laptop
working

??? 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)

sdowney717 said:

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

Click to expand...

I do boo-boos all the time. It's part of learning.

mecanicogolf said:

I do boo-boos all the time. It's part of learning.

Click to expand...

It’s certainly how I learned.

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

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 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




Cheers
jimbo

jimbo45 said:

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

Click to expand...

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.

sdowney717 said:

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.

Click to expand...

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.



cheers
jimbo

jimbo45 said:

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

Click to expand...

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

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.

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.

took me watching vid of how to use mysqldump for backup and restore of databases to understand it works. I tested it.