Re: MySQL 4.1+ Password Incompatibility



Shawn Iwinski (siwinski) wrote:

I'm having trouble getting DBI connect to a MySQL 4.1+ server.  I have
to use MySQL's OLD_PASSWORD to set the password on the server in order

This isn't a DBI issue, the problem is that the passwords in your privilage tables (IE from 3.x or 4.0) are not compatible with MySQL 4.1's authentication protocol.

You're only two options are:
1) just use old_passwords (IE it has to be in ~/.my.cnf for CLI use = MySQL issue not Perl)
2) update your privileges to 4.1 auth schema
3) go back to 4.0 or whatever

You may find other options from the mysql folks :)

HTH :) Lee.M - JupiterHost.Net
.

Relevant Pages

  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: Using Access for web application?
    ... Any suggestions as to which newsgroup would be more ... The server that the web app will use in this case, ... > which technology you will decide to use as the Web server (Linux or Windows) ... Instead MySQL is being ...
    (microsoft.public.access.dataaccess.pages)
  • [UNIX] phpMyAdmin PHP Code Injection (left.php)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... phpMyAdmin is "web-based MySQL ... does not prevent a malicious user from altering the servers configuration ... server configurations to the list of servers configuration by adding ...
    (Securiteam)
  • Re: Using MySQL as the backend
    ... I need to learn MySQL, ... > the impression you're not familiar with the concept of a server DB. ... > doesn't need to have Access installed to access the database, ... >> install the server or maybe I have it installed but I just don't know how to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: mySQL and ASP, ASP.NET and FP server extension
    ... If you're hosted on a Windows server, you can use MS Access, which is free, ... >>> Indeed, I was not thinking mySQL before, because Windows-based platform ... >>> usually comes with MS SQL and ASP and so on. ...
    (microsoft.public.frontpage.programming)