Forum Replies Created
-
AuthorPosts
-
CalEvans
MemberThe definitive answer is…maybe.
If your ISP will allow you access to it…
If you have a login and password…
If you are not behind a firewall blocking 3306…
Then you should be able to connect to just about any mysql server using SQLyog.
If the server is on your local network then 1 & 3 are moot.
There are ways around #2 but they require additional information. (like what OS is your server running.)
=C=
MemberIf you are asking: “can I use SQLyog to connect tot he MySQL service running on your cold-fusion server then you should be able to. (barring connection issues, firewalls, etc.)
If you are asking, “Can SQLyog connect to Cold Fusion?” Then no, Of course not.
HTH,
=C=
MemberWhile it is possible to use SQLyog to do this, I would suggest that you look into writing a script (PHP? PERL?[ASP?]) that does this and call it as a cron [or windows scheduler] job twice a day. It would be much easier.
=C=
MemberI don't have the answer to your specific question but I can answer th one you did not ask. It should be very easy to write a script in VBS or PHP to perform the update for you. Once you know it is operating properly, you can simply use the Windows Task Scheduler to run it as often as you like.
BTW, it's cool to know that an organization as reputable as Julliard uses MySQL.
HTH,
=C=
MemberOk,
1: Are you sure MySQL is running on your local box?
2: Are you sure you have a root login? (Most likely yes)
3: Are you sure you know your root login password and have it entered correctly?
4: Can you connect to mysql using the command line client that comes with it?
If you cannot connect using the command line client then the problem is MySQL and you need to visit http://www.mysql.com and checkout the docs.
If you can connect to MySQL using the command line client but not SQLyog then we have a problem.
My guess (off the top of my head) Either it's not running or you don't have the root password set correctly.
=C=
MemberMemberThanks for the update. I ran it as a service on Win2k for about 6 months but that was a while back.
Even as a a stand-alone program it does not have a front-end program built in like he seems to be looking for. Correct me if I'm wrong but in stand-alone mode, you still have no on-screen indicator that a program is running. At least when I run it as part of Uniform Server (search http://www.sf.net, it's there) I don't have any.
=C=
MemberYou are a windows user, aren't you. 🙂
(Sorry, had to take the cheap shot)
1: MySQL is a service. There is no program to run, you just start the service. Once it is running, there is no visible sign that the program is running. (Other than your system is slower now) MySQL comes with a system tray app for windows that I BELIEVE starts up when the service does (at least on Win2k it did, last time I used MySQL on windows)
If there is NO OTHER WAY you can tell if it is running on your box, open a DOS box and type
telnet localhost 3306
You should get some sort of string showing the version of mysql running and then it should disconnect. If you get this, you are up and running and ready for #2. If not, something isn't right, retreat to the docs or shake the magic 8-ball here again.
2: SQLyog is the program you are expecting to see when you start MySQL. It is a client to the server and allows you to interact with the server. If you are used to Access then you've got a steep learning curve because it's nothing like Access. Once you get SQLyog installed and running the first thing you have to do is tell it what server you want to connect to. Since your server is local then in the HostAddress just put localhost. In username and password you can put the username and password you assigned yourself or use root and an empty password. (I believe that is the default, I may be wrong.) If you do use root and empty password then please at least change the password when you get connected.
If you've done everything right then you should see the SQLyog database list on the left and the command window on the right. You probably only have 2 databases at this point MySQL and test. You can use test for…testing but leave the mysql database alone. If you don't like test, right click on the server (at the very top of the list of databases) and create you a new one.
HTH, if you have other questions, just ask, I may be sarcastic, but I try to be helpful. 🙂
=C=
p.s. I use Windows too.
MemberGreetings:
1: Port Number does matter. 3306 is the default biut you need to make sure you check with your system administrator (your host) to confirm.
2: The address you need to log in with is your login It will add @yourmachine and try to log you in.
3: It sounds like from your description that the machine you are trying to connect to is not running Mysql. If it is running mysql then it may be running it on a different port or not allowing it to connect to the IP address you are trying to use.
Suggestions:
1: Contact your host and find out the ip address or machine name you need to connect to:
2: Find out your login and password
3: Try connecting again.
Documentation for mysql can be found at http://www.mysql.com
HTH,
=C=
MemberCan you connect to localhost via any other client? From the looks of the error, your server is fubar.
=C=
MemberCan you post the sql used to create the tables?
=C=
Memberbtafoya wrote on Aug 25 2003, 02:46 PM:drag and drop the column names and table names into the SQL editor.Can I get an A-MEN?
I agree, this would be a great feature.
=C=
MemberI've encountered this several times also but it has never been the fault of sqlyog.
For some reason the mysql deamon died. The last time I had this happen was because I had a corrupt index.
Try using the mysql command line tool to execute the same query. See if it finishes. (I'm betting it won't.)
=C=
MemberExcellent!
MemberGood idea! You can open multiple windows to the same server and execute the queries in different windows. Then you can swap between the windows.
That's how I do it.
=C=
-
AuthorPosts
