zzgrid Posted February 11, 2003 Posted February 11, 2003 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?.
itbejared Posted February 13, 2003 Posted February 13, 2003 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
itbejared Posted February 13, 2003 Posted February 13, 2003 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!
zzgrid Posted February 13, 2003 Author Posted February 13, 2003 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.
itbejared Posted February 14, 2003 Posted February 14, 2003 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 :(
Recommended Posts
Archived
This topic is now archived and is closed to further replies.