[CalEvans]

marcm wrote on Jun 12 2006, 06:53 AM:

No, that's it. I was just curious to know if connecting to my host with https (while not using the tunneling tab) is secure or not. Is that any more or less secure than using the SSH Tunneling tab?

Hi,

Because the handshake on https takes place before any data is transmitted between the client and the server, the data you are sending over *any* https connection is secure.

That having been said, Ritesh is correct, ssh tunnel is the way to go. I only use the http proxy if I'm working on a client's machine and don't have ssh access. (And Ritesh, it's saved my bacon on more than one occasion, I keep forgetting to tell you thanks!)

=C=

[CalEvans]

furio333 wrote on Jun 10 2006, 12:07 PM:

I wont to use SQLyog to make database .

The problem is if ill try to connect with localhost and username:root pass:(blank)

and port:3306 Database:(blank) always take error

Cant connect to MSQL server on “localhost” (10061)>

i wont litle help with easy steps. 🙂

e-mail:[email protected]

messengers

yahoo:furio333

msn:[email protected]

(thanx for all and sorry for my english)

Furio,

I'm assuming you mean MySQL, not MSQL as SQLYog can't be used to connect to any other database engines. It sounds like you are trying to connect to a server on your local machine and SQLYog can't find it. Double check to make sure that MySQL is running on your machine.

=C=

[CalEvans]

ronjeremy_69 wrote on May 23 2006, 05:24 PM:

SQLYog has an impressive pace of improvement. Ritesh does a great job of constantly improving it!

Unfortunately a pretty simple option, “Show Table Results In Text”, which I requested almost a year ago has fallen by the wayside (it was supposed to be included in 4.1?). As a developer/coder who deals heavily with text and hundreds of tables, it would dramatically increase my productivity to be able to just single-click on a table and have the data displayed as text instead of in the grid. Im sure there are many other users out there who would also greatly appreciate it.

I know I've got to be missing somehting because CTRL+L workes in everything but the “Table Data” pane.

Select * from mytable;

F5 and then CTRL+L and I can copy and paste away.

As I said, I know I'm missing somthing here.

(Ritesh, it would be nice if Table Data honored the CTRL+L switch and I agree with Ron that it would be nice if SQLYOG remembered this setting across reboots.)

=C=

[CalEvans]

jamieludlow wrote on Apr 11 2006, 06:23 PM:

Also what do you put in the 'host' section? Do you put an ip address, a website adress with http://, the name of the current user? I am unsure about this part! Also there is a % sign already in the host section. Do i delete this or not?

Wheni enter al the apppropriate details (i use an ip address for host), i get the error message 'Error No. 1142, INSERT command denied to user 'jamieludlow'@'dynamic-62-56-11-81.park-s46b.dslaccess.co.uk'for table'user''

Someone please help, it would be appreciated. Thanks 😉

Howdy Jamie,

As to the first question, host will be 1 of 3 values:

localhost. If the user you are adding will be connecting from the local machine (i.e. a web application running on the same machine as the database) then use localhost. That keeps the account from being abused by others.

% – this is the wildcard that means from ANY host. Be careful with this one.

The third value is the specific machine name you are connecting from (or if you are behind a firewall, the machine name of the firewall.) This will look something like dynamic-62-56-11-81.park-s46b.dslaccess.co.uk. This is the best option if you know you will be accessing it from the outside form from the same place each time. It's just a little more secure.

But the second question indicates that you have a problem that can't be fixed by SQLYog. The problem is you don't have permission to add users. You'll need to speak to your host about that.

Have a great day!

=C=

[CalEvans]

indus wrote on Apr 10 2006, 04:40 PM:

Hi

I am totally new to mySQL and sqlYog.

I have some *.frm files and I was wondering how do open/import them in sqlYog.

Any helpl would be appreciated

Thanks

indus

Howdy and welcome!

You can't import the frm files directly. However, SQLYog is a client for MySQL. So attach to the running mysql server (like you would with the command line client) and you can view the database structure and data that the frm files represent.

=C=

[CalEvans]

nicmar wrote on Mar 31 2006, 01:38 PM:

Don't know the reason for this, I'm using Beta 5 and just installed MySQL:

1. Install MySQL

2. Connect to localhost – Sqlyog hangs

3. Restart program

4. Connect to external host – It works

5. Connect to localhost – It works

6. Restart program

7. Connect to localhost – Sqlyog hangs

This means I have to connect to another mysql-server before the one on localhost, or else it doesn't work.

Any clues on this?

-nicmar, the bugfinder 😉

I'm having the exact same problem. I reported it to Ritesh a week or so ago.

