[CalEvans]

Quote:

OK, forgive me if these are stupid questions.

Ok but only if you promise not to take my message the wrong way. 🙂

1: If by create you mean a WYSIWYG query builder then no, there is no way to have the system create the queries for you. This tool is primarily for people who write SQL and need a tool to execute it. there are other tools available (some free, some even good) that will help you do this. My sincere hope is that SQLyog does not become one of those. (Because I write SQL for a living and it's great to have a tool minus these features.) You 'create' the query in SQLyog by hand coding it in the query window. (Then you execute it)

If all else fails, install the mysql ODBC drivers, connect to your server in ACCESS and use it's query builder. (Or do what I did low these many years ago and purchase a copy of SQL for Dummies. GREAT book!)

2: Again, no. SQLyog is a SQL query tool. It has some great features like being able to generate the DML to sync 2 database structures, generate a rudimentary insert statement for a table (saves me a LOT of typing!) and the best user management system I've seen for mySQL. (mySQL's paradigm for user permissions is a bit goofy to begin with) It is not comparable to ACCESS, it is more comparable to the old iSQL that used to come with M$SQL. (Now known as Query Builder but as with everything they have added so much crap to it that it has become bloated and slow.)

Check http://www.freshmeat.net. There are some systems that will help you generate web forms from your tables. Some of them are mature enough to be used in developing real systems. (Some of them are still toys though, be careful which ones you use)

SQLyog is a great tool for doing exactly what it does. Managing a mySQL server and developing new databases and code. Personally, I hope the development team does not lose it's focus and start adding everything in the world to it. (This is nothing new, Ritesh has heard this rant from me before. (I have the great honor of being one of their beta testers and being an ancillary participant in developing this great tool)

Anyhow, it's probably not the answers that you wanted. 🙂

=C=

[CalEvans]

It's not supposed to be necessary but have you tried a

FLUSH PRIVILEGES;

just to make sure everything gets committed?

=C=

[CalEvans]

I still say this is a mysql issue because it's mysql reporting the error. You are talking to the server so SQLyog is working.

I have noticed that the mysql command line interface is more forgiving about the host you are connecting from.

using the mysql cli connect and switch to the mysql database. check the users table to make sure that your username AND host are explicitly set. (I still have problems with host='%')

Then try again.

=C=

[CalEvans]

grant all on databasename.* to user@host identified by 'password'

Obligatory link to the manual page that should be consulted before asking questions that have already been answered in the manual.

HTH,

=C=

[CalEvans]

To the best of my knowledge, this is not possible. You'll have to write an INSERT.

=C=

[CalEvans]

If you have shell access to the server via ssh, use ssh to tunnel the mysql protocol.

Here's what I do.

My laptop is running windows 2000. I use SecureShell from http://www.vandyke.com.

In the configuration for the connection to my server I have setup port forwarding for 3306.

When I want to connect SQLyog to the server there I connect to the server using ssh and then connect SQLyog to localhost port 3306.

This way I can remotely control my mysql server from any internet connection available.

Clear as mud?

=C=

[CalEvans]

That's going to be kind of rough. SQLyog will not utilize the .db file, nor will it execute the cgi script for you to create the database.

if the database you want to create is exactly the same as the one that currently exists on another server, you could use SQLyog to generate the DDL (the SQL to create the database) then connect to the new server and execute it.

I've done this many times without incident.

HTH,

=C=

[CalEvans]

1: Do you have a valid login and password for the server you want to access?

2: Is that user setup for the host you are connecting from?

3: NO, of course you can't just download it to your computer. (Unless the server is currently on a windows box. If so and you set everything up EXACTLY like the server (path names, etc.) then you MAY be able to. (But if you are using InnoDB table types you chances are very slim)

=C=

[CalEvans]

This is mysql telling you that you don't have permission to connect from your host. Check your user permissions and the MySQL manual for more info.

=C=

[CalEvans]

I get this usually after SQLyog has been sitting for about 30 minutes. I'm not sure if it's just mysql recouping the connections or if there's something wrong here. FWIW, I get this when connected to mysql boxes that are remote to me and also boxes that are local to me.

=C=

[CalEvans]

Do you have InnoDB compiled in?

What OS? If Windows, did you install MySQL-MAX? If Linux did you install from source or RPM?

If Linux, from the command line type:

Code:

mysqladmin variables

Look in the output for:

Code:

have_innodb

Is it Yes or no?

In Windows, use the MySQLAdmin tool to find this. It should still be set to yet. Otherwise, you cannot use InnoDB tables.

=C=

[CalEvans]

Lean somthing new every day. 🙂

=C=

[CalEvans]

What datatype are you trying to enter a size for? the datatype of date will not allow you to. (It's predefined) I'm sure there are others although I don't know them off the top of my head.

HTH,

=C=

[CalEvans]

Quote:

I try to move one of my database from e:mysqldata to another location with a symbolic file.

I wasn't aware that Win2k had symbolic links. All I know of is shortcuts, which are not nearly the same. (Shortcut is an old windows PID file)

try changing your my.cnf (or is it my.ini in windows?) to point to your new location. Unless you are using InnoDB tables, that should be all you need to do.

=C=

[CalEvans]

Does it always happen on only when you try and ALT-TAB to SQLyog and SQLyog has a modal window up? (i.e. table designer or add/edit data)

I've noticed (and reported) the same problem in Win2k when I try and ALT-TAB into SQLyog and it has a modal window up.

=C=

[Author]

Posts