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

SHOW DATABASES problem

forums › forums › SQLyog › Using SQLyog › SHOW DATABASES problem

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 19, 2003 at 5:55 am #8138
      sbeer
      Member

      Hi there,

      I have been using SQLyog for several months now and it has been very good. As of last week I have been unable to connect to my remotely hosted MySQL database, actually it will connect but will not display or do anything useful and gives the error number 1227 – “Access Denied – You need the SHOW DATABASES privelege”.

      I discussed this with the hosting company (Netregistry, a reasonably mainstream and reasonably high-end, definitely not budget, hosting company) who said that they updated their servers last week and they had no intention of giving the SHOW DATABASES privelege to users. I pointed out that to my knowledge this made SQLyog unusable, and also the MySQL Control Center, which were the only two graphical front-ends I have tried. Another person I know says he is unable to connect via the ODBC connector for the same reason.

      My guesses are that if a lot of hosts are currently upgrading to the new versions of MySQL that require the SHOW DATABASES privelege, there should be many other people who are no longer able to connect with SQLyog (and other clients).

      My questions are as follows:

      Is there any way to use SQLyog *without* needing the SHOW DATABASES privelege?

      Are there many other people our there with this problem?

      Are there other decent hosting companies who will allow the SHOW DATABASES privelege? i.e. should I just move to another hosting company?

    • August 19, 2003 at 7:56 am #14808
      Shadow
      Member

      Your hosting company must have upgraded to MySql 4.0.x, and this version does not show the db's by default. At the 'Connect to MySql host…' dialog specify your Database name. Hopefully, this will solve your problem.

    • August 19, 2003 at 8:19 am #14809
      Ritesh
      Member

      Shadow is correct.

      If you specify *database name* in the Connect To MySQL Host… dialog box, SQLyog will not issue SHOW DATABASES query, as it assumes that the databases provided exists in the server and it is a valid database. Moreover, it will only add those databases in the ObjectBrowser.

      To specify multiple databases, separate them with ;

      HTH

    • August 20, 2003 at 12:54 am #14810
      sbeer
      Member

      Thanks Ritesh and Shadow,

      Yes, I downloaded the latest version of SQLyog (version 3.52), and it does work now.

      I was using version 3.1,which is the most recent free version of SQLyog that I was able to find, which gives the error as I described even with the database name in the connect box.

      Thanks again,

      Simon

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.