[Gslug-general] Stuck on what should be easy

[Jonathan Nicol]

"localhost" is a special word to mysql; it will ignore the port and  
connect via socket. You'd have to force it to use TCP with -- 
protocol=tcp

mysql -h localhost -P 10000 -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.

mysql -h 127.0.0.1 -P 10000 -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

I think Frank's problem as others have mentioned are conflicting  
grants. From the last table I saw he should be able to connect with a  
blank password.



Jonathan


On Feb 10, 2009, at 11:14 AM, Josh Miller wrote:

> daleville at gmail.com wrote:
>
>> Actually this isn't necessarily true. If iptables has the port  
>> closed or
>> mysql isn't listening on the port you will get this access denied  
>> error.
>> Example:
>> $mysql -h localhost -P 10000 -u root -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: YES)
>
> I can't reproduce these results.  Are you using an old client?
>
>
> $ mysql -h localhost -P 10000 -u root -p
> Enter password:
> ERROR 2002 (HY000): Can't connect to local MySQL server through  
> socket '/var/lib/mysql/mysql.sock' (2)
>
>
> -- 
> Josh Miller, RHCE/VCP
> Seattle, WA
>
> _______________________________________________
> Gslug-general mailing list
> Gslug-general at gslug.org
> http://lists.gslug.org/mailman/listinfo/gslug-general