Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 126668 - mysql-5.0.19 fails grant2 test
Summary: mysql-5.0.19 fails grant2 test
Status: RESOLVED WORKSFORME
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High trivial (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-03-18 08:08 UTC by Henrique Ferreiro
Modified: 2006-05-24 06:30 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Henrique Ferreiro 2006-03-18 08:08:32 UTC 
grant2                         [ fail ]

Errors are (from /var/tmp/portage/mysql-5.0.19/work/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 451: Could not open connection 'con1': 1045 Access denied for user 'mysqltest_1'@'localhost' (using password: YES)

emerge --info:

Portage 2.1_pre6-r3 (default-linux/x86/2005.1, gcc-3.4.5, glibc-2.3.6-r2, 2.6.15-suspend2-r4 i686)
=================================================================
System uname: 2.6.15-suspend2-r4 i686 Intel(R) Pentium(R) M processor 1.60GHz
Gentoo Base System version 1.12.0_pre16
ccache version 2.4 [enabled]
dev-lang/python:     2.4.2-r1
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
sys-devel/binutils:  2.16.1-r2
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r3
ACCEPT_KEYWORDS="x86 ~x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=pentium-m -mtune=pentium-m -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config /usr/share/X11/xkb /usr/share/config /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/splash /etc/terminfo /etc/texmf/web2c /etc/env.d"
CXXFLAGS="-O2 -march=pentium-m -mtune=pentium-m -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig buildpkg candy ccache collision-protect digest distlocks fixpackages metadata-transfer sandbox sfperms strict test userpriv usersandbox"
GENTOO_MIRRORS=" ftp://ftp.belnet.be/mirrors/rsync.gentoo.org/gentoo"
LANG="gl_ES.UTF-8"
LC_ALL="gl_ES.UTF-8"
LINGUAS="gl es"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage-gentopia /usr/local/portage-bmg /usr/local/portage-xgl /usr/local/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 X acpi alsa avahi avi bash-completion beagle bzip2 cairo cups dbus dri dvd dvdr eds emboss encode esd exif fbcon firefox foomaticdb fortran gdbm gif gnome gnutls gphoto2 gpm gstreamer gtk gtk2 gtkhtml hal imlib jpeg libg++ libnotify libwww mad mikmod mmx mmxext mp3 mpeg ncurses nls nptl ogg oggvorbis opengl pdflib pic png quicktime readline samba sse sse2 ssl svg test theora truetype truetype-fonts type1-fonts unicode vorbis xml2 xv zlib elibc_glibc input_devices_evdev input_devices_mouse input_devices_keyboard input_devices_synaptics kernel_linux linguas_gl linguas_es userland_GNU video_cards_ati video_cards_fglrx"
Unset:  ASFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, LDFLAGS
Comment 1 Matt Brooks 2006-03-19 13:17:36 UTC 
try running the following commands and see if this fixes this mysql error:

mysqlcheck --check-upgrade --all-databases --auto-repair
mysql_fix_privilege_tables

I had a similar bug with happening with mysql, but running those commands fixed it.

Thanks
Comment 2 Henrique Ferreiro 2006-03-19 14:16:18 UTC 
$ mysqlcheck --check-upgrade --all-databases --auto-repair 
mysqlcheck: unknown option '--check-upgrade'
Comment 3 Luca Longinotti (RETIRED) gentoo-dev 2006-05-24 06:30:23 UTC 
Can't reproduce this on the latest 5.0.19 and 5.0.21 ebuilds, all tests pass successfully here.
Best regards, CHTEKK.