MySql error #:2000

MySQL
2009-12-22
2013-06-05
  • Mafaz Mazeen

    Mafaz Mazeen - 2009-12-22

    After successful installation OrangeHRM on XAMPP could not connect to the application through the local host (http://localhost/orangehrm-2.5.0.1/). Get the following error:
    Error

    NO database Connection found

    Technical Details
    mysqlnd cannot connect to MySQL 4.1+ using old authentication MySQL Error # :2000

    System Environment

    * OrangeHRM : 2.5.0.1
    * PHP : 5.3.0
    * MySQL Client : mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
    * Memory limit : 128M
    * Maximum session lifetime : 1440

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2009-12-28

    Hi

    Check whether mysql server is up and running.
    open Conf.php located in OrangeHRM/lib/conf directory.

    check the following is correct.

    $this->dbuser = '';

    $this->dbpass = '';

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2009-12-28

    Yes, mysql server is up and running.
    User exist with the right password.
    I can successfully connect with these user name and password through the command line to hr_mysql db.

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2009-12-30

    I have exactly the same issue. Have installed through the web installer.
    I can also connect to MySql using the command line with the user/password located in the Conf.php file.

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2010-01-07

    I met this issue and fixed

    login to your mysql panel, using root and click # Privileges tab, on the opened page, select user "orangehrm" and edit it.

    set up new password as what you had assigned to "orangehrm" when you install the hrm.

    Thanks
    Rosso

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2010-03-17

    i did i changed the password to what i added when installing hrm
    but didn't work for me what should i do i am still getting the same error message

    I am using ubuntu 9.10 with xampp as my amp server

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2010-03-17

    i fixed it in a really strange way i didn't use phpmyadmin to change the password i used mysql administaor to connect to 127.0.0.1 on port 3306 with root user and it worked
    Strange really Strange

     
  • Mafaz Mazeen

    Mafaz Mazeen - 2010-03-18

    The reason behind this is due to the old authentication scheme used by orangeHRM, which encodes the orangehrm account password to be 16 characters only. The fix is simple, login to phpAdmin web page, go to the mysql database, and click on the SQL tab.

    1. Run the following querry to find out what are those accounts with password being created with old hash algorithm
    SELECT `User`, `Host`, Length(`Password`) FROM mysql.user

    length of 0 means no password set
    length of 16 means old hash algorithm used
    length of 41 means new hash algorithm used

    2. Execute the following querry to update the orangehrm account to use the new hash algorithm
    SET PASSWORD FOR 'User'@'Host'=PASSWORD('yourpassword');
    FLUSH Privileges

    Hope it could bring some help.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-02

    Hooray, it worked.

    nimgnay, thank you very much.

    I was struggling all this time but finally you solved my problem. Thanks again.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-02

    i did i changed the password to what i added when installing hrm but didn't work for me what should i do i am still getting the same error messageI am using ubuntu 9.10 with xampp as my amp server.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-02

    Run this query in phpMyAdmin:
    REPAIR TABLE thread;
    If you still have this problem them you'll need to convert this table type from ISAM to MyISAM. Again you use phpMyAdmin to do this.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-04

    I have exactly the same issue. Have installed through the web installer.
    I can also connect to MySql using the command line with the user/password located in the Conf.php file.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-10

    I have exactly the same issue. Have installed through the web installer.
    I can also connect to MySql using the command line with the user/password located in the Conf.php file.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-16

    I can't successfully connect with these user name and password through the command line to hr_mysql db.

     
  • Arnold De Souza

    Arnold De Souza - 2010-08-19

    When I try to connect with php on my sql server 2005 I had this error " Warning: mssql_connect() : Unable to connect to server: localhost in C:\Inetpub\wwwroot… " but with phpinfo() I see that mssql module is ok. When I use the newest ntwdblib.dll php can't use mssql and I don't find the mssql module in the messages of phpinfo()… and the is the error is " Fatal error: Call to undefined function mssql_connect()… ".
    Can you help me?

     
  • Arnold De Souza

    Arnold De Souza - 2010-09-14

    I have following problem, please could someone help me - many thanks in advance!

    here my description:

    Machine: 550 MHz pentium III
    RAM: 196 MByte
    OS: Windows 2000 SP4 German, latest patches

    In "MySQL Server Instance configuration Wizard 1.0.15.0" it hangs at "start service" with
    error box

    Error adding firewall exception
    The error was:
    Ungültige Klassenzeichenfolge
    Error Code $00800401F3
    The installer must have been run with administrative privileges

    I try to translate "Ungültige Klassenzeichenfolge" to english:
    "Invalid class string" or "Invalid class character"

    I'm running it in admin/root account

     
  • Arnold De Souza

    Arnold De Souza - 2010-09-15

    Yes, mysql server is up and running.User exist with the right password.
    I can successfully connect with these user name and password through the command line to hr_mysql db.

     
  • Arnold De Souza

    Arnold De Souza - 2010-10-15

    After successful installation OrangeHRM on WAMP could not connect to the application through the local host (http://localhost/orangehrm-2.6.0.1/). Get the following error:
    Error

    NO database Connection found

    Technical Details
    mysqlnd cannot connect to MySQL 4.1+ using old authentication MySQL Error # :2000

    System Environment

    * OrangeHRM : 2.6.0.1
    * PHP : 5.3.0
    * MySQL Client : mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
    * Memory limit : 128M
    * Maximum session lifetime : 1440

     
  • Arnold De Souza

    Arnold De Souza - 2010-11-08

    I ALSO have following problem, please could someone help me - many thanks in advance!

    here my description:

    Machine: 1 GAGA pentium III

     
  • Arnold De Souza

    Arnold De Souza - 2010-11-08

    I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this:

    Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.

     
  • Arnold De Souza

    Arnold De Souza - 2010-11-30

    I am using windows7 and MYSQL 4.1. While attempting to open the MySQL.exe file through CMD prompt I am getting error message as "error 1045 access denied for 'ODBC'@'localhost'.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks