Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 7 Apr 2004 16:34:58 -0700 (PDT)
From:      Sascha Valckenier Kips <merlin.germany@gmx.net>
To:        freebsd-gnats-submit@FreeBSD.org
Subject:   ports/65305: MySQL Server 4.1.0-alpha 'Lost Connection'
Message-ID:  <200404072334.i37NYwLC045628@www.freebsd.org>
Resent-Message-ID: <200404072340.i37NeCRO073419@freefall.freebsd.org>

next in thread | raw e-mail | index | archive | help

>Number:         65305
>Category:       ports
>Synopsis:       MySQL Server 4.1.0-alpha 'Lost Connection'
>Confidential:   no
>Severity:       critical
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Wed Apr 07 16:40:12 PDT 2004
>Closed-Date:
>Last-Modified:
>Originator:     Sascha Valckenier Kips
>Release:        5.1-Release
>Organization:
>Environment:
FreeBSD ppp-gate.svk.de 5.1-RELEASE FreeBSD 5.1-RELEASE #18: Thu Jul 31 23:08:02 CEST 2003     root@ppp-gate.svk.de:/usr/src/sys/i386/compile/GATE_P2_SMP  i386
>Description:
after Portupgrade does the MySQL Server not correct working.
Users on the database without password can work normaly, but user with password became 'ERROR 2013 (HY000): Lost connection to MySQL server during query'     
>How-To-Repeat:
I have my Data from the Version 4.0.1 packed in a tar an moved from the data-directory.
2. Step i have created a new database with "mysql_install_db".
3. Step i have the data-directory give to the mysql user and mysql group with 'chown -R mysql:mysql /var/db/mysql'
4. I have started the mysql-server
5. I have started the client with 'mysql'
6. I have removed any lines without a user from the mysql database table user.
7. I have now 2 Entry's in the User-Table. one for localhost and one for the hostname 'ppp-gate'
8. I have with "GRANT ALL PRIVILEGES ON *.* TO 'root'@'ppp-gate' IDENTIFIED BY 'password' WITH GRANT OPTION;" the password set and the same for the localhost.
9. I have reload the privileged with 'flush privileges;'
10. I have started a 2. Client with 'mysql -uroot -ppassword'. The connect is working.
11. Now i have 'select version();' tryed. and become the Error 'ERROR 2013 (HY000): Lost connection to MySQL server during query'
12. With the first client i have remove the password with 'GRANT ALL PRIVILEGES ON *.* TO 'root'@'ppp-gate' IDENTIFIED BY '' WITH GRANT OPTION;' and for localhost too.
13. Now 'flush privileges;'
14. With the 2. Client new connected. 'mysql -uroot'
15. Connect is okay.
16. Recheck 'select version;' return from the server '4.1.0-alpha'.

What can i do to correct the problem ?
>Fix:
     
>Release-Note:
>Audit-Trail:
>Unformatted:



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200404072334.i37NYwLC045628>