FreeBSD and MYSQL

[robbo007]

Hello all,

 

I am having a few problem getting my FreeBSD 5.1 system up to the level needed to install OSCommerce.

 

I have installed Apache Server 2 with PHP support. That is all running. I am trying to install MySQL but am having problems.

 

I have ran the install for:

 

mysql-client-4.0.17 Multithreaded SQL database (client)

mysql-server-4.0.17 Multithreaded SQL database (server)

 

From the ports collection. But when I run the Oscommerce from my web browser it can't create the database. I get this error:

 

error: 'Access denied for user: 'root@localhost' (Using password: YES)'

 

I was not asked for any password when I installed MySQL so I don't know where its getting the password from????

 

Any ideas??

 

Thanks,

 

Rob

[Guest]

with some of the items i have read, you would probably, not totally sure but probably want to use apache 1.3.29 or .27, mysql 3.23 or there abouts, and php 4.3.3 or higher.

 

you should not have to use the ports collection to create the database

if you have root access, do you know the root user password?

 

command is:

mysql -u root -p which will let you connect to the sql prompt, it will ask for a password

 

this will test to make sure you are in fact using the proper password

 

if so, then you can start using the mysqladmin command . .

 

i use freebsd and it works great.