Bug 65305

Summary: MySQL Server 4.1.0-alpha 'Lost Connection'
Product: Ports & Packages Reporter: Merlin.Germany <Merlin.Germany>
Component: Individual Port(s)Assignee: Alex Dupre <ale>
Status: Closed FIXED    
Severity: Affects Only Me    
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   

Description Merlin.Germany 2004-04-08 00:40:12 UTC 
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 ?
Comment 1 Kirill Ponomarev freebsd_committer freebsd_triage 2004-04-08 09:07:43 UTC 
Responsible Changed
From-To: freebsd-ports-bugs->ale

Over to maintainer.
Comment 2 Alex Dupre freebsd_committer freebsd_triage 2004-04-08 09:30:57 UTC 
Did you update from 4.0.1 to 4.1.0 ?! Do you like only pre-alpha 
releases? :-) To begin with, update to 4.1.1 and let the port handle 
your old data directory.

--
Alex Dupre
Comment 3 Alex Dupre freebsd_committer freebsd_triage 2004-05-07 14:37:10 UTC 
State Changed
From-To: open->closed

Obsolate and no feedback.