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]

Reply via email to