Forum Replies Created
-
AuthorPosts
-
RiteshMember
We recently had a customer who had a similar issue (he was also using Yahoo).
Quote:Here is what Yahoo says about the MySQL services they provide:Why can't I access my database?
First, make sure that you are using the hostname “mysql” and not “localhost” in any of your PHP or Perl configuration files that require a MySQL hostname.
Make sure that you provide mysql in the host address field rather then localhost.
As far as I know, Yahoo does not provide direct connection so you will NEED to use HTTP Tunneling. You will need to upload SQLyogTunnel.php (available with the SQLyog installer). Put the correct URL in the HTTP Tunneling field and use the same credentials as you will use in your PHP pages.
RiteshMemberWe apologize for the inconvenience. SSL support got pushed down in our priority list, and all the licensing confusion related to OpenSSL for Windows added to our woes.
We promise to deliver SSL with v. 4.4.
SQLyog 4.2 will provide complete MySQL 5.x ( SPs, views, etc ) support.
SQLyog 4.3 will address all Unicode issues.
RiteshMemberYou will need to export it in FIXED LENGTH format.
RiteshMemberThis feature is already in the TO-DO list of SQLyog.
RiteshMemberTo set the default engine use this in the my.cnf file: default-table-type=MyISAM
RiteshMemberCurrently we dont have support for spatial datatypes. Its in the TO-DO list but I cannot comment on the exact version of SQLyog that will support the feature.
RiteshMemberThe operation that you are performing can only be done from a programming/scripting language.
For you reference: http://mysql.scarlet.be/doc/mysql/en/variables.html
RiteshMemberPlease mail me the job file. You can remove the authentication details from the job file.
RiteshMemberBTW, did you you check out: Webyog Community Blogs
RiteshMemberI have added it in the TO-DO list but I cannot guarantee the exact version which will have this feature.
RiteshMemberThis is very strange. SQLyog does not add anything to the query nor to the error message. It simply executes a query and shows the error as returned by MySQL itself.
If the data is not confidential then is it possible for me to look at the sql file? I would be glad to provide you with FTP access where you can upload the file.
RiteshMemberThanks for the report.
We will fix the bug (if there are any) in v4.2.
RiteshMemberThanks for the report.
I will check it up from my office today. The bug will be fixed in v4.2 if there are any.
RiteshMemberWhat is the MySQL version you are connecting too?
Prior to v4.0x, it will list all the databases when
Code:show databasesis executed. After that, only the databases that you have to access to will be displayed.
You can specify which database needs to be added to Object Browser by specifying them in Database(s) field in the connection window.
RiteshMemberQuote:BTW: I drink Thy Classic Økologisk (organic) preferably. Info about the organic beers from “Thisted Bryghus” here: http://www.thisted-bryghus.dk/katalog7.htmKeep it for the BLOGS 😀
-
AuthorPosts