[TYPO3] Typo3 and connection to mysql on non standard port

[Peter Russ]

--- Original Nachricht ---
Absender:   Sascha Egerer
Datum:       16.10.2007 15:43:
> Marco Antonioli schrieb:
>> Hi Peter
>> you are right!!
>>
>> 1) if I try with:
>> mysql_connect('localhost:3307', 'myuser', 'mypass')
>>
>> "Access denied for user: 'myUser at localhost' (Using password: YES) in 
>> /xxx/test_db5.php on line 3
>> 1 Could not connect: Access denied for user: 'ram at localhost' (Using 
>> password: YES)
>> "
>> I think that with localhost php ignores the port and send request on 
>> standard port
>>
>>
>> 2) then if I connect with
>>
>> mysql_connect('127.0.0.1:3307', 'myuser', 'mypass')
>>
>> "Client does not support authentication protocol requested by server; 
>> consider upgrading MySQL client in /xxx/test_db5.php on line 11
>> 2 Could not connect: Client does not support authentication protocol 
>> requested by server; consider upgrading MySQL client"
>>
>> If I check in php.ini
>> Client API version     4.0.20
>>
>> Maybe this is the problem.
>>
>> Thanks!!!
>> marco
>>
>>
>>
>> Peter Russ ha scritto:
>>> --- Original Nachricht ---
>>> Absender:   Marco Antonioli
>>> Datum:       16.10.2007 13:57:
>>>> Hi Peter
>>>>
>>>> from install tool:
>>>> "Could not connect to SQL database!"
>>>>
>>>> Attempting to connect to backend:
>>>> "The current username, password or host was not accepted when the 
>>>> connection to the database was attempted to be established!
>>>> Database Error"
>>>>
>>>> This also with sock..
>>>>
>>>> Is there a debug to activate or something similar to see more 
>>>> specific error messages?
>>>>
>>>> thanks again
>>>> marco
>>>
>>> Did you try to connect with a simple php to the database?  Check the 
>>> settings for the mysql-user and change from @* to @localhost.
>>>
>>>
>>> Regs. Peter.
>>>
>>>
> 
> Maybe the problem is the new Password encryption from MySQL.
> 
> Try to set the MySQL User-Password like that
> 
> mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
>     -> WHERE Host = 'some_host' AND User = 'some_user';
> mysql> FLUSH PRIVILEGES;
> 
> 
> For more informations:
> http://dev.mysql.com/doc/refman/5.0/en/old-client.html

As this is available since 4.x I expected that this should not create 
any problem as you are running 4.0.x in parallel.

But finally we've git it.

Regs.

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
XING: http://www.xing.com/go/invuid/Peter_Russ