Forum Replies Created
-
AuthorPosts
-
Shadow
MemberQuote:a lot of import/export optionsEven SQLyog 3.11 has import/export functions (sometimes buggy a bit :P) and this feature has been particularly improved in v3.5.
Quote:and has a well-written local HelpWell, that's truly a feature that is missing from SQLyog, although I should say, it is not too difficult to use SQLyog, that is way I don't consider the lack of built-in help such an important issue.
MemberMost users have problems connecting to dbs operating on ISP servers though…
MemberMySql 4.1-alpha on Win2K Prof. SP3 Hungarian version. What is the language of your OS? It may affect what you see because it will render characters differently! And I repeat: latin1 gets all my special characters right.
MemberOops, the forum really cannot handle long ü correctly. ?= long ü in my previous entry.
MemberI know how an ? looks like, but my db stores and retrieves them correctly…
MemberAre you sure? I get all my Hungarian characters right…
MemberHi, my fellow countryman!
use latin1 insted of utf8 as charset and you'll get “Szöveg és képek” immediatelly!
So, insted of:
Quote:CREATE TABLE `tblTrnHU` (`TrnKey` varchar(255) character set latin1 NOT NULL default '',
`TrnRTS` bigint(20) default '0',
`TrnDesc` varchar(255) default NULL,
PRIMARY KEY (`TrnKey`)
) TYPE=MyISAM CHARSET=utf8
use:
CREATE TABLE `tblTrnHU` (
`TrnKey` varchar(255) character set latin1 NOT NULL default '',
`TrnRTS` bigint(20) default '0',
`TrnDesc` varchar(255) default NULL,
PRIMARY KEY (`TrnKey`)
) TYPE=MyISAM CHARSET=latin1
It works for me and use 4.1-alpha as well
MemberFields terminated by: ,
Fields OPTIONALLY enclosed by: “
Lines terminated by: n
Escaped by: \
This is it. The problem is that certain applications use different EOL characters, so the import may handle the line breaks incorrectly.
MemberQuote:If you get the following error when you try to connect from a different host than the one on which the MySQL server is running, then there is no row in the user table that matches that host:Host … is not allowed to connect to this MySQL server
You can fix this by using the command-line tool mysql (on the server host!) to add a row to the user, db, or host table for the user/hostname combination from which you are trying to connect and then execute mysqladmin flush-privileges. If you are not running MySQL Version 3.22 and you don't know the IP number or hostname of the machine from which you are connecting, you should put an entry with '%' as the Host column value in the user table and restart mysqld with the –log option on the server machine. After trying to connect from the client machine, the information in the MySQL log will indicate how you really did connect. (Then replace the '%' in the user table entry with the actual hostname that shows up in the log. Otherwise, you'll have a system that is insecure.)
If you do not have a stable IP address (and you seem to have a dial-up access) then you should create a user with 'username'@'%', otherwise you won't be able to connect next time!
MemberIt's not just an XP problem, it behaves the same on Windows 2000, too. The reason is, I think, that the dialog is modal, and after switching applications via ALT+TAB, it looses focus. You should click the field you want to edit so that the cursor appears in the textbox. Now you can use ALT+TAB to switch between applications!
MemberStill works as expected for me! The dialog retains focus and finds/replaces the text I enter.
MemberIt works for me. Do you take both the current cursor position and the search direction into account?
MemberSQLyog is a MySql front-end, used for administering MySql dbs, while JSP is a web programming language. Therefore the two are totally independent from the other.
MemberThe problem is that you use MySql 4.1. This version applies a new binary protocol not supported by many front-ends. Thus the older front-ends may connect to MySql 4.1 in that case only when there is no password. Upgrade your SQLyog to v3.5 which support MySql 4.1 login with passwords.
Unfortunately MyODBC, MySql's ODBC driver does not support 4.1 completely, so you cannot use passwords with MyODBC either. MySql says that MyODBC 3.52 (currently in alpha) will support 4.1.
MemberNo, that would not solve your problem. If you specify a db name in the connection dialog, then SQLyog will connect to that db only. MySql v3.x and 4.0.x do not restrict the 'SHOW DATABASES' command, therefore all dbs will be shown in case of a successful connection to the server regardless of the users access rights. MySql 4.1, however, will show those dbs only which the user has access to.
I think, you are not properly connected to the MySql server and this leads to the errors. Perhaps you should clarify with your provider what username and password you have. If you have a dial-up access (or your ISP assigns a different IP address to your computer each time you connect to the web) then ask for access to be granted to 'your_user_name@%'.
-
AuthorPosts
