Schrift
[thread]3354[/thread]

User Berechtigung setzten für MySQL: Raff ich irgendwie nicht (Seite 2)

Leser: 1


<< |< 1 2 >| >> 17 Einträge, 2 Seiten
format_c
 2003-10-09 01:46
#35258 #35258
User since
2003-08-04
1706 Artikel
HausmeisterIn
[Homepage] [default_avatar]
Code: (dl )
1
2
3
4
5
6
7
8
9
mysql> SELECT Host,User FROM mysql.user WHERE User='com75778';
+------+----------+
| Host | User |
+------+----------+
| % | com75778 |
+------+----------+
1 row in set (0.01 sec)

mysql>

Du verstehst meine Ratlosigkeit?! Ich hab dir ne Mail mit der genauen Problembeschreibung geschrieben.
Gruß alex
Strat
 2003-10-09 02:06
#35259 #35259
User since
2003-08-04
5246 Artikel
ModeratorIn
[Homepage] [default_avatar]
vielleicht mal testen, ob es fuer root funktioniert
perl -le "s::*erlco'unaty.'.dk':e,y;*kn:ai;penmic;;print"
http://www.fabiani.net/
format_c
 2003-10-09 02:18
#35260 #35260
User since
2003-08-04
1706 Artikel
HausmeisterIn
[Homepage] [default_avatar]
Nein.
Geht nicht. Ich dreh bald ab.

Gruß Alex
Strat
 2003-10-09 14:30
#35261 #35261
User since
2003-08-04
5246 Artikel
ModeratorIn
[Homepage] [default_avatar]
schau vielleicht mal, ob in der Datei /etc/my.cnf oder /etc/mysqlaccess.conf was einstellbar ist
perl -le "s::*erlco'unaty.'.dk':e,y;*kn:ai;penmic;;print"
http://www.fabiani.net/
format_c
 2003-10-09 15:36
#35262 #35262
User since
2003-08-04
1706 Artikel
HausmeisterIn
[Homepage] [default_avatar]
Also die /etc/mysqlaccess ist (soweit ich das noch in Erinnerung habe) vorhande jedoch leer. Und die /etc/my.cnf war (oh das Gedächtnis) glaub ich nicht vorhanden. antworte nochmal prizise wenn ich heute abend vor der Kiste sitze.

Was muss denn in der mysqlacces drin stehen? Ist das so ne Datei wie /etc/ftpusers ?

Gruß alx
format_c
 2003-10-09 23:34
#35263 #35263
User since
2003-08-04
1706 Artikel
HausmeisterIn
[Homepage] [default_avatar]
So jetzt bin ich daheim
Also auf server.lan.de
/etc/mysqlaccess.conf:
server:/etc # cat mysqlaccess.conf
# ------------------------------------------------------------------------- #
# MySQLaccess version 2.0p2 #
# &copy; 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 #
# &copy; 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
Ronnie
 2003-10-10 02:09
#35264 #35264
User since
2003-08-14
2022 Artikel
BenutzerIn
[default_avatar]
Hi, geben den die Logfiles von MySQL etwas her? Die sollten unter /var/log/mysql sein. Vieleicht hilft dir auch dieser Link:
http://www.mysql.de/doc/de/Access_denied.html

Schau auch mal in die /etc/hosts.allow rein, käme vieleicht auch in Frage.

Gruss,
Ronnie\n\n

<!--EDIT|Ronnie|1065737644-->
<< |< 1 2 >| >> 17 Einträge, 2 Seiten



View all threads created 2003-10-07 23:22.