I'm using 5.1 BETA 2. (Did I miss an announcment?)

=C=

[CalEvans]

taborinni wrote on Mar 30 2006, 02:09 AM:

I have installed SQLYog on our developement server and there are 2 of us who uses it however it wants each user to register the program and the original registration codes do not work because I upgraded to 5.1B and the new copdes do not work either. Any thoughts?

Unless I'm mistaken that's not allowed by the license. SQLYog is a client side program. You can install it on a network share but you are still only licensed to use it on on client. Again I could be wrong but this is the way most licenses are written these days. If you want 2 people to be able to use it, you need to buy 2 copies.

=C=

[CalEvans]

bonjovi wrote on Mar 28 2006, 08:59 AM:

When I try to test my connection it keeps coming up with an error 1045, saying that access is denied for user but the user name it comes up with isn't one that I have created.

Is the username correct and the host incorrect or is it giving you a totally different username?

in case that doesnt make sense logins have 2 parts:

username @ hostname

=C=

[CalEvans]

peterlaursen wrote on Mar 20 2006, 08:38 AM:

Well .. the 'green arrow' icon becomes a 'red stop' icon while query is running – doesn't it?

Any special sort of query you are talking about ?

Peter,

In about 90% of the queries I run, yes it becomes a stop sign (and I've worshiped at Ritesh's feet for that one, I remember versions that DIDN'T have that!) But in about 10% of the cases it does not allow me to stop. Personally, I believe this is a quirk of the program. The 10% of the queries I can't stop lock the program up till they are done, or at least seem to. I believe the problem is that the queries ran quickly but returned or are returning datasets that are so large that the interface has trouble rendering them.

Sat I also had one that froze the program for over an hour. it was a really big delete statement. (Deleted 25k records) The delete statement itself took that long on the server but SQLYog went to sleep until it finished. It would be nice if something happened. Put the delete in a seperate thread so it doesn't lock the interface up and then just disable all the buttons until it's finished…or something.

IMHO, etc.

=C=

[CalEvans]

peterlaursen wrote on Mar 8 2006, 07:42 PM:

From result-pane you must choose the table from the drop-down where it displays 'Read Only'. Was that it?

That's been the case as long as this feature has been enabled. (4.x?) You've always had to select the table name instead of ReadOnly to be able to update.

=C=

[CalEvans]

thomas7263 wrote on Feb 20 2006, 07:47 PM:

I am not sure if this is a pure mysql question or a sqlyog question.  I use the query below to move data from one database  to another on the same host/connection.  My question is – how do I move data from a database  in one host to a database in another host?

INSERT INTO database2.table2 (field1,field2,field3) SELECT field1,field2,field3 FROM database2.table2 where etc…;

Thank you for your help

[post=”8815″]<{POST_SNAPBACK}>[/post]

Hi,

I do not believe that is possible with either SQLYog ot MySQL (Although I may be wrong). You would need to:

1) Expode the data using SQL and then import it into the second host

2) Write something in PERL or PHP to do the import

3) I believe SQLYog has a job manager that can handle this on an automate basis.

It would be nice if MySQL supported host.database.table.field notation. 🙂

=C=

[CalEvans]

ronjeremy_69 wrote on Jan 19 2006, 06:35 PM:

Just curious — will it also include “Show Table Data In Text” option?  🙂

I'm confused. You mean like CTRL-L? Or is there something more?

=C=

[CalEvans]

zzapper wrote on Jan 18 2006, 06:13 PM:

Hi,

Where is this option?

thanx

[post=”8511″]<{POST_SNAPBACK}>[/post]

Hi,

Not sure if this is what oyu mean but try Tools->Preferences

The first option on General Preferences might be what you are looking for.

=C=

[CalEvans]

peterlaursen wrote on Jan 11 2006, 05:46 PM:

Oracle just purchased InnoDB!!! 

MySQL plan to allow for Foreign Keys with MyISAM. I believe it is in the roadmap for MySQL 5.1. So maybe in a year or so…

[post=”8415″]<{POST_SNAPBACK}>[/post]

I think the 2 are related. 🙂

=C=

[CalEvans]

Luc_40 wrote on Jan 11 2006, 02:21 PM:

Sorry, but it isn't working.  Try the above create and then try to insert a record where you only will fill in the field text.

[post=”8408″]<{POST_SNAPBACK}>[/post]

Hmmm…ok, the only thing else I can think of is a seperate join table called father. Then create 2 optional joins into it from bird where the first join is bird_id and the second is father_id.

In most cases when I have something ike what you are trying to do I insert a record into bird with the ID 0 and make it 'Unknown'. This way father_id of 0 is valid.

=C=

[Author]

Posts