Eventually, I managed to get a copy of MySQL 5.7 installed and running. So I got hold of the MSI file, and (tried) to install using that. But I can't run mysql_upgrade as I have no password, and is access denied. If I do: Copy MySQL Directory > initialize > install service > start service, it seems to be ok, until I look in the error log and see that virtually every table has the wrong structure. (and before someone suggests using the msi file - that's not an option as they are blocked on our network, and require me to jump through numerous hoops to even download it, let alone run it). So, how am I supposed to install MySQL if they don't give us the data directory (and therefore mysql user etc.
I found this post which says the password shouold be in the error log, but it isn't. T09:03:16.222540Z 0 Fatal error: Can't open and lock privilege tables: Table 'er' doesn't exist. If I create the Directory it seems to work, but there is still no MySQL directory, so when I run mysql_upgrade or try and (start service then) login, it fails. Mysqld: Can't change dir to 'C:\MySQL\DATA\' (Errcode: 2 - No such file or directory) But when I try this I get an error: c:\MySQL\bin\mysqld.exe -initialize -user=mysql Looking at the documentation I see that I am now supposed to initialize the data directory. If I try and create one by copying over from an existing database, I get an error.
But now I am starting to test 5.7, and I find that the zip file no longer contains a data directory?
This has worked fine for years (5.5 and earlier). I would basically 1) download the zip file,Ģ) copy the contents to the new location,ĥ) add in my template mysql directory (with default users) Historically I have always installed MySQL (on Windows) from a template based on the mysql-xxx-win64.zip file. This has probably been asked before, but I am struggling to find the answer.
0 kommentar(er)
