Access denied for user 'ODBC'@'localhost ...

[Subl!me]

I have a problem, wich does not seem to be a new problem because I've seen it many times on this forum, but any of the solutions is working for me.

 

I have an error at step 3 of the installation:

Access denied for user 'ODBC'@'localhost' (using password: NO)

 

screenshot

 

(I don't understand why it is written 'ODBC' because I am not trying to log in with a user called 'ODBC')

 

I modified my php.ini and added:

[Performance]

register_long_arrays = ON

 

My 2 configure.php files are the same and look like this:

 

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'root');

define('DB_SERVER_PASSWORD', 'mypassword');

define('DB_DATABASE', 'osCommerce');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

 

I have a user named 'root' with 'myPassword' as the password (wich is not the real password :)).

 

I created a database called 'osCommerce' and gave all the rights to the root user...

 

I tried everything I read but nothing is working.

I'm using mySQL 4.1, php 4.4.0, IIS 6, everything is on my computer.

I am new to all this server stuff so I probably installed something the wrong way or set something the wrong way...

 

Do you have any suggestion?

Thanks for your help!

[♥Vger]

using password: NO

 

with 'myPassword' as the password

 

Make sure that you do have a password set for MySQL access in my.ini

 

By the way, the image links returns a 403 (forbidden) error code.

 

Vger

[Subl!me]

I don't have any line for a password in my.ini

Can you tell what I need to add about the password?

 

This is my my.ini and I made any changes in it: (except remove the comments)

 

[client]

port=3306

 

[mysqld]

port=3306

basedir="C:/Program Files/MySQL/MySQL Server 4.1/"

datadir="C:/Program Files/MySQL/MySQL Server 4.1/Data/"

default-character-set=latin1

default-storage-engine=INNODB

max_connections=100

query_cache_size=0

table_cache=256

tmp_table_size=5M

thread_cache_size=8

myisam_max_sort_file_size=100G

myisam_max_extra_sort_file_size=100G

myisam_sort_buffer_size=8M

key_buffer_size=8M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=212K

#skip-innodb

innodb_additional_mem_pool_size=2M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1M

innodb_buffer_pool_size=8M

innodb_log_file_size=10M

innodb_thread_concurrency=8

 

This is the link of the screenshot, it's working for me (and my friend..)

http://leszamis.net/screenshot.jpg try to copy paste it!

 

Thank you for your reply!

[♥Vger]

The reason I mentioned password was because you said you were using your password, when the error said no password was being used.

 

The only thing I can say about the user being listed as ODBC is that this is the name of a Microsoft data driver. I'm not going to be able to help you any more I'm afraid - not a fan of Windows servers and always use Apache.

 

Vger