[TYPO3] Typo3 and connection to mysql on non standard port SOLVED
Marco Antonioli
antonioli at gammsystem.com
Tue Oct 16 17:18:16 CEST 2007
Thanks guys!!
I change password using OLD_PASSWORD as suggested by Sascha.
using 127.0.0.1:3307 now works
using localhost:3307 doesn't works "Access denied...", but I guess that
php still uses STANDARD port, ignoring :3307.
thanks all!
Marco
Sascha Egerer ha scritto:
> 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
More information about the TYPO3-english
mailing list