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

Thomas C. thomas.creutz at gmx.de
Sat Mar 20 09:45:50 GMT 2010


Public bug reported:

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

** Affects: mysql-dfsg-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug lucid

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