New installation (database initialization)

Monday 09 January 2006 2:27:21 pm

I got the following error when I entered:
Servername:
Username:
Password:

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

I install on lunix/ and using MySQL database.

Please advice if you have any better way of new installation or know what's going on here. I know that my servername, username, password and database's information are correct. The only question I have is that this script was not promted for databasename at this stage.

Please help.

eric

Wednesday 11 January 2006 11:37:29 am

Where is the socket file?

Wednesday 11 January 2006 2:16:17 pm

Eric,

The problem is probably that you (or the host you're using) are using MySQL 4.1.x or newer without compiling the related MySQL library for PHP. In short, this means PHP can't connect to MySQL 4.1 and up because those versions use a new authentication protocol.

If you are in control of the database server, please have a look at my first reply (2nd post) in this thread:
http://ez.no/community/forum/install_configuration/kernel_50_on_solaris_mysql_4_1_7_ez_3_4_3

Hans
http://blog.hansmelis.be

Wednesday 11 January 2006 3:17:32 pm

I tried to run:

USE mysql; UPDATE user SET Password = PASSWORD('<your password>') WHERE User = '<your username>';

and access denied. I guess, there is no other way huh? I like ez publish but I guess I have to find other script. How come ez publish does not promt for database name when install.

Thanks anyway.

eric

Wednesday 11 January 2006 11:54:57 pm

Hi!

Ofcource you need proper access to do necessary changes to contact to admin.

For mysql try this
USE mysql;
SET PASSWORD FOR [email protected] = OLD_PASSWORD('Your Password');