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]