Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberI think you got it wrong.
You have to add '%' in the Host column in the User table so that corresponding user can connect from any host rather than some particular host.
Ritesh
MemberMultiple selection for Grid is planned for SQLyog Max.
HTH
Ritesh
MemberGreat.
It seems that you are specifying DBs in the connection window. Dont specify *any* in the Connection Window and SQLyog will show all the databases in the Object Browser.
Ritesh
MemberYou can permanently change the limits by modifying the LOWLIMIT and HIGHLIMIT values of sqlyog.ini that is located in the SQLyog directory.
Be careful, as SQLyog stores all its information in the file!!
HTH
Ritesh
MemberSQLyog will not create FKs automatically for you.
After you have Imported data using ODBC Import Tool… you have to manually create your FKs using SQLyog's Tables->Manage Relationships…
HTH
Ritesh
MemberBTW, SQLyog does not add any extra information to what is provided by the User . Give yourselves correct permission and SQLyog will connect without any problem !!
Ritesh
MemberGreetings
MySQL stores its access permission information in the Users table of MySQL database.
The MySQL privilege system ensures that all users may do exactly the things that they are supposed to be allowed to do. When you connect to a MySQL server, your identity is determined by the host from which you connect and the user name you specify. The system grants privileges according to your identity and what you want to do.
MySQL considers both your hostname and user name in identifying you because there is little reason to assume that a given user name belongs to the same person everywhere on the Internet. For example, the user joe who connects from office.com need not be the same person as the user joe who connects from elsewhere.com. MySQL handles this by allowing you to distinguish users on different hosts that happen to have the same name: you can grant joe one set of privileges for connections from office.com, and a different set of privileges for connections from elsewhere.com
Therefore, instead of providing a particular host in the Host column you should provide % to greant access to users connecting from any machine.
HTH
Ritesh
MemberWe have Office 2K. When we ran your DB with our Access driver, all the rows got imported properly and we didnt have any problem.
We are on WinXP with Office 2K. We will try the same DB, on other OS and different version of Office and will report back soon.
Ritesh
MemberCan you provide tell us the exact error message?
Ritesh
MemberThanks for the datafile. We will work on it.
BTW, Which version of Access?
Ritesh
MemberThanks for the feature request.
This option will be added in SQLyog 3.6.
Ritesh
MemberWhich version of Access?
There should not be any problem with SQLyog with importing such small table.
If the data is not sensitive, can you send us a backup of the database particularly the table in concern, so that we can work on the issue and resolve any bug ( if there are ).
Ritesh
MemberThe IP address of the machine on which the MySQL server is installed.
If its a server provided by your ISP, then you can confirm with your ISP about the correct IP.
HTH
Ritesh
MemberSorry.
SSH support is planned for SQLyog Max.
Ritesh
MemberThanks 😀
We are working on it and will fix the bug in SQLyog 3.6
-
AuthorPosts