Toad for MySQL - General

Community Discussion

Rrralec
Follow / 29 Aug 2014 at 2:32pm / Toad for MySQL

Trouble connecting locally...

Expand content
Hello, I have been trying to connect to my own computer to simply learn and write queries for, at the moment, simple data sets in CSV format. My issue: regardless of which SQL program I use, be it mySql...

Hello, 

I have been trying to connect to my own computer to simply learn and write queries for, at the moment, simple data sets in CSV format. 

My issue: regardless of which SQL program I use, be it mySql WorkBench, HeidiSQL, SQLyog, Toad for MySQL, I cannot connect locally. 

I use the standard 

127.0.0.1

localhost

root

port 3306 

setttings and to no avail. 

I have created an exception in my Windows Firewall for port 3306, 

I cannot find Toad in the list of Services. 

I have tried every combination of the above settings in fields Host, Username, Password.

Is there anything I am missing? I'm almost beginning to think I misunderstand entirely what it means to connect locally... I have not set up a server, or have any previous database ready. 

A colleague of mine uses SequelPro on her Mac and simply imports CSV files to query them. 

Also, I have now attempted to connect locally using an SQL program using both of my computers... making it feel as if there really is something wrong with the way I'm attempting to connect. 

If anyone would be able to help, it would be much appreciated. I have never hit a roadblock so early in my attempts to learning a computer software, I am barely making it past the installation... 

Thank you. 

Alec

33 0 / Create an account to join the discussion.
Henrik Johnson
Follow / 14 Apr 2014 at 8:20pm / Toad for MySQL
Latest post by on 28 Aug 2014 at 7:49pm

Toad for MySQL 7.2 is released!

Expand content
The new stable version of Toad for MySQL 7.2 is now available for immediate download. Just head over to the download section and get it right now!

The new stable version of Toad for MySQL 7.2 is now available for immediate download.

Just head over to the download section and get it right now!

1412 9 / Create an account to join the discussion.
pstein
Follow / 24 Feb 2011 at 3:54pm / Toad for MySQL
Latest post by on 28 Aug 2014 at 3:39pm

How to change password for database aaa and user uuu?

Expand content
How can I change the password for (existing) database aaa and existing user uuu? is it only possible through cmdline or through Toad GUI as well? Peter
How can I change the password for (existing) database aaa and existing user uuu?

is it only possible through cmdline or through Toad GUI as well?

Peter
2752 2 / Create an account to join the discussion.
kulasart
Follow / 13 Aug 2014 at 11:10am / Toad for MySQL
Latest post by on 24 Aug 2014 at 3:26am

[ERROR] While trying to create group execute script

Expand content
I cant select multiple database schemas, from single server while creating Group Execute script. More than that - list with avalible schemas can not be created in Group Execute window. Exception: System...

I cant select multiple database schemas, from single server while creating Group Execute script.

More than that - list with avalible schemas can not be created in Group Execute window.

