ALTER problem

When I telnet into my MySQL account I always get an access denied error (forgotton the exact message).

Does anybody know why this is? I have tried with empty tables and new tables. Somebody said something about a primary key but I cannot set this without access to ALTER so that would not make sense.

TIA
Lemming

When connecting, are you specifying which host you are logging in as? When setting up mysql users, you can restrict them to certain hosts.

ex. mysql -h localhost -u user -p
or mysql -h host@hostname.net -u user -p

I use "mysql -p -hwww.lemnet.com", it seems to pickup my username from my telnet login, but prompts for a password. I also have to specify the database.

Your Telnet userid does not have to be the same as your MySQL loginid. So always login into MySQL using: mysql [-h host] -u userid -p

As I understand from your message, you are able to login into the MySQL server, but are unable to perform ALTER queries on tables.
Ask your MySQL-administrator if you have the proper privileges. You need extra privileges to perform ALTER, LOAD DATA INFILE queries etc.

Good luck!

Peter

[This message has been edited by PAV (edited 12-14-99).]

Yeah, that is what I meant. Guess I just assumed I had said more than I really did.

I went to tech support already, and they just sent me back here. I know someone there who knows about perl and I think manages the MySQL functions so hopefully they will be able to help me.

Thanks,
Lemming