Setting Up DAtabase

[mildurashacknet]

I have set this up before along time ago but now I am trying again I am getting nowhere creating a database in phpmyadmin and using it to create my oscommerce.

 

Pre-Installation Configuration

 

* Username/password and database

If you use a hosting service to set up your webspace, they will likely have provided a username and login for database access, which you will need. They may have also created a database already for you to use with the username and login provided. Otherwise, using phpMyAdmin or another tool, create your database and user, and assign that user to the database. Write down the name of the database, login, and password for this database for later. Also note the hostname of the server (i.e. myserver.com) for later use.

 

What I am typing in is not working and I am getting

 

 

 

New Installation

 

Database Import

 

A test connection made to the database was NOT successful.

 

The error message returned is:

 

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

 

Please click on the Back button below to review your database server settings.

 

If you require help with your database server settings, please consult your hosting company.

 

I do remember it took me along time to get past this stage last time and I am fine beyond this point if someone can help me set up the database with correct entries.

 

Mike

[mildurashacknet]

Additional information, I used phpmyadmin to set up database as follows;

 

phpMyAdmin 2.8.2-Debian-0.2 setup

Configure server

 

Editing server mildurashop (config:root) [1]

Server hostname LOCALHOST

Server port

Server socket

Connection type TCP

PHP extension to use MYSQLI

Compress connection YES

Authentication type CONFIG

User for config auth ROOT

Password for config auth *******

Only database to show MILDURASHOP

Verbose name of this server MILDURASHOP

phpMyAdmin control user ROOT

phpMyAdmin control user password *********

phpMyAdmin database for advanced features MILDURASHOP

 

 

 

In oscommerce I am having trouble entering the correct info into;

 

Please enter the database server information:

Database Server: LOCALHOST

Username:

Password: ******

Database Name:

Persistent Connections:

Enable persistent database connections.

Session Storage: Files Database

[Guest]

When running install: the first it correct:Localhost. The database name could be split names. I create dbase rc1 so my dbase mane is jesphoto_rc1.

The password for your dbase should be the password you use to create dbase.Username and dbase name should be the some.

[mildurashacknet]

Thanks, I have played with it and I am still getting access denied.

I think I will have to get someone to log in to the server and do a set up for me so I can get on with setting up the shop.

Anyone want to give it a go.

 

 

 

 

When running install: the first it correct:Localhost. The database name could be split names. I create dbase rc1 so my dbase mane is jesphoto_rc1.

The password for your dbase should be the password you use to create dbase.Username and dbase name should be the some.

[mildurashacknet]

Ok guys, I solved the problem by ignoring mysqladmin and did the following.

First I tryed a page to change the password and this did not work. I worked out the this was because a password had already been created & I did not know what it was.

So I deleted mysql with the following;

 

sudo apt-get remove mysql-server

 

Then Re-installed with;

 

sudo apt-get install mysql-server

 

Then followed this page to the letter;

http://ubuntu.flowconsult.at/en/mysql-set-...-root-password/

 

Then set up oscommerce with the settings from mysql and the working password.

 

All is well.