Re: [PROGRAMMERING] MySQL, tables, users og sikkerhed

[Peter Maersk-Moller <sslug@sslug>]

Hej Lars

Lars Riisgaard Ribe wrote:
> Kender ikke så meget til http_auth  - kun noget til PHP
> > 4) Hvordan opretter man en eller sådanne bruger/e med eget password.
> i en mysql-client skal du bare skrive:
> GRANT SELECT ON <dbnavn>.<tabelnavn> TO <username> IDENTIFIED BY 
> '<password>'

  # mysql -u XXX -p http_auth
  Enter password:
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A

  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 25248 to server version: 3.23.51

  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

  mysql> GRANT SELECT ON http_auth.user_info TO YYY IDENTIFIED BY 'ABCD';
  Query OK, 0 rows affected (0.04 sec)

  mysql> Bye
  # mysql -u YYY -p http_auth
  Enter password:                                # INDTATSTER ABCD
  ERROR 1045: Access denied for user: 'sslug@sslug' (Using password: YES)
  # mysql -u YYY -p http_auth
  Enter password:                                # INDTATSER 'ABCD'
  ERROR 1045: Access denied for user: 'sslug@sslug' (Using password: YES)

SP1: Gør jeg noget galt ?

SP2: Hvordan sletter jeg bruger YYY ?

   (DENY SELECT ON http_auth.user_info TO YYY) ?

mvh.

--PMM