#1  
Old 13th November 2007, 18:46
nolimitek nolimitek is offline
Junior Member
 
Join Date: Nov 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default phpmyadmin showing no databases

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
Reply With Quote
Sponsored Links
  #2  
Old 14th November 2007, 10:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,983
Thanks: 825
Thanked 5,372 Times in 4,219 Posts
Default

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

Quote:
I have changed yesterday the my.cnf complete can come the problem from this ???
This might be related, if it worked before.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th November 2007, 21:36
nolimitek nolimitek is offline
Junior Member
 
Join Date: Nov 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 Code:
[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
Reply With Quote
  #4  
Old 15th November 2007, 11:04
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,983
Thanks: 825
Thanked 5,372 Times in 4,219 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 15th November 2007, 15:46
nolimitek nolimitek is offline
Junior Member
 
Join Date: Nov 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #6  
Old 15th November 2007, 16:05
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Can you set up a second system with MySQL and then copy over the mysql database?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
perfect setup suse 10 - phpmyadmin & mysql question reddog Server Operation 7 17th June 2006 12:59
site - databases trueshanti Installation/Configuration 20 26th May 2006 01:28
Can't add databases using phpMyAdmin tristanlee85 General 1 19th May 2006 08:45
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45
phpMyAdmin question? ctroyp Installation/Configuration 1 20th March 2006 23:19


All times are GMT +2. The time now is 04:05.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.