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>