Package: mysql-server-4.1
Version: 4.1.11a-4sarge7
Severity: normal
Creating a database "useraccdb", and a user "useracc", wishing to grant all
privileges to the user "useracc" for the database "useraccdb" and any of its
tables, the `User` entry in the mysql.db table gets
truncated, and shows only "userac" (note the missing c at the end).
How to repeat (as "root" user in mysql):
create database useraccdb;
insert into user (host, user, password) values ('localhost', 'useracc',
password('SECRET'));
grant all on useraccdb.* to useracc;
select * from db;
This will show something like:
/../
| % | useraccdb | userac | Y | Y | Y
/../
...which is incorrect, it should show "useracc", not "userac".
Curious as to whether you get the same results.
Best regards,
Björn
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.17.6.060718-01-dell-custom
Locale: LANG=swedish, LC_CTYPE=swedish (charmap=ISO-8859-1) (ignored: LC_ALL
set to swedish)
Versions of packages mysql-server-4.1 depends on:
ii adduser 3.63 Add and remove users and groups
ii debconf 1.4.30.13 Debian configuration management sy
ii libc6 2.3.2.ds1-22sarge4 GNU C Library: Shared libraries an
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libgcc1 1:3.4.3-13sarge1 GCC support library
ii libmysqlclient14 4.1.11a-4sarge7 mysql database client library
ii libncurses5 5.4-4 Shared libraries for terminal hand
ii libreadline4 4.3-11 GNU readline and history libraries
ii libstdc++5 1:3.3.5-13 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra
ii mailx 1:8.1.2-0.20040524cvs-4 A simple mail user agent
ii mysql-client-4.1 4.1.11a-4sarge7 mysql database client binaries
ii mysql-common-4.1 4.1.11a-4sarge7 mysql database common files (e.g.
ii passwd 1:4.0.3-31sarge9 change and administer password and
ii perl 5.8.4-8sarge5 Larry Wall's Practical Extraction
ii psmisc 21.5-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.2-4.sarge.2 compression library - runtime
-- debconf information:
mysql-server-4.1/start_on_boot: true
mysql-server-4.1/postrm_remove_databases: false
* mysql-server-4.1/mysql_install_db_notes:
mysql-server-4.1/mysql_update_hints1:
mysql-server-4.1/nis_warning:
