Error Mysql Connect (4.0)

Author Message

Julien Plesniak

Friday 23 November 2007 3:04:17 am

Hello,

i try to install ezpublish-4.0.0beta1 on my php 5 server.

I upload my files and i have created my database. When i launch the setup, i choose the language and i write my database connection settings.

The setup show me this error:
The selected user has not got access to any databases. Change user or create a database for the user.

But if i access with phpmyadmin (with the same user), i see my database.

I have also tried with root user , it doesn't work.

Whats the problem?

Thanks for help and sorry for my bad english

Tomas Engström

Tuesday 04 December 2007 3:16:16 am

Hey m8

i got the same problems...

ran the installation and it stopped when i filled out the information for the database connection...

i am currently running PHP Version 4.4.7 and mysql 5.0 on my home computer

i gave the installation the root access, but no result and i created a new database for root and granted full access

i created a new user for the database server (global) and with full access and gave the installation the connection information, but it keeps saying:

"The database would not accept the connection, please review your settings and try again. "

so i figured maybe the windows firewall is blocking so i gave it tcp access (manually), but no result...

so here i am ;) anyone got any tips?

or maybe someone can tell me which file i can hack so i can do a work-around in the .php file myself.....

Gaetano Giunta

Tuesday 04 December 2007 12:29:47 pm

Most likely format of mysql user password is wrong.

Mysql changed tha hash function it uses to store internally passwords. PHP 4 connect function uses the old hash metod. Look for old_password in mysql docs or php.net

Principal Consultant International Business
Member of the Community Project Board

Julien Plesniak

Thursday 06 December 2007 12:27:32 am

Hello,

i have try this and its working :

<?php
$link = mysql_connect("localhost", "USER", "PASSWORD")
or die("Impossible de se connecter : " . mysql_error());
echo 'my connection worked';
mysql_close($link);
?>

Julien Plesniak

Thursday 06 December 2007 12:40:06 am

but not ezpublish

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.