installing and get access denied

[Guest]

moving site to new server and on install page i put in user name mysql and password. when i hit next i get access denied for username. My [email protected]

I had this problem once before and do not remember how to fix it.

Please help

Thank you,

Kirk

[mattice]

the username, database and password are defined in catalog/includes/configure.php... set the correct ones there.

 

hth

mattice

[Guest]

Sorry I did not elaborate as I had someone else typing for me as I was in the car driving, and doing so over the phone.

 

I know about the configure.php but The problem is more or less with linux I guess. I can use install.php when setting things up which should be about the same as adding the info to config.php. but on install.php I enter user and pass and catalog for database and so on, then when I hit next it basically says that the username and pass were not authenticated and that I should hit the back button and look at the information agian.

 

I have tried using user mysql, and I have also tried adding a new user and then adding the new user to every group in the list and niether will get authenticated. Is there something simillar to win2k were you can go into local security policy and change setting for users, groups and so forth? like to make it to were they can log in localy but not on a network.

 

I had this problem the first time I installed os commerce and I can't remember what I did to fix it,

 

I know it has just got to be a setting on my part somewhere.

 

Thanks, I am going to search the forums some more.

[mattice]

you will need the actual login / pass for mySQL. If you have the root mysql user you can make a special account for the osCommerce site. Your mysql user can be restricted on lots of things, you tell if it's allowed to connect only from localhost etc.

 

There is a difference between a mysql user and a 'regular' user (one that can telnet, check mail etc).

 

HTH

Mattice

[agadak]

Are you running the install from the local machine? Are you doing it from the local network?

 

If this is a new database, you may need to give the username added rights in the actual database:

 

Login to the machine and do: (or ask the guy who sets these up)

mysql -uroot -p catalog

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Welcome to the MySQL monitor. Commands end with ; or g.

Your MySQL connection id is 465 to server version: 3.23.41

 

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

DO:

mysql>grant select, update, insert, delete on catalog to username@localhost id identified by 'password';

 

Query OK, 0 rows affected (0.03 sec)

 

IF THAT STILL DOESN'T WORK, GIVE THE MACHINE YOU ARE ON RIGHTS OR IF YOU ARE LESS RELAXED, THE WHOLE DOMAIN RIGHTS TO ACCESS THE DATABASE W/ THE USER RIGHTS:

 

mysql>grant select, update, insert, delete on catalog to username@*.domainname.com id identified by 'password';

[Guest]

Ok well it is my machine and I just did a fresh install of redhat 7.3 and mysql php and so on. So during the install of corse I make the root lofin and then created myself a login and that is all that was done, so there is a default user called mysql and I thought that I would just be able to use that, but i CANT EVEN USE MY ROOT USER AND PASS so I assume that there is something security wise saying that I can only log on locally. and as a matter of fact if it makes any differense I am setting everything up using the machine itself instead of over the network from my workstation, I just brought the server home for the weekend.

 

I will try this and see what happens though. as I said Last time I had the problem I thought it was something simple. I think I would have remembered if I had to do all of that.

 

anyways, Thanks for the replies

[Guest]

Actually now that I think about it,,, I had to add the mysql group to the domain access or something.

 

Linux, What a whole nother world! its fun though

[agadak]

I'm not sure about this, but I think RedHat no longer ships mySQL with a blank password and if you changed it then maybe that is not the problem. Save yourself the headache and create a new user and give him rights, then you will know for sure.