Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How to create a database in MySQL for dummies. Please, help


zzgrid

Recommended Posts

Posted

To run the installation script of oscommerce is necesary to have a database in blank and a user of the database with a password. How can i do this?.

 

I am using Mandrake 9.0. I have installed, (and running), Apache with PHP and MySQL. I think i have installed phpMyAdmin but not running. How can i start it and how i can use it? or how can i create the database without phpMyAdmin?.

Posted

come on guys I know this is an easy one for you..

 

Please I really need to know the answer myself

 

When trying to install OSC i recieve this error: "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

 

I thinks it a pretty easy mysql fix. but i am new to all of this.

 

Thanks in advance

Posted

I have MySQL installed... could someone please walk me through the steps to creat a data base and assign a user id and password?

 

this forum is the best!

Posted

A friend help me yesterday about this problem. If the database is database1, the user user1, and his password puser1 you can do this since the prompt of mysql: (to start the prompt of mysql since the promt of linux, only type mysql)

 

mysql> CREATE DATABASE database1;

mysql> GRANT ALL PRIVILEGES ON database1.* TO user1@localhost IDENTIFIED BY ?puser1? WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON database1.* TO user1@"%" IDENTIFIED BY ?puser1? WITH GRANT OPTION;

mysql>quit;

 

This is not in the guide of oscommerce installation and i think is a wall for all people dont know mysql. From my newbie view point i think is needed some more information in the guide about LAMP, (Linux + Apache + MySQL + PHP), installation.

Posted

ok.. I am doing something wrong.

I can't even get mysql to run. I am getting the "tmp/mysql.sock" error. I check in my /tmp dir and the file isn't there. So i reinstall and still nothing! So then I redownloaded the tarball and tried again.. and still nothing.. I have to be doing something wrong here

 

:(

Archived

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

×
×
  • Create New...