phpmyadmin showing no databases

Discussion in 'Installation/Configuration' started by nolimitek, Nov 13, 2007.

  1. nolimitek

    nolimitek New Member

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

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

    This might be related, if it worked before.
     
  3. nolimitek

    nolimitek New Member

    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 
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  5. nolimitek

    nolimitek New Member

    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
     
  6. falko

    falko Super Moderator ISPConfig Developer

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

Share This Page