Forum Replies Created
-
AuthorPosts
-
Shadow
MemberThis problem does not have anything to do with SQLyog. It is rather a networking issue, I believe. Your computer doesn't resolve 127.0.0.1 address for some reason… You can change root@localhost to [email protected] and it will work just the same.
MemberAccording to the error message, [email protected] user has a password or doesn't even exist. You should first figure out what users you have created and what passwords you assigned to them.
About the automatic login: in the login dialog you can type in the password and then save the settings. Next time all you have to do is to click Connect.
MemberIt is ” Lost connection to MySQL server during query” error. Do a keyword search in this site with “lost connection” (don't forget to set “Search post from” to “Last 365 days”) and you'll get all the topics that have dealt with the same problem.
MemberI face the same problem all the time: I figure something doesn't work, and then looking deeper into the matter I find out that it was entirely my fault…
MemberWhat do you mean by “unable to edit mysql user passwords on our servers?” Do you get any error message, or everythings seems to be ok until someone tries to log in with the new password? BTW which version of SQLyog do you use?
The catch might be that SQLyog doesn't use the GRANT/REVOKE/SET PASSWORD commands for administering users. It issues explicit INSERT/UPDATE/DELETE commands instead. If the user that tries to change the password of other users does not have the necessary rights on MySql db, then the operation will fail. (For changing passwords other than yours, you need INSERT/UPDATE rights on the user table anyhow.)
MemberThe upcoming version of SQLyog (3.6) does have scheduler support. As of now, only MySql-toMySql synchronization can be scheduled, but I'm sure that the later versions will allow more functions to be scheduled, including ODBC import. The only current solution I can think of right now is to do what CalEvans suggested: to write a script and automate it. I would suggest, however, to use VBScript or even a smal VB program to do the job because it can be debugged more easily than PHP and there is no need for a web server.
MemberMost likely you set the Title field as primary key, or created a unique index on it.
MemberYou might find a tool at http://www.mysql.com/portal/software/conve…tors/index.html, although finding an Access to MySql converter has a better chance…
MemberNo it doesn't. Currently only MySql to MySql sync can be scheduled.
MemberYou need to issue the command as GRANT LOCK TABLES ON test_db.* TO test_db_user@[ip_address];
MemberAccess has an ODBC import tool. You can use that to connect to a MySql db directly from Access provided you have MySql ODBC driver installed.
MemberYou got it wrong Ritesh! I didn't say SQLyog issued UPDATE statements when you scroll the window. But it does issue an UPDATE statement if you move the cursor into a field then move the focus without changing anything. I did check out the history tab!
MemberMy bad, I replied before thinking! An INSERT INTO works only if you specify a higher value than the current seed. If you use MyISAM then you should take advantage of the -A option of myisamchk:
Quote:-A or –set-auto-increment[=value]Force AUTO_INCREMENT to start at this or higher value. If no value is given, then sets the next AUTO_INCREMENT value to the highest used value for the auto key + 1.
MemberIssue an INSERT INTO command that explicitly sets the id column to the next desired value. That will reset the counter.
MemberReason for SQLyog hitting the HD in the update window is that it keeps issuing UPDATE commands even if nothing was changed but you moved the cursor from one field to the other…
It's by design and I keep complaining about it. I have been promised that it's going to be changed in SQLyog Max.
-
AuthorPosts
