Forum Replies Created
-
AuthorPosts
-
peterlaursenParticipant
To both of you: Please answer the question:
Is the problem the same if you use “Mysql Administrator” ?
peterlaursenParticipantIf you have more mysql server on the LAN behind a router you need to let them use different ports if you want to connect from OUTSIDE the LAN. That because from outside the whole LAN is represented by the ip of the router. You change the port by editing the my.ini/my.cnf file, or you can do it from “Mysql Administrator”. From INSIDE (within the LAN / behind the router) you can use the LOCAL ip (which is different for each machine), so if that's the case there is no change ports numbers
Another client cold be “Mysql Administrator” from http://www.mysql.com. Try it – but it will probably be the same.
Can you ping the machines with mysql installed ?
It could very well be a network problem of som kind (the setup with two hubs). Couldn't you simplify the network while testing the connection. Or maybe try a switch ? And you are sure that router configuration doesn't block traffic on port 3306 ? If you presse the button “test connection” what does it say ?
peterlaursenParticipantQuote:Is this case sensitiviy issue strictly a Windows installation issue?It should be opposite. In MySQL case sensivity follows the standard of the Operating System.
That means that under Windows there is no case sensivity – under Linux/unix there is and under Mas OS-X it depends on the file system chosen at installation.
peterlaursenParticipantI think you should try connecting with “Mysql Administrator” from http://www.mysql.com .
If the problem is the same here it must have something to do with the server settings or network settings for remote connections. (php tools like phpMyAdmin runs “locally” on the server.
peterlaursenParticipantCould be ….
However if your Mysql-version has been updated from an earlier version you must run the script provided by myaql to update the user grant tables.
Try cheking if the issue persist if you use “MySQL Administrator” from http://www.mysql.com.
If it persists it bust be an issue with your MySQL-installation.
If it's OK with MySQL Administrato it probably is a bug in sqlyog.
peterlaursenParticipantIt could be an issue with the setting of the max_allowed_packet parameter in your mysql configuration file (my.ini)
Try raising the value signifikcantly. You'll have to stop and restart the Mysql server for the changes to take effekt.
peterlaursenParticipantFrom tools … usermanager you can either choose “edit user” or “manage permissions”.
Under “edit user” you will find the GLOBAL privileges of the user, i,e, permissions that apply to ALL databases.
Under “manage permissions” you will find the SPECIFIC privileges of the user, i,e, permissions that apply to SPECIFIC databases.
In Mysql if the user has a global privilege to (for example) UPDATE, there is no need to grant right to specific privileges.
So check tools … usermanager … “edit user” – you probably will see the checkmarks there!
peterlaursenParticipantIf the value of the Primary Key is identical for some rows in the two databases, SJA will ALLWAYS overwrite the target with data from the source. That's how it's supposed to work! Are you sure that's not the problem ?
SJA identifies the rows by PK and nothing else. It's been requested from time to time by users that there should be other options, and Ritesh has (a I remember) written here that they will look into that, but I'm not sure if there is any conclusion yet.
However I believe, that it should be possible to use any unique index. A timestamp could be part of such a unique (composite) index. Problem with timestamps however is that the format has changed from different Mysqlversions. So if not the server versions are identical, results could be unpredictable.
peterlaursenParticipantConfirmed … but is that a problem for you ?
peterlaursenParticipantNo problems here!
I thinks this is a misunderstanding ” Furthermore, table level permissions are also missing.”.
Table persmisons don't have to be set if gobal permissions are set!
But yes it seems you have a problem. What versions of sqlyog an Mysql are you using ?
I'm using Mysql 4.1.9 and tried two sqlyog version 4.0 Enterprise RC and 4.01 free version.
It could be an issue with your mysql installation. If you upgraded your present version from an earlier version, you should remember to run the script provided by nysql to reformat the user grant tables.
Try the tools form mysql (Mysql Administrator to create the user, Mysql Query Generator to process the sql, and see if the problem persist.
peterlaursenParticipant“I have checked and double checked tha the username and password I'm using are correct, but still no joy.”
And how did you do that ??
And we are takking about connecting with sqlyog and not som other tool ?
Can you connect from another client?
Can you connect as “root” ? (since it's your own servers you must know the password of user “root”.
do you connect from a windos machchine otuside or inside the LAN ?
Try reading this thread too !
http://www.webyog.com/forums/index.php?act…t=ST&f=4&t=1153
You are very little informative, and its very har to help then. Provide a detailed information and some screenshots too !
peterlaursenParticipantIf the Mysql server is running at your own PC, Hostname is “localhost”. Sqlyog connects directly to mysql and does not depend on or use PHP. It's not relevant for the matter which webserver you use – or if you use one at all! I meant only the MySQL server!
Besides I think you should forget about WinMySQLAdmin. It's outdated! (although it's still distributed with mysql)
Get “MySQL Administrator” from http://www.mysql http://www.mysql.com. Unless your mysql-version is very old.
Did you DL and install a “bundle” of Mysql-php-phpadmin ? I know you can find such bundles on the internet, but that's very old versions. And with mysql running locally I don't see why you need phpadmin at all. With frontends like sqlyog you connect directly and don't depend on a scripting engine.
There is no need to configure another port than the standard 3306. You practically only do that when you are running more than one MySQL servers behind one and the same router. You have a my.ini file somewhere (older versions in windows directory, newer versions in mysql drictory). Here you can read the port that is used. But I'm 99.999 % sure that t is 3306! You should take the time to understand some of the most important settings in the my.ini file
Attached picture show logonscreen with user “root”. Logged on as “root” you can create other users and assign priviliges for other users using either sqlyog or “MySQL Administrator”. Note: The usernames in MySQL are not the same in windows (Mysql does not use windows' user accounts – the user management in mysql in more unix/linux -like that windows-like!)
Hope that clarified a few points!
peterlaursenParticipantPlease write a little more about the server. Where is it running ? If it's at an ISP or webhotel, it's likely that you are not allowed to connect directly to MySQl. In that case you must use tunnelling to use sqlyog.
peterlaursenParticipantAnd just want to add in cas you don't know …
The syncronization agent (both versions) will only work with tables that have a Primary Key.
peterlaursenParticipantI think I'll try to clarify a little !
Sqlyog is a Mysql-CLIENT-program for windows and can do the task if it's installed on a windows machine having access to both servers. Sqlyog does not care (like no Mysql-client does) on which platform the server(s) run. But it can not be installed or run on Linux.
SJA for Linux is a Mysql-CLIENT-program to run on a Linux machine. That machine can of course be one of your servers.
-
AuthorPosts