Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: