Your message dated Sat, 20 May 2006 22:24:48 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Bug#367789: Installing mysql-server STILL produces
inaccessible db.
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
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:
--- End Message ---
--- Begin Message ---
On 2006-05-18 s. keeling wrote:
> That works, thanks. I do wish you could fold in getting a root
> password (and user and user password?) at install time. Wouldn't that
> keep me from ragging on you everytime this happens? :-)
Ok, I close this bug. Setting a root password at install time is currently
already being discussed in another bug report. It will probably come.
bye,
-christian-
--- End Message ---
