Toad World® Forums

Where do you change password for Local Storage Connection

I’ve been using Local Storage successfully, until I had to change my network password. Now I’m getting the following error:

There was a connect error. Check that the username and password are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled: Unable to connect to any of the specified Local Storage hosts. (Remembered answer: “OK”. Enable)

Where do you change the password? I right clicked on Local Storage Connection, Properties, but everything is grayed out and I don’t see where you would change a password anyway.

It’s defaulting to Builtin HUB connection, but I cannot change anything in this box.

There is not a need to every change the password for local storage. Where are your Local Storage data files stored? Are they different from the default?

Can you run TDP with command line arg to turn on logging and then try to connect to local storage?

…Toad.exe /log=all

After you produce the error please go to Help | About | AppDataDir and post the Toad.log file.

Sorry for using old post but I am also getting 'Local Storage Connection' issue and attaching the log file here...

2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: complete: sp_ui_tag_add.sql
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: complete: sp_ui_tag_clear.sql
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: complete: sp_ui_tag_remove.sql
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: Fail to execute updateHubSchema.sql --> CALL hub_migrate_20140116_1(
2019-11-13 21:19:32Z thread# 22 D HUBGUARDIAN 12056: 7: Error on rename of '.\hub_information_schema#sql-2ec0_4.frm' to '.\hub_information_schema\hub_object_types.frm' (Errcode: 13 - Permission denied)
2019-11-13 21:19:32Z E HUBGUARDIAN error: HubGuardian.StartGuardian(): Could not get Data Hub connection data
2019-11-13 21:19:32Z thread# 22 D HUBMETAOPERATIONS leaving: HubDatabaseMetaOperations.InitHubEngine(root@localhost)
2019-11-13 21:19:32Z thread# 22 D CreateConnection MySql.Data.MySqlClient.MySqlConnection: Username=root;Password=*****;Connection Timeout=15;Pooling=false;Interactive=true;Treat Tiny As Boolean=false;Allow User Variables=true;Functions Return String=true;Old Guids=true;Server=127.0.0.1;Port=64905;Protocol=socket;CharSet=utf8
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Message - Unable to connect to any of the specified MySQL hosts.
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Stack - at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Quest.Toad.CloudDB.CloudDBConnection.OpenInitialTestConnection()
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Message - There was a connect error. Check that the server, username, password and port are correct, that you have registered this user using the registration tab, and that the registered user has not been disabled
2019-11-13 21:19:33Z E PREPROCESS_EXCEPTION Error Stack - at Quest.Toad.CloudDB.CloudDBConnection.OpenInitialTestConnection()
at Quest.Toad.MySQL.MySQLConnection.DoBeforeConnect()