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
What happens if you login as root user in phpmyadmin, do you see the databases? This might be related, if it worked before.
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 HTML: [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
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.
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
