MySQL Permissions

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alan Searle
    #1

    MySQL Permissions

    I have installed mysql (under SuSE 8.1) and everything seems to work
    fine when I am logged in as root. However, with my normal user profile
    I can get a mysql> prompt but have no permissions to carry out any
    database operations.

    I would really like to work with my normal profile and am hoping that it
    is merely a question of setting permissions correctly. Can anyone tell
    me which files and paths I should check (and change)?

    Ideally, I would like mysql to create and manage the database files in
    my normal /home directory (rather than in the mysql directories). Is
    this possible? Is this desirable? Which settings would I need to
    change to allow this? Or should I just let mysql create the databases
    in it's default directory and set the permissions there?

    Any tips would be gatefully received.

    Regards,
    Alan Searle

    Tags: None
    • Aggro
      #2
      Re: MySQL Permissions

      Alan Searle wrote:
      [color=blue]
      > I have installed mysql (under SuSE 8.1) and everything seems to work
      > fine when I am logged in as root. However, with my normal user profile
      > I can get a mysql> prompt but have no permissions to carry out any
      > database operations.[/color]

      As a root user, create a database and give permissions to the user:

      GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password";

      fw_error_www
      http://www.mysql.com/doc/en/GRANT.html


        Comment

        • Aggro
          #3
          Re: MySQL Permissions

          Alan Searle wrote:
          [color=blue]
          > I have installed mysql (under SuSE 8.1) and everything seems to work
          > fine when I am logged in as root. However, with my normal user profile
          > I can get a mysql> prompt but have no permissions to carry out any
          > database operations.[/color]

          As a root user, create a database and give permissions to the user:

          GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password";

          fw_error_www
          http://www.mysql.com/doc/en/GRANT.html


            Comment

            • Alan Searle
              #4
              Re: MySQL Permissions

              Excellent.

              This looks like the syntax that I need.

              I'll check the document pages too.

              Thanks,
              Alan.

              Aggro wrote:[color=blue]
              > Alan Searle wrote:
              >[color=green]
              >> I have installed mysql (under SuSE 8.1) and everything seems to work
              >> fine when I am logged in as root. However, with my normal user profile
              >> I can get a mysql> prompt but have no permissions to carry out any
              >> database operations.[/color]
              >
              >
              > As a root user, create a database and give permissions to the user:
              >
              > GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password";
              >
              > http://www.mysql.com/doc/en/GRANT.html
              >[/color]


                Comment

                • Alan Searle
                  #5
                  Re: MySQL Permissions

                  Excellent.

                  This looks like the syntax that I need.

                  I'll check the document pages too.

                  Thanks,
                  Alan.

                  Aggro wrote:[color=blue]
                  > Alan Searle wrote:
                  >[color=green]
                  >> I have installed mysql (under SuSE 8.1) and everything seems to work
                  >> fine when I am logged in as root. However, with my normal user profile
                  >> I can get a mysql> prompt but have no permissions to carry out any
                  >> database operations.[/color]
                  >
                  >
                  > As a root user, create a database and give permissions to the user:
                  >
                  > GRANT ALL ON database.* TO user@localhost IDENTIFIED BY "password";
                  >
                  > http://www.mysql.com/doc/en/GRANT.html
                  >[/color]


                    Comment

                    Previous template Next
                    Working...