Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How can I create the database in MySQL?!


Guest

Recommended Posts

Posted

How can I create the database in MySQL?!

 

 

# mysqladmin -u<root> -p<password> create <database_name>

 

<root> = Username

<password>=password

<database_name> = database Name

 

 

I tried. But not sucessful, why?

Posted

It show:

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

 

WHY?!

WHat's matter?!

Posted

Hi,

 

What are the priveledges of the user 'root' ?? Possibly that user does not have the db priv to create ??

 

Peter

Posted

When I don't input the password.

It is pass!

 

But It show "SQL file does not exist: /install/tchinese.sql"

 

why?!

 

How can I ?!

Posted

In /var/www/html/catalog/install

 

It has the tchinese.sql file.

 

Is it correct?!

 

 

WHy it say this not exist?!

Posted

Hi,

 

For this msg to appear:

 

"SQL file does not exist: /install/tchinese.sql"

 

then possibly you are not running the 'install' from the correct path ??

 

In /var/www/html/catalog/install

 

It has the tchinese.sql file.

 

From http://wiki.oscommerce.com/docsInstallNew

 

you would just need to point your web browser to:

 

/var/www/html/catalog/install

 

which no doubr would translate to:

 

http://localhost/catalog/install

 

Peter

Posted

If the "catalog" folder copy to /var/www

 

I can't go to the page!!!

 

It also be copy in /var/www/html

 

is it?

Posted
you would just need to point your web browser to:

 

/var/www/html/catalog/install

 

 

How to point?!

Posted
Help~ ???

What is your server you are using, Host server that is. And secondly what version of PHPMyAdmin are you using? Also make sure you have your permissions set correctly on the install/index.php page

Always remember, we need patience, guidance and most of all understanding.

 

My Contributions

Posted

I'm using RedHat 8.0 Linux Server

I don't use PHPmyAdmin software.

 

So I don't know how to do it.

Posted

My default web site path is "/var/www/html"

then the install oscommerce path is "/var/www/html/catalog/install"

 

Now it show "the SQL file does not exist: /install/tchinese.sql"

 

 

Then, Which path is correct!?

Posted

Hi,

 

How to point?!

 

Possibly you will get us to answer your questions better if you can please tell us:

 

1. Where you have the catalog installed ?

 

Is it /var/www/html/catalog , or /var/www/html ?

 

2. Where does http://localhost point to ?

 

Is it /var/www/html , or /var/www ?

 

3. Where is the 'install' path located ?

 

Is it /var/www/html/catalog/install or /var/www/html/install ?

 

Peter

Posted
1. Where you have the catalog installed ?

 

Ans: Inside "/var/www/html"

 

2. Where does http://localhost point to ?

 

Ans: /var/www/html

 

 

3. Where is the 'install' path located ?

 

Ans: Inside "/var/www/html/catalog"

Posted

I discover the "tchinese.sql" file is not the root user permission.

 

Is it need to change the owner of this file ?!

 

 

How to change ?!

 

 

Thanks~

Posted

I sucessfully change the file owner:

chown -c :root tchinese.sql

 

But still don't work!

 

It also display this error "SQL file does not exist: /install/tchinese.sql"

 

WHY????

 

:angry:

Posted

Hi Toni,

 

I notice you are 'bumping' this thread up sometimes with 'smilies'; you might want to read the forum rules:

 

http://www.oscommerce.com/forums/index.php?act=boardrules

 

Bumping

 

Bumping postings to the top of the forum channel listing, made to get more attention to the post, will not be tolerated.

 

When no one has replied to a posting you have made, it is recommended to reply in the same thread with more information that may help in resolving the issue.

 

Peter

Posted

OK~ Sorry~

 

But I want to quick to solve this problem!

 

Help me OK?!

 

Thanks~

Posted

Hi Toni,

 

Have you read this - http://wiki.oscommerce.com/docsInstallNew

 

to ensure that all your paths are defined correctly. It simply sounds like a path problem, because you do have the SQL file in the 'install' path, yet the installation must be looking somewhere else, because it gives the error msg.

 

edit: .. especially the 'Step 4' part.

 

Peter

Posted

I copy the "Install" folder to ./

 

It is sucessfully to install.

 

but in next page, it show:

 

Warning: fopen("/var/www/html\includes/configure.php", "w") - 沒有此一檔案或目錄 in /var/www/html/catalog/install/templates/pages/install_7.php on line 209

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 210

 

Warning: fclose(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 211

 

Warning: fopen("/var/www/html\admin/includes/configure.php", "w") - 沒有此一檔案或目錄 in /var/www/html/catalog/install/templates/pages/install_7.php on line 259

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 260

 

Warning: fclose(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 261

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...