I can't run almost all MySQL commands from the prompt. What seems to be the problem? I can only run select statemements for data retrieval and table commands, but not 'create', 'load', 'show', etc.
Also, you mentioned this in one of your responses: "You will of course want to make sure that any firewall between the machine hosting MySQL and the other machines in the network allows traffic on port 3306." How will I allow network traffic on port 3306? I asked this because I cannot run my Web pages from other workstations. It only works in localhost or 127.0.0.1.
It sounds like your MySQL account is set up in a way that you do not have the appropriate privileges to perform the tasks you wish to perform. I would recommend you contact the server administrator and request the privileges.
As for your second question, it could be a number of things. First, make sure there is no firewall blocking access to the server. Second, make sure that the server is not running with skip-networking and that it is not bound to 127.0.0.1. Finally, make sure that the account you use to connect is not restricted to localhost. It is a good security practice to limit the range of IP addresses that a user can connect from.
This was first published in January 2005