fhripper Posted May 19, 2006 Share Posted May 19, 2006 Hi Guys,PLease bare with me as im new to this and still learningbut heres my so called forums link[a href=\"http://www.clublan.info/forums/\" target=\"_blank\"]http://www.clublan.info/forums/[/a]as you find the following issueWarning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/virtual/web/w0653/html/forums/sources/Drivers/mySQL.php on line 64Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/virtual/web/w0653/html/forums/sources/Drivers/mySQL.php on line 67ERROR: Cannot find databaseWarning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/virtual/web/w0653/html/forums/sources/Drivers/mySQL.php on line 100Now this is a problem as my host just changed servers to the optus data center my host is smarty.I have tryed to contact but seems they a re very busy and wont get back in touch with me..Anyone have any ideas how i can fix this issue i dont wanna loose my forums as there were a few registed member sna a few threads.anyone help pleasee...CheersTim Quote Link to comment https://forums.phpfreaks.com/topic/9990-help-with-php-and-ib-forums/ Share on other sites More sharing options...
wildteen88 Posted May 19, 2006 Share Posted May 19, 2006 All the errors you are getting are caused by the first error message. Once the first error message is solved all the other errors will disappear.To solve this error you will need set the password for your mysql username with the OLD_PASSWORD function.You can do this via the command line/shell if you have access to this. If you dont then ask you host to set your mysql password with the OLD_PASSWORD function.[a href=\"http://dev.mysql.com/doc/refman/5.0/en/old-client.html\" target=\"_blank\"]Click here[/a] for more information on how to set your mysql passord with the OLD_PASSWORD function. Quote Link to comment https://forums.phpfreaks.com/topic/9990-help-with-php-and-ib-forums/#findComment-37113 Share on other sites More sharing options...
fhripper Posted May 19, 2006 Author Share Posted May 19, 2006 [!--quoteo(post=375177:date=May 19 2006, 08:38 PM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ May 19 2006, 08:38 PM) [snapback]375177[/snapback][/div][div class=\'quotemain\'][!--quotec--]All the errors you are getting are caused by the first error message. Once the first error message is solved all the other errors will disappear.To solve this error you will need set the password for your mysql username with the OLD_PASSWORD function.You can do this via the command line/shell if you have access to this. If you dont then ask you host to set your mysql password with the OLD_PASSWORD function.[a href=\"http://dev.mysql.com/doc/refman/5.0/en/old-client.html\" target=\"_blank\"]Click here[/a] for more information on how to set your mysql passord with the OLD_PASSWORD function.[/quote]Im sorry but i have no idea how to do this ... I cannot contact my host as there useless and this is driving me crazy ..im with smarty hostCould you explained it a little easyer on what i have to doo Quote Link to comment https://forums.phpfreaks.com/topic/9990-help-with-php-and-ib-forums/#findComment-37115 Share on other sites More sharing options...
fhripper Posted May 19, 2006 Author Share Posted May 19, 2006 Ok ifound a SQL qury box in PHP my admin for the serverthis is the responce i got#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> SET PASSWORD FOR -> 'w0653@localhost' = OLD_PASSWORDupdatei was able to runSET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');and it said it was fine but still issues with site... Quote Link to comment https://forums.phpfreaks.com/topic/9990-help-with-php-and-ib-forums/#findComment-37125 Share on other sites More sharing options...
wildteen88 Posted May 19, 2006 Share Posted May 19, 2006 You should use this query:[code]SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');[/code]Make sure that you change where it says [b]some_user[/b] is changed to your actuall mysql username and [b]some_host[/b] is changed to [b]localhost[/b]. Then type in your actual password where it says [b]mypass[/b]That should sort out your problem. If it doesn't then there isn't anything else you can do AFAIK. In order for this problem to be sorted out you will need to get in contact with your host to sort the problem out.What I find strange is that you can use phpMyAdmin but you cant use IPB! Quote Link to comment https://forums.phpfreaks.com/topic/9990-help-with-php-and-ib-forums/#findComment-37171 Share on other sites More sharing options...
fhripper Posted May 19, 2006 Author Share Posted May 19, 2006 [!--quoteo(post=375237:date=May 20 2006, 12:47 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ May 20 2006, 12:47 AM) [snapback]375237[/snapback][/div][div class=\'quotemain\'][!--quotec--]You should use this query:[code]SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');[/code]Make sure that you change where it says [b]some_user[/b] is changed to your actuall mysql username and [b]some_host[/b] is changed to [b]localhost[/b]. Then type in your actual password where it says [b]mypass[/b]That should sort out your problem. If it doesn't then there isn't anything else you can do AFAIK. In order for this problem to be sorted out you will need to get in contact with your host to sort the problem out.What I find strange is that you can use phpMyAdmin but you cant use IPB![/quote]I have done this and it tlls me to reload privages.do i have to login to complete this.. (login into mysql)is there a command i need to login with Quote Link to comment https://forums.phpfreaks.com/topic/9990-help-with-php-and-ib-forums/#findComment-37284 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.