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

[Sascha Egerer]

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