Thread User Berechtigung setzten für MySQL: Raff ich irgendwie nicht
(16 answers)
Opened by format_c at 2003-10-07 23:22
So jetzt bin ich daheim
Also auf server.lan.de /etc/mysqlaccess.conf: server:/etc # cat mysqlaccess.conf # ------------------------------------------------------------------------- # # MySQLaccess version 2.0p2 # # © Yves.Carlier@rug.ac.be, 1997 # # # # *** Configuration file *** # # # # -Default values read by mysqlaccess during initialisation. # # This file is looked for in # # 1) the current directory # # 2) /etc/ # # -Options given on the command-line override the values given in here # # -Given options can't be overruled by empty/blanc options!! # # ------------------------------------------------------------------------- # # ----------------# # Global settings # # --------------- # #$Param{'host'} = ''; $Param{'user'} = 'nobody'; $Param{'db'} = 'test'; $Param{'password'} = 'foobar'; $Param{'debug'} = 0; # --------------------------# # Settings for Command-line # # ------------------------- # if ($CMD) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'brief'} = 1; } # ---------------------# # Settings for CGI-BIN # # -------------------- # if ($CGI) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'table'} = 1; } 1; #to make require happy server:/etc # /etc/my.cnf: server:/etc # cat my.cnf # Example mysql config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # a important part and systems up to 128M very MySQL is used together with # other programs (like a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help opTION. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M log-bin server-id = 1 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=10000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /var/lib/mysql/ #innodb_log_arch_dir = /var/lib/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M # Set .._log_file_size to 25 % of buffer pool size #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #set-variable = innodb_lock_wait_timeout=50 # The safe_mysqld script [safe_mysqld] err-log=/var/lib/mysql/mysqld.log [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout server:/etc # Und die Dateien auf dem Client linux.lan.de /etc/mysqlaccess.conf: linux:/etc # cat mysqlaccess.conf # ------------------------------------------------------------------------- # # MySQLaccess version 2.0p2 # # © Yves.Carlier@rug.ac.be, 1997 # # # # *** Configuration file *** # # # # -Default values read by mysqlaccess during initialisation. # # This file is looked for in # # 1) the current directory # # 2) /etc/ # # -Options given on the command-line override the values given in here # # -Given options can't be overruled by empty/blanc options!! # # ------------------------------------------------------------------------- # # ----------------# # Global settings # # --------------- # #$Param{'host'} = ''; $Param{'user'} = 'nobody'; $Param{'db'} = 'test'; $Param{'password'} = 'foobar'; $Param{'debug'} = 0; # --------------------------# # Settings for Command-line # # ------------------------- # if ($CMD) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'brief'} = 1; } # ---------------------# # Settings for CGI-BIN # # -------------------- # if ($CGI) { $Param{'superuser'} = 'root'; $Param{'rhost'} = 'localhost'; $Param{'spassword'} = ''; $Param{'table'} = 1; } 1; #to make require happy linux:/etc # Naja und wie soll ich sagen. my.cnf gibts net: /etc/my.cnf: linux:/etc # cat m magic mailcap mesa.conf modules.conf motd mtab mysqlaccess.conf mail.rc manpath.config mime.types modules.conf.- mplayer.conf mtools.conf linux:/etc # cat m Sagt dir das irgendwas? Ich hoffe das hilft dir/euch (implizit mir) ;) Gruß Alex |