Find the answer to your Linux question:
Page 2 of 2 FirstFirst 1 2
Results 11 to 12 of 12
Hi again everyone, I have some problems in mysql. Whilst I'm in there as root I give this command to give permission to michshelly to access the employee database: GRANT ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #11
    Just Joined!
    Join Date
    Feb 2006
    Posts
    17

    Hi again everyone,

    I have some problems in mysql.

    Whilst I'm in there as root I give this command to give permission to michshelly to access the employee database:

    GRANT ALL ON employees.* TO michshelly@localhost IDENTIFIED BY "eagle"

    Apparantely the "eagle" is the password according to a tutorial I am following.
    Then when I get out of mysql as root and try to log in as michshelly by using:

    mysql -u user_name -p

    It says 'Access Denied'. However I can just log in by typing:

    mysql -u michshelly

    I can see databases but not the employee database that was created by root.

    Can someone help me please? It would be much appreciated!

    Thanks thanks
    Michelle

  2. #12
    Just Joined!
    Join Date
    Feb 2006
    Posts
    51
    These are coppied from MYSQL manual. I use exactly the same syntax and it works fine. try it.

    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
    mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •