SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Member
    Join Date
    Apr 2003
    Location
    Berkshire, UK
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySql Instalation Problems

    I have just installed MySql 4.1 and PHP 3.0.

    Using the command

    $dbcnx = mysql_connect('localhost', 'root', '******');

    I get an error

    "Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\memreehome2.php on line 9"

    What am I doing wrong?

    All help gratefully received !!

  2. #2
    SitePoint Zealot
    Join Date
    Jan 2005
    Location
    Australia
    Posts
    197
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That causes mySQL latest version problem because of the different password authentications.

    use mysql;
    set password for user@some_host=old_password('yourpass');
    flush privileges;

    user is the username
    some_host is the host
    yourpass is the password
    Tribolis.com Affordable Web Hosting Solutions since 2004
    Comes with Fantastico Auto Installer & Daily Backup!
    WeLoveCSS.com XHTML & CSS Forum for everyone

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2005
    Location
    Australia
    Posts
    197
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you're not sure where to start first. You'll need to login your mySQL; below:

    mysql -u root -p
    Tribolis.com Affordable Web Hosting Solutions since 2004
    Comes with Fantastico Auto Installer & Daily Backup!
    WeLoveCSS.com XHTML & CSS Forum for everyone

  4. #4
    SitePoint Member
    Join Date
    Apr 2003
    Location
    Berkshire, UK
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've given up and uninstalled PHP & MySql. I have now downloaded MySql 4.1.8 and PHP 5.0.3. Having gone through the installation procedures outlined in "BYO Database Driven Website" (3rd ed), when I try to restart the WWW Publishing service I get a message "PHP Startup: Unable to load dynamic library 'c:\php\ext\php_mysql.dll' - The specified module could not be found." The path is correct and the file is in that location.

    Where am I going wrong. This is driving me NUTS!

    Thanks in anticipation . . . . .

  5. #5
    SitePoint Member
    Join Date
    Apr 2003
    Location
    Berkshire, UK
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    CRACKED IT!!! Had to change the path variable in Control Panel/System to include the PHP and ext directories!

    Now to get some code working!

    Thanks for your help. Stay close to your pc!

    Colin

  6. #6
    SitePoint Zealot
    Join Date
    Jan 2005
    Location
    Australia
    Posts
    197
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh okay, your welcome!
    Tribolis.com Affordable Web Hosting Solutions since 2004
    Comes with Fantastico Auto Installer & Daily Backup!
    WeLoveCSS.com XHTML & CSS Forum for everyone


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •