Manage Learn to apply best practices and optimize your operations.

Can't run commands from prompt, can't run Web pages from other workstations

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

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 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 last published in January 2005

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.