Package: mysql-server Version: 4.0.24-10sarge1 Severity: important I've already reported this. I installed mysql-server with aptitude. I read /usr/share/doc/mysql-server/README.Debian:
-------------------------------------- * PASSWORDS: ============ It is strongly recommended to set a password for the mysql root user (which is NOT the same as the "normal" root user) with the command: /usr/bin/mysqladmin -u root password 'enter-your-good-new-password-here' If you already had a password set add " -p " before "-u" to the line above. -------------------------------------- (0) heretic [root] /root_ /usr/bin/mysqladmin -u root password '_______' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' (1) heretic [root] /root_ /usr/bin/mysqladmin -p -u root password '_______' Enter password: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' Yes, I know there are hacks out there for fixing this. I'm sick and tired of having to look them up. Shouldn't installing a program in Debian produce a functional program?!? The hacks consist of shutting down MySQL, starting it up insecurely, hammering in the root password, then restarting MySQL. Can't we do better than this? I have a ~root/.my.cnf listing the password I intend to use, and it is chmod 600. [client] user = root password = XXXXXXX [mysql] = root password = XXXXXXX [mysqladmin] = root password = XXXXXXX -- System Information: Debian Release: 3.1 Architecture: i386 (i686) Kernel: Linux 2.6.8-3-686 Locale: LANG=en_CA, LC_CTYPE=en_CA (charmap=ISO-8859-1) Versions of packages mysql-server 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-22sarge3 GNU C Library: Shared libraries an ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu ii libgcc1 1:3.4.3-13 GCC support library ii libmysqlclient12 4.0.24-10sarge1 mysql database client library 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.0.24-10sarge1 mysql database client binaries ii mysql-common 4.0.24-10sarge1 mysql database common files (e.g. ii passwd 1:4.0.3-31sarge5 change and administer password and ii perl 5.8.4-8sarge4 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/nis_warning: mysql-server/really_downgrade_from_41: false mysql-server/mysql_update_hints1: mysql-server/start_on_boot: true mysql-server/postrm_remove_databases: false * mysql-server/mysql_install_db_notes: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]