** 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', 'd...@002drockmusic', 'sy...@002eold', 'ib_logfile1', 'phpmyadmin', 'ts3db', 'schwarzhsql1', 's01.pid', 'projekte', 'rdsport', 'hsvkirchhsql1', 'snort_db', 'syscp', 'meefisko', 't...@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', 'd...@002drockmusic', 'sy...@002eold', 'ib_logfile1', 'phpmyadmin', 'ts3db', 'schwarzhsql1', 's01.pid', 'projekte', 'rdsport', 'hsvkirchhsql1', 'snort_db', 'syscp', 'wowo', 't...@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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs