phpmyadmin showing no databases

[nolimitek]

Hi @all

I have installed ispconfig with the perfect debian etch description

All works perfect the last 2 month but now i have a problem
When a user create a database everything is allright but when he open phpmyadmin with db username and the password phpmyadmin opens normal but there are no databases
There only stand "no databases"

But login is normal and works

First i thought ispconfig dont make the database but when i log in as root i find all databases

I have changed yesterday the my.cnf complete can come the problem from this ???

many thanks for your help

regards Chris

[till]

What happens if you login as root user in phpmyadmin, do you see the databases?

I have changed yesterday the my.cnf complete can come the problem from this ???

This might be related, if it worked before.

[nolimitek]

When i log in as root i see all databases
All databases works fine but i cant see it if i log in as the database user created in ispconfig

here is my my.cnf

[client]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8
port                      = 3306
socket                    = /var/run/mysqld/mysqld.sock

[mysql]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8
prompt                    = \u@\h [\d]>\_
no_auto_rehash

[mysqladmin]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8

[mysqlcheck]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8

[mysqldump]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8
max_allowed_packet        = 32M
quote_names
quick

[mysqlimport]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8

[mysqlshow]
character_sets_dir        = /usr/share/mysql/charsets
default_character_set     = utf8

[isamchk]
character_sets_dir        = /usr/share/mysql/charsets
key_buffer_size           = 256M

[myisamchk]
character_sets_dir        = /usr/share/mysql/charsets
key_buffer_size           = 256M

[myisampack]
character_sets_dir        = /usr/share/mysql/charsets

[mysqld_safe]
err_log                   = /var/log/mysql/mysql.err
open_files_limit          = 32768

[mysqld]
character_sets_dir        = /usr/share/mysql/charsets
character_set_server      = utf8
default_character_set     = utf8
user                      = mysql
port                      = 3306
bind_address              = 127.0.0.1
socket                    = /var/run/mysqld/mysqld.sock
pid_file                  = /var/run/mysqld/mysqld.pid
log_error                 = /var/log/mysql/mysqld.err
basedir                   = /usr
datadir                   = /var/lib/mysql
tmpdir                    = /var/tmp
slave_load_tmpdir         = /var/tmp
language                  = /usr/share/mysql/english
#master_host               = <hostname>
#master_user               = <username>
#master_password           = <password>
#master_port               = 3306
log_bin                   = mysql-bin
server_id                 = 1
back_log                  = 50
sync_binlog               = 0
binlog_cache_size         = 1M
max_binlog_size           = 100M
expire_logs_days          = 7
slave_compressed_protocol = 1
lower_case_table_names    = 1
delay_key_write           = ALL
safe_user_create          = 1
myisam_repair_threads     = 1
skip_locking
skip_name_resolve
skip_external_locking
skip_show_database
key_buffer_size           = 384M
max_allowed_packet        = 32M
max_heap_table_size       = 64M
tmp_table_size            = 64M
table_cache               = 1024
query_cache_type          = 1
query_cache_size          = 64M
query_cache_limit         = 4M
thread_concurrency        = 8
thread_cache_size         = 16
max_connections           = 16
max_connect_errors        = 20
ft_max_word_len           = 30
ft_min_word_len           = 3
local_infile              = 0
log_warnings              = 2
long_query_time           = 3
log_slow_queries          = slow-queries.log
#log_queries_not_using_indexes
#log_slave_updates
log_long_format
myisam_recover
#skip_bdb
#skip_innodb
innodb_thread_concurrency       = 8
innodb_buffer_pool_size         = 384M
innodb_additional_mem_pool_size = 16M
innodb_data_home_dir            = /var/lib/mysql
innodb_log_arch_dir             = /var/lib/mysql
innodb_log_group_home_dir       = /var/lib/mysql
innodb_data_file_path           = ibdata1:2000M;ibdata2:10M:autoextend
innodb_flush_method             = O_DIRECT
innodb_log_file_size            = 100M
innodb_log_buffer_size          = 8M
innodb_log_files_in_group       = 2
innodb_flush_log_at_trx_commit  = 1
innodb_max_dirty_pages_pct      = 90
innodb_lock_wait_timeout        = 120

[mysqlhotcopy]
interactive_timeout

[till]

Please check in the mysql permission tables (in the database named "mysql", if the databases belong to the users that you used to log into the server.

[nolimitek]

uhhh der is the mistake
i have no database named mysql :-(

can someone write me the tables from this database that i can configure it

thx a lot

[falko]

Can you set up a second system with MySQL and then copy over the mysql database?