Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 2,527 total)
  • Author
    Posts
  • in reply to: Cannot Connect – Error 1045 #14704
    Ritesh
    Member

    I 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.

    in reply to: sqlyog feature #14676
    Ritesh
    Member

    Multiple selection for Grid is planned for SQLyog Max.

    HTH

    in reply to: mysqlyog locks up #14764
    Ritesh
    Member

    Great.

    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.

    in reply to: Query window shows 1-5000 #14772
    Ritesh
    Member

    You 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

    in reply to: Import to InnoDb Tables #14768
    Ritesh
    Member

    SQLyog 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

    in reply to: Cannot Connect – Error 1045 #14699
    Ritesh
    Member

    BTW, 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 !!

    in reply to: Cannot Connect – Error 1045 #14698
    Ritesh
    Member

    Greetings

    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

    in reply to: mysqlyog locks up #14759
    Ritesh
    Member

    We 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.

    in reply to: Exporting Batch Scripts #14686
    Ritesh
    Member

    Can you provide tell us the exact error message?

    in reply to: mysqlyog locks up #14756
    Ritesh
    Member

    Thanks for the datafile. We will work on it.

    BTW, Which version of Access?

    in reply to: Timesaving New Feature #14767
    Ritesh
    Member

    Thanks for the feature request.

    This option will be added in SQLyog 3.6.

    in reply to: mysqlyog locks up #14753
    Ritesh
    Member

    Which 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 ).

    in reply to: I cant connect #14750
    Ritesh
    Member

    The 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

    in reply to: SSH/SFTP/SSL #14749
    Ritesh
    Member

    Sorry.

    SSH support is planned for SQLyog Max.

    in reply to: Request: Dual Monitor Support? #14739
    Ritesh
    Member

    Thanks 😀

    We are working on it and will fix the bug in SQLyog 3.6

Viewing 15 posts - 2,116 through 2,130 (of 2,527 total)