[Bug 542543] Re: Access denied for user 'root'@'localhost' to database SOMEDB

[Thomas C.]

** Description changed:

  When I try to give my user xy rights to database xy I receive the access
  denied message:
  
  mysql> CREATE USER 'testdb1'@'localhost' IDENTIFIED BY 'testpw';
  Query OK, 0 rows affected (0.00 sec)
  
  mysql> GRANT USAGE ON * . * TO 'testdb1'@'localhost' IDENTIFIED BY 'testpw' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
  Query OK, 0 rows affected (0.00 sec)
  
  mysql> CREATE DATABASE `testdb1` ;
  Query OK, 1 row affected (0.00 sec)
  
  mysql> GRANT ALL PRIVILEGES ON `testdb1` . * TO 'testdb1'@'localhost';
  ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'testdb1'
  
  I restored the complete database from an mysql-server-5.0 5.0.32-7etch12
  which I created with
  
  mysqldump --comments --routines --opt --all-databases --flush-logs
  --user=debian-sys-maint --password=XYZ
  
  I searched the web and found only this two reports which the same
  problem, but without an solution:
  
  http://forums.mysql.com/read.php?10,175497,175497
  http://forums.mysql.com/read.php?11,302793,302793
  
  But I think it is an bug in mysql, because I should handle it correctly
  
  ProblemType: Bug
  Architecture: amd64
  Date: Sat Mar 20 10:36:14 2010
  DistroRelease: Ubuntu 10.04
  Logs.var.log.daemon.log:
-  
+ 
  Logs.var.log.kern.log:
-  Mar 16 22:28:46 s01 kernel: [298533.765967] type=1505 audit(1268778526.035:11):  operation="profile_replace" pid=28473 name="/usr/sbin/mysqld"
-  Mar 16 22:28:46 s01 kernel: [298533.953508] type=1505 audit(1268778526.223:16):  operation="profile_replace" pid=28511 name="/usr/sbin/mysqld"
-  Mar 18 07:31:05 s01 kernel: [   15.121192] type=1505 audit(1268893865.748:9):  operation="profile_load" pid=960 name="/usr/sbin/mysqld"
- MySQLVarLibDirListing: ['ibdata1', 'deathkeeper', 'web3aps1', 'usr_web1_1', 'sandrassql1', 'debian-5.1.flag', 'brain', 'claudiabsql1', 'alientxcsql3', 'bbb', 'raeschnix', 'roundcube', 'hsvkirchhsql2', 'soundpack', 'web3aps2', 'RoiderZsql1', 'roundcubemail', 'hochzeit_cj', 'mysql', 'alientxcsql2', 'teamspeak', 'dune at 002drockmusic', 'syscp at 002eold', 'ib_logfile1', 'phpmyadmin', 'ts3db', 'schwarzhsql1', 's01.pid', 'projekte', 'rdsport', 'hsvkirchhsql1', 'snort_db', 'syscp', 'meefisko', 'tws at 002dclan', 'alientxcsql1', 'testdb1', 'alientxcsql4', 'mysql_upgrade_info', 'karincsql2', 'ib_logfile0', 'gehirn', 'rockihsql1', 'apachelogs', 'karincsql1']
+  Mar 16 22:28:46 s01 kernel: [298533.765967] type=1505 audit(1268778526.035:11):  operation="profile_replace" pid=28473 name="/usr/sbin/mysqld"
+  Mar 16 22:28:46 s01 kernel: [298533.953508] type=1505 audit(1268778526.223:16):  operation="profile_replace" pid=28511 name="/usr/sbin/mysqld"
+  Mar 18 07:31:05 s01 kernel: [   15.121192] type=1505 audit(1268893865.748:9):  operation="profile_load" pid=960 name="/usr/sbin/mysqld"
+ MySQLVarLibDirListing: ['ibdata1', 'OOO', 'web3aps1', 'usr_web1_1', 'sandrassql1', 'debian-5.1.flag', 'brain', 'claudiabsql1', 'lalasql3', 'bbb', 'XXnix', 'roundcube', 'hsvkirchhsql2', 'soundpack', 'web3aps2', 'ililsql1', 'roundcubemail', 'hochzeit_cj', 'mysql', 'lalasql2', 'teamspeak', 'dune at 002drockmusic', 'syscp at 002eold', 'ib_logfile1', 'phpmyadmin', 'ts3db', 'schwarzhsql1', 's01.pid', 'projekte', 'rdsport', 'hsvkirchhsql1', 'snort_db', 'syscp', 'wowo', 'tws at 002dclan', 'lalasql1', 'testdb1', 'lalasql4', 'mysql_upgrade_info', 'karincsql2', 'ib_logfile0', 'gogo', 'rockihsql1', 'apachelogs', 'karincsql1']
  Package: mysql-server 5.1.41-3ubuntu7
  PackageArchitecture: all
  ProcEnviron:
-  LANG=de_DE.UTF-8
-  SHELL=/bin/bash
+  LANG=de_DE.UTF-8
+  SHELL=/bin/bash
  ProcVersionSignature: Ubuntu 2.6.32-16.25-generic
  SourcePackage: mysql-dfsg-5.1
  Uname: Linux 2.6.32-16-generic x86_64
+ 
+ EDIT: Changed private DB names from MySQLVarLibDirListing

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