December 8th, 1999, 02:57 PM
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.
December 8th, 1999, 03:54 PM
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 firstname.lastname@example.org -u user -p
December 8th, 1999, 05:50 PM
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.
December 14th, 1999, 09:30 AM
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.
[This message has been edited by PAV (edited 12-14-99).]
December 14th, 1999, 01:03 PM
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.