[Bug 542543] Re: Access denied for user 'root'@'localhost' to database SOMEDB
Thomas C.
thomas.creutz at gmx.de
Wed Apr 21 15:16:24 BST 2010
no, thats not the problem
ls -lah /var/lib/mysql/
insgesamt 157M
drwx------ 41 mysql mysql 4,0K 2010-04-19 17:38 .
drwxr-xr-x 63 root root 4,0K 2010-04-19 17:10 ..
drwx------ 2 mysql mysql 4,0K 2010-03-20 09:19 alientxcsql1
drwx------ 2 mysql mysql 4,0K 2010-03-13 10:59 alientxcsql2
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:01 alientxcsql3
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:01 alientxcsql4
drwx------ 2 mysql mysql 4,0K 2010-03-18 12:14 apachelogs
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:01 bbb
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:01 brain
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:01 claudiabsql1
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 deathkeeper
-rw-r--r-- 1 mysql mysql 0 2010-04-19 17:10 debian-5.1.flag
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 dune at 002drockmusic
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 gehirn
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 hochzeit_cj
drwx------ 2 mysql mysql 12K 2010-03-13 11:02 hsvkirchhsql1
drwx------ 2 mysql mysql 4,0K 2010-04-20 21:02 hsvkirchhsql2
-rw-rw---- 1 mysql mysql 146M 2010-04-21 15:34 ibdata1
-rw-rw---- 1 mysql mysql 5,0M 2010-04-21 15:34 ib_logfile0
-rw-rw---- 1 mysql mysql 5,0M 2010-03-19 23:10 ib_logfile1
drwx------ 2 mysql mysql 12K 2010-03-13 11:02 karincsql1
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 karincsql2
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 meefisko
drwx------ 2 mysql mysql 4,0K 2010-04-19 17:10 mysql
-rw-rw---- 1 mysql mysql 6 2010-03-13 01:21 mysql_upgrade_info
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 phpmyadmin
drwx------ 2 mysql mysql 20K 2010-03-13 11:02 projekte
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 raeschnix
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:02 rdsport
drwx------ 2 mysql mysql 20K 2010-03-13 11:03 rockihsql1
drwx------ 2 mysql mysql 12K 2010-03-18 02:14 RoiderZsql1
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:46 roundcube
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:03 roundcubemail
-rw-rw---- 1 mysql mysql 4 2010-04-19 17:38 s01.pid
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:03 sandrassql1
drwx------ 2 mysql mysql 52K 2010-03-24 15:37 schwarzhsql1
drwx------ 2 mysql mysql 4,0K 2010-03-13 15:04 snort_db
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:03 soundpack
drwx------ 2 mysql mysql 12K 2010-03-18 21:06 syscp
drwx------ 2 mysql mysql 12K 2010-03-13 15:22 syscp at 002eold
drwx------ 2 mysql mysql 4,0K 2010-03-14 20:08 teamspeak
drwx------ 2 mysql mysql 4,0K 2010-03-24 01:20 testdb2
drwx------ 2 mysql mysql 4,0K 2010-03-24 00:18 ts3db
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:04 tws at 002dclan
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:04 usr_web1_1
drwx------ 2 mysql mysql 4,0K 2010-03-13 11:04 web3aps1
drwx------ 2 mysql mysql 4,0K 2010-03-19 22:56 web3aps2
ls -lah /var/lib/mysql/mysql
insgesamt 868K
drwx------ 2 mysql mysql 4,0K 2010-04-19 17:10 .
drwx------ 41 mysql mysql 4,0K 2010-04-19 17:38 ..
-rw-rw---- 1 mysql mysql 8,7K 2010-03-13 11:02 columns_priv.frm
-rw-rw---- 1 mysql mysql 11K 2010-03-18 20:25 columns_priv.MYD
-rw-rw---- 1 mysql mysql 8,0K 2010-03-18 20:29 columns_priv.MYI
-rw-rw---- 1 mysql mysql 9,3K 2010-03-13 11:02 db.frm
-rw-rw---- 1 mysql mysql 23K 2010-03-18 15:37 db.MYD
-rw-rw---- 1 mysql mysql 5,0K 2010-03-18 15:37 db.MYI
-rw-rw---- 1 mysql mysql 10K 2010-03-13 01:21 event.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 01:21 event.MYD
-rw-rw---- 1 mysql mysql 2,0K 2010-03-13 01:21 event.MYI
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 func.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 func.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 11:02 func.MYI
-rw-rw---- 1 mysql mysql 35 2010-04-19 17:38 general_log.CSM
-rw-rw---- 1 mysql mysql 0 2010-03-13 01:21 general_log.CSV
-rw-rw---- 1 mysql mysql 8,6K 2010-03-13 01:21 general_log.frm
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 help_category.frm
-rw-rw---- 1 mysql mysql 21K 2010-03-13 11:02 help_category.MYD
-rw-rw---- 1 mysql mysql 3,0K 2010-03-13 11:02 help_category.MYI
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 help_keyword.frm
-rw-rw---- 1 mysql mysql 74K 2010-03-13 11:02 help_keyword.MYD
-rw-rw---- 1 mysql mysql 15K 2010-03-13 11:02 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 help_relation.frm
-rw-rw---- 1 mysql mysql 6,5K 2010-03-13 11:02 help_relation.MYD
-rw-rw---- 1 mysql mysql 13K 2010-03-13 11:02 help_relation.MYI
-rw-rw---- 1 mysql mysql 8,6K 2010-03-13 11:02 help_topic.frm
-rw-rw---- 1 mysql mysql 264K 2010-03-13 11:02 help_topic.MYD
-rw-rw---- 1 mysql mysql 17K 2010-03-13 11:02 help_topic.MYI
-rw-rw---- 1 mysql mysql 9,2K 2010-03-13 11:02 host.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 host.MYD
-rw-rw---- 1 mysql mysql 2,0K 2010-03-13 11:02 host.MYI
-rw-rw---- 1 mysql mysql 8,6K 2010-03-13 01:21 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 01:21 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 01:21 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8,4K 2010-03-13 01:21 plugin.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 01:21 plugin.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 01:21 plugin.MYI
-rw-rw---- 1 mysql mysql 9,5K 2010-03-13 11:02 proc.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 proc.MYD
-rw-rw---- 1 mysql mysql 2,0K 2010-03-13 11:02 proc.MYI
-rw-rw---- 1 mysql mysql 8,7K 2010-03-13 11:02 procs_priv.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4,0K 2010-03-13 11:02 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8,7K 2010-03-13 01:21 servers.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 01:21 servers.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 01:21 servers.MYI
-rw-rw---- 1 mysql mysql 35 2010-04-19 17:38 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 2010-03-13 01:21 slow_log.CSV
-rw-rw---- 1 mysql mysql 8,8K 2010-03-13 01:21 slow_log.frm
-rw-rw---- 1 mysql mysql 8,8K 2010-03-13 11:02 tables_priv.frm
-rw-rw---- 1 mysql mysql 24K 2010-03-18 20:25 tables_priv.MYD
-rw-rw---- 1 mysql mysql 8,0K 2010-03-18 20:29 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 time_zone.frm
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 11:02 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 time_zone.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 11:02 time_zone.MYI
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 11:02 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8,5K 2010-03-13 11:02 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 11:02 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8,6K 2010-03-13 11:02 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 0 2010-03-13 11:02 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1,0K 2010-03-13 11:02 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 11K 2010-04-19 17:10 user.frm
-rw-rw---- 1 mysql mysql 4,3K 2010-04-19 17:10 user.MYD
-rw-rw---- 1 mysql mysql 2,0K 2010-04-19 17:10 user.MYI
the file permissions are right
** Changed in: mysql-dfsg-5.1 (Ubuntu)
Status: Invalid => Incomplete
** Changed in: mysql-dfsg-5.1 (Ubuntu)
Status: Incomplete => New
--
Access denied for user 'root'@'localhost' to database SOMEDB
https://bugs.launchpad.net/bugs/542543
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
More information about the Ubuntu-server-bugs
mailing list