[WilandTech]

I have opened a support ticket as well.

We are able to connect to a server just fine when we disable REQUIRE SSL in the user grants in the mysql database. We have REQUIRE SSL turned on for all accounts due to security policies.

I tried to connect to a 5.6 mysql server and received the same error of 1045 as well.

I have 10.4.2-0 installed as well, and If i open that and attempt to connect to any database it connects through just fine. We also use 9.35 and 9.33 within our company and those have no problem either.

[WilandTech]

The stop query button does not work for us. We use SSL certificates for connecting into our database and receive an error 1045 message back whenever we click on it.

I am going to try and just kill the query from a second session as soon as it launches. Thank you.

[WilandTech]

That resolves our issue with 10.42, But is there the same capability in 9.33? I was unable to find a stop button.

[WilandTech]

Thank you, Sent in to the email.

[WilandTech]

I apologize. SQLYog Enterprise 10.3 and Yes the box is checked.

[WilandTech]

In the .ini file we added the line InfoTabOpen=0 under all connections so that it wouldn't open any longer thus removing the issue with the INFO tab that was fixed in 9.61

[WilandTech]

We already maintain the database and we cannot run OPTIMIZE or REPAIR without major issues. Is there a way to completely disable the INFO tab from opening? We have tried through the .ini file but that doesn't work anymore in 9.6.3 as the INFO tab opens on a user's first connection. It worked in 9.33 to disable the tab though.

[WilandTech]

1) We cannot do this. We have to schedule outage windows in order to do any maintenance and this slowness appears on every server.

2) We are running 5.1.49sp1

3) MyISAM tables

4) We are working with a ~4tb database with hundreds of thousands of tables and hundreds of millions of rows.

5) Load a connection to your server and open the History tab and the Info Tab, Select a database to connect to from the drop down above, then click the close on the INFO tab, then check the history. I will attach a screen of what happens (partial view due to security).

6) We are using 9.33 GA company wide and currently enforce INFO tab to be off due to the Issue found and fixed in 9.6.1 – This issue with the info tab is what is preventing us from upgrading. We previously used 9.3 and it had an option within the settings to disable the INFO Tab. 9.33 would allows us to make sure the INFO tab was turned off by configuring it through the .ini file.

“If you close the INFO tab and next close SQLyog, the INFO tab will not open next time you open SQLyog.”

Yes, but this has to be done for every user, on every connection they open. We need this to be already disabled by use of a .ini file that we distribute.

**For the image this was done on our development server, but is present on all other servers, Development and production**

For the image all blank spots are the database name. I connected to the server, I selected a database, then i clicked on the red X for Info tab and it launched all queries after the Use ' ' command.

[Author]

Posts