[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

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



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



 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 22:44 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *