Passwort für Datenbanken

**Abraxax** · 06.07.2003, 18:29

es gibt ein tool namens mysqladmin unter linux. damit kann man sein pw für den root-user der DB auch setzen und ändern.

bei der win-version sollte das auch dabei sein.

BTW
*VERSCHIEB* nach installationsfragen

**clubbiker** · 06.07.2003, 18:38

ja richtig, ich habe diese programm. ich kann nur nicht erkennen, wie ich von dort aus einer datenbank password und username vergebe.

**Abraxax** · 06.07.2003, 19:31

du vergibst nicht aus der DB das pw sondern dafür ...

hier mal die anleitung vom linux

Code:

[root@sun root]# mysqladmin --help
mysqladmin  Ver 8.23 Distrib 3.23.56, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....

  -#, --debug=...       Output debug log. Often this is 'd:t:o,filename`
  -f, --force           Don't ask for confirmation on drop database; with
                        multiple commands, continue even if an error occurs
  -?, --help            Display this help and exit
  --character-sets-dir=...
                        Set the character set directory
  -C, --compress        Use compression in server/client protocol
  -h, --host=#          Connect to host
  -p, --password[=...]  Password to use when connecting to server
                        If password is not given it's asked from the tty
  -P  --port=...        Port number to use for connection
  -i, --sleep=sec       Execute commands again and again with a sleep between
  -r, --relative        Show difference between current and previous values
                        when used with -i. Currently works only with
                        extended-status
  -E, --vertical        Print output vertically. Is similar to --relative,
                        but prints output vertically.
  -s, --silent          Silently exit if one can't connect to server
  -S, --socket=...      Socket file to use for connection
  -u, --user=#          User for login if not current user
  -v, --verbose         Write more information
  -V, --version         Output version information and exit
  -w, --wait[=retries]  Wait and retry if connection is down

Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf 
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit
--no-defaults           Don't read default options from any options file
--defaults-file=#       Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Possible variables for option --set-variable (-O) are:
connect_timeout       current value: 0
shutdown_timeout      current value: 3600

Where command is a one or more of: (Commands may be shortened)
  create databasename   Create a new database
  drop databasename     Delete a database and all its tables
  extended-status       Gives an extended status message from the server
  flush-hosts           Flush all cached hosts
  flush-logs            Flush all logs
  flush-status          Clear status variables
  flush-tables          Flush all tables
  flush-threads         Flush the thread cache
  flush-privileges      Reload grant tables (same as reload)
  kill id,id,...        Kill mysql threads
  password new-password Change old password to new-password
  ping                  Check if mysqld is alive
  processlist           Show list of active threads in server
  reload                Reload grant tables
  refresh               Flush all tables and close and open logfiles
  shutdown              Take server down
  status                Gives a short status message from the server
  start-slave           Start slave
  stop-slave            Stop slave
  variables             Prints variables available
  version               Get version info from server
[root@sun root]#

sowas muss auch unter win gehen. (also das anzeigen der hilfe...

**bohni** · 06.07.2003, 19:40

falls du für einzelne datenbanken usernamen und passwörter vergeben möchtest, gibts in mysql eine datenbank 'mysql', in der usernamen und passwörter und rechte für einzelne datenbanken vergeben kannst.
für den standard-zugang steht der zugang in der my.ini drin (leider unverschlüsselt).
weiteres in der mysql-doku.

Passwort für Datenbanken