Exception: System.NullReferenceException
Message  : Object reference not set to an instance of an object.
Stack Trace:
    Quest.Toad.Grouping.GroupExecutionControl.AddTreeNode(TreeListNode parentTreeNode, ObjectTrl trl)
    Quest.Toad.Grouping.GroupExecutionControl.FetchDatabasesAndAdd(TreeListNode treeNodeParent, Connection conn)
    Quest.Toad.Grouping.GroupExecutionControl.PopulateDatabases(List`1 nodes)

 

Operating System
  Microsoft Windows 7 Professional  6.1.7601 AMD64
  Manufacturer: Microsoft Corporation

93 1 / Create an account to join the discussion.
snolan_484
Follow / 9 Aug 2013 at 5:18pm / Toad for MySQL
Latest post by on 19 Aug 2014 at 7:25pm

Error Message prevents Toad from closing

Expand content
I get an error disconnecting from time to time and when the error occurs it prevents Toad from closing. Once that happens, the only way to close Toad is to go to the Windows Task Manager and end the process...

I get an error disconnecting from time to time and when the error occurs it prevents Toad from closing. Once that happens, the only way to close Toad is to go to the Windows Task Manager and end the process. The error message is as follows:

System.ArgumentNullException
Value cannot be null.
Stack Trace:
at System.Threading.Monitor.ReliableEnterTimeout(Object obj, Int32 timeout, Boolean& lockTaken)
at Quest.Toad.Debugger.DebugProviderBase.Cancel()
at Quest.Toad.Debugger.DebugProviderBase.Dispose(Boolean disp)
at Quest.Toad.Debugger.DebugProviderBase.Dispose()
at Quest.Toad.Debugger.DebugClient.CloseDebugging(Connection connection)
at Quest.Toad.Debugger.DebugClient.ConnectionClosingHandler(Object sender, ConnectionClosingEventArgs e)
at Quest.Toad.Notification.NotificationManager.InternalConnectionClosing(Object sender, ConnectionClosingEventArgs args)
at Quest.Toad.Notification.NotificationManager.ConnectionClosing(Object sender, Connection connection)
at Quest.Toad.Gui.MainForm.OnFormClosing(FormClosingEventArgs e)
at System.Windows.Forms.Form.WmClose(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
at Quest.Toad.Gui.MainForm.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Unanswered 719 7 / Create an account to join the discussion.
hsheng
Follow / 14 Aug 2014 at 3:22pm / Toad for MySQL

Comparing replicated table contents

Expand content
Toad for MySQL (freeware) 7.2.0.2922 Get the following error while trying to compare a replicated table content on master and slave: Unknown type found during storing data. Type: System.UInt64 The...

Toad for MySQL (freeware) 7.2.0.2922

Get the following error while trying to compare a replicated table content on master and slave:

Unknown type found during storing data. Type: System.UInt64

The following is the table definition, identical on master and slave:

CREATE TABLE `inmemoryconfigproperties` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `MODULE_NM` varchar(64) DEFAULT NULL,
  `FUNCTION_NM` varchar(64) DEFAULT NULL,
  `NAME` varchar(128) NOT NULL,
  `VALUE` varchar(1024) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `inmemoryconfigproperties_unique_index_name` (`NAME`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

53 0 / Create an account to join the discussion.
pascal_jay_828
Follow / 3 Apr 2014 at 10:44am / Toad for MySQL
Latest post by on 8 Aug 2014 at 12:32pm

Bug: Manual submit auto submits when statement is executed again

Expand content
Hey there. I've found a bug (?) in Toad for MySQL 4.6.0.531 and 7.0.0.2038: Manual submit auto submits when statement is executed again. Steps to reproduce: 1. Select "Manually submit row...

Hey there.


I've found a bug (?) in Toad for MySQL 4.6.0.531 and 7.0.0.2038:  Manual submit auto submits when statement is executed again.

Steps to reproduce:

1. Select "Manually submit row changes as batch" in "Tools->Options->Environment->Grid->Submitting Changes to the Database".

2. SELECT * FROM any.table; -> Change a value but do not submit the change

3. Re-execute SELECT * FROM any.table; (in the same editor)

4. Now the previous change to the value has been submitted without hitting the "Submit" button at the bottom the grid.

Hope you can fix this behaviour. Thanks!

Best regards.

Pascal

Unanswered 179 1 / Create an account to join the discussion.
pstein
Follow / 21 Sep 2011 at 12:27pm / Toad for MySQL
Latest post by on 8 Aug 2014 at 12:31pm

Can I download older (v5.x) versions of Toad for MySQL?

Expand content
I prefer to use older version (v5.x) of Toad for MySQL. Can I download them somewhere? on the main download page there is only the newest GA version available. Peter

I prefer to use older version (v5.x) of Toad for MySQL.

Can I download them somewhere?
on the main download page there is only the newest GA version available.

Peter

1206 5 / Create an account to join the discussion.
andyd01
Follow / 6 Jan 2011 at 1:49pm / Toad for MySQL
Latest post by on 7 Aug 2014 at 5:38pm

Toad Hangs - has to be terminated

Expand content
I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software...

I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung.  I can't do anything in the software, and I can't quit and I have to terminate the process.  This happens several times a day.

Running on Windows 7 x64.  Anybody know what's going on and how to fix this/

2237 19 / Create an account to join the discussion.
John Wilson
Follow / 31 Jul 2014 at 5:12pm / Toad for MySQL
Latest post by on 1 Aug 2014 at 11:08am

Toad for MySql 7.2.0.20.22 (freeware) not connecting to database

Expand content
Hi I am a novice using Toad so any help resolve this issue will be very welcome. Just yesterday my Toad has decided not to connect to my database. It is giving the following error message: System.Net...

 Hi I am a novice using Toad so any help resolve this issue will be very welcome.

Just yesterday my Toad has decided not to connect to my database. It is giving the following error message:

System.Net.Sockets.SocketException
The system detected an invalid pointer address in attempting to use a pointer argument in a call
Stack Trace:
   at System.Net.Sockets.Socket.GetSocketOption(SocketOptionLevel optionLevel, SocketOptionName optionName)
   at System.Net.Sockets.NetworkStream.get_ReadTimeout()
   at MySql.Data.MySqlClient.TimedStream..ctor(Stream baseStream)
   at MySql.Data.MySqlClient.MySqlStream..ctor(Stream baseStream, Encoding encoding, Boolean compress)
   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.MySQL.MySQLConnection.DoBeforeConnect()
   at Quest.Toad.Db.Connection.Connect(Boolean notify)
   at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

I have uninstalled and reinstalled and still get the same message.

The MySql server is running as I can connect to it using my Alpha Any Where and MySql Workbench but I mych prefer to use Toad.

Can anybody help resolve this.

Thanks in advance

John Wilson

Unanswered 217 1 / Create an account to join the discussion.
rlaughter
Follow / 31 Jul 2014 at 5:55pm / Toad for MySQL
Latest post by on 31 Jul 2014 at 6:46pm

Toad unusable on new 4k Monitor

Expand content
Every other program seems to work on the new laptop but Toad. Does anyone have any suggestions on how to fix the window layouts so I can use Toad?

Every other program seems to work on the new laptop but Toad.  Does anyone have any suggestions on how to fix the window layouts so I can use Toad?

110 1 / Create an account to join the discussion.
gbrocato
Follow / 21 Jul 2014 at 5:52pm / Toad for MySQL

Job Manager Schedule

Expand content
Is there a way to export into excel from the Job Manager? I have 120 reports automated and would like to see them in excel.

Is there a way to export into excel from the Job Manager? I have 120 reports automated and would like to see them in excel.

108 0 / Create an account to join the discussion.
amuthup
Follow / 20 Jul 2014 at 8:54am / Toad for MySQL

Rank function in TOAD

Expand content
Hello! I am trying to use RANK() in TOAD SQL editor, it keeps saying there is no RANK function in the test schema I am working on. What I actually want is similar to DENSE_RANK or ANALYTIC rank function...

Hello!

I am trying to use RANK() in TOAD SQL editor, it keeps saying there is no RANK function in the test schema I am working on. What I actually want is similar to DENSE_RANK or ANALYTIC rank function for my table... Any help in knowing the syntax, or using RANK function is much appreciated!

81 0 / Create an account to join the discussion.
davek
Follow / 21 Jun 2014 at 9:39pm / Toad for MySQL
Latest post by on 17 Jul 2014 at 8:17pm

Compare Schema - ERROR: Select command denied to user 'xxxx'...

Expand content
I am so thrilled to have found Toad and this forum!!! First, a disclaimer: I am a novice at DB administration and everything I know is self taught through forums just like this one. That learning is...

I am so thrilled to have found Toad and this forum!!!

First, a disclaimer:  I am a novice at DB administration and everything I know is self taught through forums just like this one.  That learning is out of necessity, but thank God I enjoy a challenge!  My question may be "basic" and I apologize to the experts that may find my inquiry frustratingly simple. I have searched the forum and couldn't find the answer and thus, finally asking for help.  

My Experience Level with Toad: maybe 6 hours of use
My DB Admin Skill Level: Novice
Version of Toad: 7.2.0.2922
Toad Feature I am have issues with: Compare Schema
Error being encountered: Select command denied to user 'xxxx'@'yyyyy' for table 'db' Quest.Compare.Schema.MySQL.DBModel
Prior to posting I made sure (using Toad)...

  1. I have successfully connected to each of the DBs for which I am trying to compare the schemas for.
  2. I have been able to successfully run queries against each of the targeted DBs.
  3. I have verified the stored user name and password for each connection.
  4. I have verified that the UID has select authority for each of the DBs.  Actually, the UID has all permissions.
  5. I have verified that remote connection is authorized for the UID on each DB.
  6. I have reviewed the list of tables within each of the target DBs....  neither has a table named 'db'.

I also reviewed the "How to create multi-schema comparison" posted within the forum but that didn't help.  As soon as I execute the compare, Toad returns the stated error.  I suspect this is something truly simple and elementary but I, as I mentioned, I am a novice and would truly appreciate any guidance from anyone willing to point me in the right direction.

Thanks in advance!

Unanswered 192 1 / Create an account to join the discussion.
savoym
Follow / 18 Apr 2014 at 1:08pm / Toad for MySQL
Latest post by on 14 Jul 2014 at 6:22pm

Question on problem after upgrading to version 7.2.0.2922

Expand content
I am NEW to TOAD. I just upgraded my ToadForMySQL client on my Windows 7 box from ToadForMySQL 7.0.0.2038 to ToadForMySQL 7.2.0.2922. I have 4 databases that I currently connect to. Of the 4 connection...

I am NEW to TOAD.  I just upgraded my ToadForMySQL client on my Windows 7 box from ToadForMySQL 7.0.0.2038 to ToadForMySQL 7.2.0.2922.  I have 4 databases that I currently connect to.  Of the 4 connection entries that I have in my Connection Manager I can only connect to 3.  When I try to connect to the 4th database using my connection entry I get this error:

MySQL Database Error

Authentication with old password no longer supported, use 4.1 style passwords. 

Any suggestions on how to fix this issue would be appreciated.  Nothing has changed regarding permissions or passwords in any of these connections.  A reply would be appreciated ASAP.  Sad

 

Thank. 

505 5 / Create an account to join the discussion.
marine
Follow / 9 Mar 2012 at 12:33pm / Toad for MySQL
Latest post by on 14 Jul 2014 at 12:24pm

automatic connection

Expand content
I would like to run toad for mysql from my mremoteng tools. When I want to run toad with command line, it opens toad but does not connect to the database (only open editor's window) In a CMD, I use...

I would like to run toad for mysql from my mremoteng tools.
When I want to run toad with command line, it opens toad but does not connect to the database (only open editor's window)

In a CMD, I use C:\Program Files\Quest Software\Toad for Oracle\TOAD.exe Connect=%Username%/%Password%@%dbName%

Any idea to autorun and connect toad to a specific database?

716 4 / Create an account to join the discussion.
BrianP
Follow / 6 Jul 2014 at 5:17pm / Toad for MySQL
Latest post by on 9 Jul 2014 at 2:11am

DateTime subseconds off by 10x on mysql-5.6.16-winx64 & Toad 7...

Expand content
I am using camera EXIF data which shows hundredths of a second for image SubSecCreateDate to differentiate images shot in burst mode at many rounds/second. TOAD displays the hundredths of a second as thousandths...

I am using camera EXIF data which shows hundredths of a second for image SubSecCreateDate to differentiate images shot in burst mode at many rounds/second. TOAD displays the hundredths of a second as thousandths, inserting a leading zero just after the decimal point separating seconds from subseconds.  “.40” seconds is being incorrectly displayed as “.04”

Here is the RAW DATA:

> exiftool.exe -SubSecCreateDate pf-2013.0331-122707.p1c.mammatus.30k.jpg

Create Date                     : 2013:03:31 17:08:36.40

In TOAD, select  tools -> options -> grid -> custom yyyy-MM-dd HH:mm:ss.ff to display hundredths of a second.

The field, “create_date” is declared as a datetime(2) to fit the hundredths of a second provided by the EXIF data. This definition shows up correctly in viewer -> table -> columns -> type

When you select the “create_date”, datetime field, the data grid displays “2013-03-31 14:53:26.04”. The subSecond value shown is 40 thousands. The correct value is 400 thousands.

To test whether the correct value is actually being stored, test it on the command line:

mysql> update zip set create_date='2013-03-31 14:53:26.40' where zid=114827;

Query OK, 1 row affected (0.00 sec)

mysql> select create_date from zip where zid=114827 ;

| create_date            |

| 2013-03-31 14:53:26.40 |

This correctly shows 4 tenths.

When you select the microseconds of the datetime and divide by 1000 to create milliseconds, the correct result is shown as 400. See the attached screen capture.

The GUI is mangling the data, dividing hundredths of  a second by 10 to make it look like milliseconds.

195 3 / Create an account to join the discussion.
grant.tom
Follow / 2 Jul 2014 at 5:37pm / Toad for MySQL

Region Collapsing issue when region contains While statement

Expand content
Here is some silly example code to try to demonstrate my issue with collapsing. CREATE PROCEDURE Test () BEGIN DECLARE vCondition2 int ; DECLARE vCondition3 int ; --region test SET vCondition2...

Here is some silly example code to try to demonstrate my issue with collapsing. 

CREATE PROCEDURE Test

()

BEGIN

  DECLARE vCondition2 int;

  DECLARE vCondition3 int;

 

  --region test

  SET vCondition2 = 3;

 

  WHILE vCondition2 = 3 DO

  IF vCondition3 = 2 THEN

    SET vConditon2 = 1;

  ELSE

    SET vCondition2 = 3;

  END IF;

  END WHILE;

  --end region

END;

 

 

If I collapse on the BEGIN, I get:

 

CREATE PROCEDURE Test

()

BEGIN WHILE;

 --end region

END;

 

I expected:

 

CREATE PROCEDURE Test

()

BEGIN;

 

 

 

If I collapse on –region test:

 

I get:

 

CREATE PROCEDURE Test

()

BEGIN

  DECLARE vCondition2 int;

  DECLARE vCondition3 int;

 

  test WHILE;

  --end region

END;

 

 

I expected:

 

 

 

CREATE PROCEDURE Test

()

BEGIN

  DECLARE vCondition2 int;

  DECLARE vCondition3 int;

 

  test

END;

 

 

It seems the WHILE is screwing up the collapse logic.  Is there an error in my syntax?  Is there a work around?

 

102 0 / Create an account to join the discussion.
wipeout630
Follow / 1 Jul 2014 at 8:32pm / Toad for MySQL

Error during FTP Connection Attempts

Expand content
After upgrading to Toad for MySQL 7.2, I am no longer able to connect to my FTP server. I receive the following error after the connection times out: Failed to accept connection within the timeout period...

After upgrading to Toad for MySQL 7.2, I am no longer able to connect to my FTP server.  I receive the following error after the connection times out:

Failed to accept connection within the timeout period

I've confirmed that my username/password is valid and the directory specified is correct.

Unanswered 106 0 / Create an account to join the discussion.
Yael G.
Follow / 29 Jun 2014 at 1:05pm / Toad for MySQL
Latest post by on 30 Jun 2014 at 3:33pm

Installing Toad without internet access

Expand content
How can I install Toad for MySQL on a stand-alone pc which is not connected to the internet?

How can I install Toad for MySQL on a stand-alone pc which is not connected to the internet?

148 1 / Create an account to join the discussion.