safe_mysqld(1) [redhat man page]

SAFE_MYSQLD    (1)						     mysql.com							SAFE_MYSQLD    (1)

NAME

       safe_mysqld - start the mysqld daemon on Unix.

SYNOPSIS

       safe_mysqld  [--basedir=path]  [--core-file-size=#]  [--defaults-extra-file=path]  [--defaults-file=path] [--open-files=#] [--datadir=path]
       [--err-log=path] [--ledir=path] [--log=path] [--no-defaults] [--open-files=#] [--pid-file=path] [--port=#]  [--socket=path]  [--timezone=#]
       [--user=#]

DESCRIPTION

       safe_mysqld adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file.

       --basedir=path

       --core-file-size=#

       --defaults-extra-file=path

       --defaults-file=path

       --open-files=#
	      Size of the core file mysqld should be able to create. Passed to ulimit -c.

       --datadir=path

       --err-log=path

       --ledir=path
	      Path to mysqld

       --log=path

       --no-defaults

       --open-files=#
	      Number of files mysqld should be able to open. Passed to ulimit -n.

       --pid-file=path

       --port=#

       --socket=path

       --timezone=#
	      Set the timezone (the TZ) variable to the value of this parameter.

       --user=#

NOTE

       Note  that  all options on the command line to safe_mysqld are passed to mysqld. If you wants to use any options in safe_mysqld that mysqld
       doesn't support, you must specify these in the option file.

SEE ALSO

       isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql  (1),  perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver  1.0,  distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with
       no warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mer-
       curmedia.com)

safe_mysqld (mysql)						 19 December 2000						SAFE_MYSQLD    (1)

MYSQLACCESS(1)						      General Commands Manual						    MYSQLACCESS(1)

NAME

       mysqlaccess
	- Create new users to mysql.

USAGE

       mysqlaccess [host [user [db]]] OPTIONS

SYNOPSIS

       mysqlaccess  [-?|--help]  [-v|--version]  [-p|--password=#]  [-h|--host=#] [-d|--db=#] [-U|--superuser=#] [-P|--spassword=#] [-H|--rhost=#]
       [--old_server] [-b|--brief] [-t|--table] [--relnotes] [--plan] [--howto] [--debug=N] [--copy] [--preview] [--commit] [--rollback]

DESCRIPTION

       -?|--help
	      display this helpscreen and exit

       -v|--version
	      print information on the program `mysqlaccess'

       -u|--user=#
	      username for logging in to the db

       -p|--password=#
	      validate password for user

       -h|--host=#
	      name or IP-number of the host

       -d|--db=#
	      name of the database

       -U|--superuser=#
	      connect as superuser

       -P|--spassword=#
	      password for superuser

       -H|--rhost=#
	      remote MySQL-server to connect to

       --old_server
	      connect to old MySQL-server (before v3.21) which does not yet know how to handle full where clauses.

       -b|--brief
	      single-line tabular report

       -t|--table
	      report in table-format

       --relnotes
	      print release-notes

       --plan print suggestions/ideas for future releases

       --howto
	      some examples of how to run `mysqlaccess'

       --debug=N
	      enter debuglevel N (0..3)

       --copy reload temporary grant-tables from original ones

       --preview
	      show differences in privileges after making changes in (temporary) grant-tables

       --commit
	      copy grant-rules from temporary tables to grant-tables (!don't forget to do an mysqladmin reload)

       --rollback
	      undo the last changes to the grant-tables.

NOTE

	   + At least the user and the db must be given (even with wildcards)
	   + If no host is given, `localhost' is assumed
	   + Wilcards (*,?,%,_) are allowed for host, user and db, but be sure
	     to escape them from your shell!! (ie type * or '*')

SEE ALSO

       isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql  (1),  perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver  1.0,  distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with
       no warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mer-
       curmedia.com)

								 19 December 2000						    MYSQLACCESS(1)