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: '[EMAIL PROTECTED]' (Using password: YES) in >> /xxx/test_db5.php on line 3 >> 1 Could not connect: Access denied for user: '[EMAIL PROTECTED]' (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 _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.netfielders.de http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english