ports/65305: MySQL Server 4.1.0-alpha 'Lost Connection'
Sascha Valckenier Kips
merlin.germany at gmx.net
Wed Apr 7 23:41:55 UTC 2004
>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 at 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:
More information about the freebsd-ports-bugs
mailing list