ATutor

Learning Management Tools


  1. Home



Pages:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Unable to connect to database server



  • 2006-01-26 13:54:30

    Unable to connect to database server

    On step 2, I get the message "Unable to connect to database server"

    operating system -
    Window 2000 Server SP4

    version of ATutor -
    1.5.2

    versions of php -
    4.4.1

    version of mysq -
    4.1.16

    webserver & version -
    Apache 1.3.27

    copies of error messages -
    x Error
    Unable to connect to database server.

    changes to default settings -
    Using e:\ drive as opposed to default c:\

    web browser being used -
    Internet Explorer 6.0.2800.1106

    and anything else relevant -
    Using MySQL Administrator 1.1, have set up a designated user. Have also set up another designated user by cloning root. Have also used root.

    Have confirmed the correct password is being used.

    Regardless of user (set up, cloned from root, root itself), I get the message "Unable to connect to database server."

    Please advise


  • 2006-01-27 08:32:52

    Re: Unable to connect to database server

    This is almost always the result of using the wrong connection information.

    Make sure the mysql user has permission to create a database, and create tables.


  • 2006-01-27 08:46:53

    Re: Unable to connect to database server

    Are you telling me that "root" may not have those permissions?


  • 2006-01-27 09:04:00

    Re: Unable to connect to database server

    Root should be able to connect, but double check to make sure create permissions are set in the mysql table.

    You might also try creating the atutor database manually. then run the installer.

    Connecting to the database is not a problem reported very often. When it is, it is almost always the result of entering an incorrect password, or the mysql user not having create permissions.

    Are you able to install other similar applications that create a database and populate it with tables?


  • 2006-01-27 16:48:52

    Re: Unable to connect to database server

    root permissions appeared to be set correctly. no luck.

    tried with and without a blank 'atutor' database. no luck.

    since no other php app had been tried on this server (although I have installed other PHP/MySQL apps successfully on multiple other servers), I tried one ... and it failed.

    I completely removed MySQL and PHP, re-installed, and all is well.

    Apparently something was missed or corrupt during the installation of one or both. Removal/reinstallation did the trick.

    Sorry to disturb with a non-atutor problem. Thanks for the help.


  • 2006-02-19 09:56:33

    Re: Unable to connect to database server

    I receive the same error message. Maybe because I don't know how to set mysql users and giving them permissions (can't find it in WinMySQLAdmin). Or maybe because ATutor can't find out the mysql version? Any hints would be welcome!

    operating system -
    WinXP Pro
    version of ATutor -
    1.5.2
    versions of php -
    5.1.1
    version of mysq l -
    5.0.18 (ATutor reports Found Unknown Version)
    webserver & version -
    Apache 2.2.0 (inside Xampp on local machine)
    copies of error messages -
    Unable to connect to database server.
    changes to default settings -
    none
    web browser being used -
    Firefox 1.5.0.1
    and anything else relevant -


  • 2006-02-19 10:28:49

    Re: Unable to connect to database server

    Not finding the mysql version does not matter.

    Are you able to connect to the mysql database at the command prompt by typing "mysql"?

    If not your mysql installation may not be configured properly. See the mysql documentation for information about configuring mysql for Windows.

    If you have not already tried it, the EasyPHP bundle available through the ATutor downloads page, will install mysql and help you set it up.

    http://atutor.ca/atutor/download.php


  • 2006-04-06 11:36:18

    Re: Unable to connect to database server

    This is not an ATutor issue. It is related to MYSQL. I have encountered the same problem and here is a solution that worked for me.

    Run mysql and login as root:
    mysql -u root -p

    Then, paste the following command, editing as necessary, to change the password of the user to the old format.
    UPDATE mysql.user
    SET password=OLD_PASSWORD('somepassword')
    WHERE user='someuser'
    AND host='somehost';

    After you have set the passwords to the old format, flush the tables.
    flush privileges;

    Then exit the mysql client with "quit" and you are set.

    You can read about this issue at:

    http://www.digitalpeer.com/id/mysql

    http://dev.mysql.com/doc/refman/5.0/en/old-client.html

    Thanks.

    Fouad Ahmad