| 2010-03-20 09:51:46 |
Thomas |
description |
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@002drockmusic', 'syscp@002eold', 'ib_logfile1', 'phpmyadmin', 'ts3db', 'schwarzhsql1', 's01.pid', 'projekte', 'rdsport', 'hsvkirchhsql1', 'snort_db', 'syscp', 'meefisko', 'tws@002dclan', 'alientxcsql1', 'testdb1', 'alientxcsql4', 'mysql_upgrade_info', 'karincsql2', 'ib_logfile0', 'gehirn', 'rockihsql1', 'apachelogs', 'karincsql1']
Package: mysql-server 5.1.41-3ubuntu7
PackageArchitecture: all
ProcEnviron:
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 |
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', '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@002drockmusic', 'syscp@002eold', 'ib_logfile1', 'phpmyadmin', 'ts3db', 'schwarzhsql1', 's01.pid', 'projekte', 'rdsport', 'hsvkirchhsql1', 'snort_db', 'syscp', 'wowo', 'tws@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
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 |
|
