Q
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 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.

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close