Re: Probleme bei der Einrichtung von MySQL

["Christian Mack" <Mack_(at)_compal.de>]

Martin Fischer wrote:
> 
> Ich bitte um Hilfe:
> 
> MySQL:  Distrib 3.21.33b, for pc-bsdi3.1 (i386)
> auf virtuellem Apache Server (1.2.6)
> 
> Problem:
> "Access denied for user: '_(at)_localhost' to database 'mysql'"
> 
> Mein Hostprovider gibt leider keinen Support, installiert aber
> mysql_install_db bereits vor.
> Ich habe demnach nur host: localhost und user: root.
> Aber wie komme ich weiter?
> 
> Mein tarball
> -------------------------
> Extracting mysql archive...
> usr
> usr/local
> usr/local/bin
> usr/local/bin/add_file_priv
> usr/local/bin/add_func_table
> usr/local/bin/add_long_password
> usr/local/bin/comp_err
> usr/local/bin/isamchk
> usr/local/bin/isamlog
> usr/local/bin/make_binary_distribution
> usr/local/bin/msql2mysql
> usr/local/bin/mysql
> usr/local/bin/mysql.server
> usr/local/bin/mysql_install_db
> usr/local/bin/mysqlaccess
> usr/local/bin/mysqladmin
> usr/local/bin/mysqlbug
> usr/local/bin/mysqldump
> usr/local/bin/mysqlimport
> usr/local/bin/mysqlshow
> usr/local/bin/perror
> usr/local/bin/replace
> usr/local/bin/safe_mysqld
> usr/local/bin/which1
> usr/local/bin/zap
> usr/local/include
> usr/local/include/mysql
> usr/local/include/mysql/chardefs.h
> usr/local/include/mysql/dbug.h
> usr/local/include/mysql/errmsg.h
> usr/local/include/mysql/history.h
> usr/local/include/mysql/keymaps.h
> usr/local/include/mysql/m_ctype.h.in
> usr/local/include/mysql/m_string.h
> usr/local/include/mysql/my_sys.h
> usr/local/include/mysql/mysql.h
> usr/local/include/mysql/mysql_com.h
> usr/local/include/mysql/mysql_version.h
> usr/local/include/mysql/readline.h
> usr/local/include/mysql/tilde.h
> usr/local/lib
> usr/local/lib/mysql
> usr/local/lib/mysql/libdbug.a
> usr/local/lib/mysql/libheap.a
> usr/local/lib/mysql/libmerge.a
> usr/local/lib/mysql/libmysqlclient.a
> usr/local/lib/mysql/libmystrings.a
> usr/local/lib/mysql/libmysys.a
> usr/local/lib/mysql/libnisam.a
> usr/local/libexec
> usr/local/libexec/mysqld
> usr/local/man
> usr/local/man/man1
> usr/local/man/man1/mysql.1
> usr/local/share
> usr/local/share/mysql
> usr/local/share/mysql/czech
> usr/local/share/mysql/czech/errmsg.sys
> usr/local/share/mysql/czech/errmsg.txt
> usr/local/share/mysql/dutch
> usr/local/share/mysql/dutch/errmsg.sys
> usr/local/share/mysql/dutch/errmsg.txt
> usr/local/share/mysql/english
> usr/local/share/mysql/english/errmsg.sys
> usr/local/share/mysql/english/errmsg.txt
> usr/local/share/mysql/french
> usr/local/share/mysql/french/errmsg.sys
> usr/local/share/mysql/french/errmsg.txt
> usr/local/share/mysql/german
> usr/local/share/mysql/german/errmsg.sys
> usr/local/share/mysql/german/errmsg.txt
> usr/local/share/mysql/italian
> usr/local/share/mysql/italian/errmsg.sys
> usr/local/share/mysql/italian/errmsg.txt
> usr/local/share/mysql/norwegian-ny
> usr/local/share/mysql/norwegian-ny/errmsg.sys
> usr/local/share/mysql/norwegian-ny/errmsg.txt
> usr/local/share/mysql/norwegian
> usr/local/share/mysql/norwegian/errmsg.sys
> usr/local/share/mysql/norwegian/errmsg.txt
> usr/local/share/mysql/polish
> usr/local/share/mysql/polish/errmsg.sys
> usr/local/share/mysql/polish/errmsg.txt
> usr/local/share/mysql/portuguese
> usr/local/share/mysql/portuguese/errmsg.sys
> usr/local/share/mysql/portuguese/errmsg.txt
> usr/local/share/mysql/russian
> usr/local/share/mysql/russian/errmsg.sys
> usr/local/share/mysql/russian/errmsg.txt
> usr/local/share/mysql/spanish
> usr/local/share/mysql/spanish/errmsg.sys
> usr/local/share/mysql/spanish/errmsg.txt
> usr/local/share/mysql/swedish
> usr/local/share/mysql/swedish/errmsg.sys
> usr/local/share/mysql/swedish/errmsg.txt
> usr/local/var
> usr/local/var/mysql
> usr/local/var/mysql/db.ISD
> usr/local/var/mysql/db.ISM
> usr/local/var/mysql/db.frm
> usr/local/var/mysql/func.ISD
> usr/local/var/mysql/func.ISM
> usr/local/var/mysql/func.frm
> usr/local/var/mysql/host.ISD
> usr/local/var/mysql/host.ISM
> usr/local/var/mysql/host.frm
> usr/local/var/mysql/user.ISD
> usr/local/var/mysql/user.ISM
> usr/local/var/mysql/user.frm
> tar: tar vol 1, 109 files, 6912000 bytes read.
> Creating necessary directories...
> done!
> 
> You must now configure the database user list and access controls.
> THIS IS VERY IMPORTANT!  FAILURE TO DO SO MAY COMPROMISE YOUR SERVER
> SECURITY!
> Consult the MySQL documentation at http://www.tcx.se/ for assistance.
> -------------
> 
> D A N K E

Hallo Martin

Da Du nur eine 3.21.xx mysql hast, musst Du die User und ihre Privilegien direkt in die entsprechenden Tabellen eintragen.
Wenn das Script ./scripts/mysql_install_db noch nicht gelaufen ist, solltest Du dort die entsprechenden Aenderungen vornehmen.
Ist es bereits gelaufen, kannst Du ueber das mysql Commandlineinterface die Tabellen user,db,host editieren. Welche Privilegien wie
vergeben werden, kannst Du im mitgelieferten manual nachlesen.

Solltest Du nicht weiterkommen, schreib am besten, welche Privilegien Du einrichten moechtest, dann kann ich dir ein Beispiel
schicken.

Achso ja, vergiss nicht 'mysqladmin reload' nach Aenderungen am Privilegiensystem aufzurufen.

Tschau
Christian