Re: Post-Installation Setup Problems: error[2002 1604]
Hello. MySQL 3.xx is almost out of support now. Even no bugs fixed in 3.23 (only very critical ones). General reasons about old software and it's problems can be used in your dialog with hosting provider. Usually providers leave servers with MySQL 3.xx in use and provide a new one with MySQL 4.1. Clients port their applications to the new server by themselves (if they want it, of course). grin it get worse . most of my commercial work is running on servers with ver 3.23.X (sun and RH servers). I enjoy a great relationship with my domain hoster (who is also a programmer who uses mysql a lot), but he has been very cautious about upgrading any of his servers, being concerned about code breaking, etc. What argument might be provided to him to upgrade and what caveats might be cited? Thanks very much for the pointer to the docs. regards tim -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
Tim Johnson wrote: grin it get worse . most of my commercial work is running on servers with ver 3.23.X (sun and RH servers). I enjoy a great relationship with my domain hoster (who is also a programmer who uses mysql a lot), but he has been very cautious about upgrading any of his servers, being concerned about code breaking, etc. What argument might be provided to him to upgrade and what caveats might be cited? Details on how to upgrade are available at: http://dev.mysql.com/doc/mysql/en/upgrade.html It seems that the 4.0.x branche will not live very long anymore, so upgrading to 4.1.x (via 4.0) might be a good idea if he wants to upgrade. http://dev.mysql.com/doc/mysql/en/news.html Lists all the changes in each version. The major features can be found in the D.2 and D.3 documents (for 4.1 and 4.0). As a hoster he will probably also need to support PHP, etc. There is also a nice book by Adam Trachtenberg: Upgrading to PHP5 (O'Reilly, July, 2004, 352 p., ISBN 0596006365) which also contains information on how to migrate to PHP5/MySQL4.1 in several steps. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
Hello.
I'm getting the following problems:
Login Problem:
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Problems unencrypting password:
OLD_PASSWORD() is available as of MySQL 4.1. 4.0.20 is a very old
version. I strongly recommend you to upgrade to the latest release
(4.1.13 now).
Tim Johnson [EMAIL PROTECTED] wrote:
Hello:
OS: Linux Slackware 10.0
Ver: 4.0.20
Network Status: Closed to outside world
After installation:
I'm getting the following problems:
Login Problem:
mysql --host=localhost --user=root --password=**
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
What works:
mysql -u tim -p
Enter password: * # works
---
Problems unencrypting password:
SET PASSWORD FOR 'tim'@'localhost' = OLD_PASSWORD('**')
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'OLD_PASSWORD('marion')' at line 1
## Note: am unclear what is wrong with syntax
## Host table dump below:
SELECT Host, User FROM mysql.user;
+---+--+
| Host | User |
+---+--+
| linus | |
| linus | root |
| linus | tim |
| linus.johnson.com | tim |
| localhost | |
| localhost | root |
| localhost | tim |
+---+--+
Any advice is appreciated:
Am working from the installed docs.
Thanks
tj
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Post-Installation Setup Problems: error[2002 1604]
* Gleb Paharenko [EMAIL PROTECTED] [050815 10:59]: Hello. I'm getting the following problems: Login Problem: See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html That's going to be really helpful. Thanks. Problems unencrypting password: OLD_PASSWORD() is available as of MySQL 4.1. 4.0.20 is a very old version. I strongly recommend you to upgrade to the latest release (4.1.13 now). grin it get worse . most of my commercial work is running on servers with ver 3.23.X (sun and RH servers). I enjoy a great relationship with my domain hoster (who is also a programmer who uses mysql a lot), but he has been very cautious about upgrading any of his servers, being concerned about code breaking, etc. What argument might be provided to him to upgrade and what caveats might be cited? Thanks very much for the pointer to the docs. regards tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Post-Installation Setup Problems: error[2002 1604]
Hello:
OS: Linux Slackware 10.0
Ver: 4.0.20
Network Status: Closed to outside world
After installation:
I'm getting the following problems:
Login Problem:
mysql --host=localhost --user=root --password=**
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
What works:
mysql -u tim -p
Enter password: * # works
---
Problems unencrypting password:
SET PASSWORD FOR 'tim'@'localhost' = OLD_PASSWORD('**')
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'OLD_PASSWORD('marion')' at line 1
## Note: am unclear what is wrong with syntax
## Host table dump below:
SELECT Host, User FROM mysql.user;
+---+--+
| Host | User |
+---+--+
| linus | |
| linus | root |
| linus | tim |
| linus.johnson.com | tim |
| localhost | |
| localhost | root |
| localhost | tim |
+---+--+
Any advice is appreciated:
Am working from the installed docs.
Thanks
tj
--
Tim Johnson [EMAIL PROTECTED]
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
