I can't run almost all MySQL commands from the prompt. What seems to be the problem? I can only run select statemements...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.
Dig Deeper on Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.