Thread: ALTER problem

    #1
  1. No Profile Picture
    thelem
    Guest
    Devshed Newbie (0 - 499 posts)
    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
  2. #2
  3. No Profile Picture
    rycamor
    Guest
    Devshed Newbie (0 - 499 posts)
    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
  4. #3
  5. No Profile Picture
    thelem
    Guest
    Devshed Newbie (0 - 499 posts)
    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.
  6. #4
  7. No Profile Picture
    PAV
    Guest
    Devshed Newbie (0 - 499 posts)
    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).]
  8. #5
  9. No Profile Picture
    thelem
    Guest
    Devshed Newbie (0 - 499 posts)
    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

Similar Threads

  1. UTF-8 problem in 4.1.1a
    By mehran20 in forum MySQL Help
    Replies: 1
    Last Post: February 8th, 2004, 03:21 PM
  2. Redirection problem with frames.....
    By ykwongss in forum PHP Development
    Replies: 0
    Last Post: January 21st, 2003, 11:07 AM
  3. Strange problem with variables passed via URL
    By C3P0 in forum PHP Development
    Replies: 3
    Last Post: January 13th, 2003, 02:29 PM
  4. PHP / Cron / Shell Script problem, help needed
    By badhaiku.dk in forum PHP Development
    Replies: 3
    Last Post: January 9th, 2003, 01:08 PM
  5. ld problem in Apache build w/ PHP
    By Eric Anderson in forum Apache Development
    Replies: 3
    Last Post: April 9th, 2001, 02:18 AM

IMN logo majestic logo threadwatch logo seochat tools logo