Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: christian m. isidro on June 06, 2002, 01:20:19 PM

Title: mysql
Post by: christian m. isidro on June 06, 2002, 01:20:19 PM

hello everyone,,,


   can someone please help me ,,,,i want to install a shopping cart that needs the mysql database,,,how can use the mysql database since i dont know the password,,,anyone there knows....

thanks


christian m. isidro

Title: Re: mysql
Post by: darren on June 06, 2002, 01:48:01 PM

what you need to do is create a user for the database to use

run mysql from command prompt on the e-smith server

by

mysql mysql

GRANT ALL PRIVILEGES ON *.* TO "Username" IDENTIFIED BY 'apassword' WITH GRANT OPTION;

then

INSERT INTO db VALUES('localhost' , 'Databasename', 'Username', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y')


flush privileges;
flush tables;

then thats it you have just created a new database user

to make life easier create a user for personal use where the localhost put your win machine's ip address
then download and install mysqlfront a very easy prog for mysql

www.mysqlfront.de

this prog allows you to create new users among other things
any questions just ask

Title: Re: mysql
Post by: james douglas on June 06, 2002, 07:12:43 PM

if youre looking for the ecommerce software check www.oscommerce.com, search for oscommerce here for the howto.

Title: Re: mysql
Post by: christian m. isidro on June 07, 2002, 05:52:14 AM

thank you so muchdarren wrote:
>
> what you need to do is create a user for the database to use
>
> run mysql from command prompt on the e-smith server
>
> by
>
> mysql mysql
>
> GRANT ALL PRIVILEGES ON *.* TO "Username" IDENTIFIED BY
> 'apassword' WITH GRANT OPTION;
>
> then
>
> INSERT INTO db VALUES('localhost' , 'Databasename',
> 'Username', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y')
>
>
> flush privileges;
> flush tables;
>
> then thats it you have just created a new database user
>
> to make life easier create a user for personal use where the
> localhost put your win machine's ip address
> then download and install mysqlfront a very easy prog for mysql
>
> www.mysqlfront.de
>
> this prog allows you to create new users among other things
> any questions just ask

Title: Re: mysql
Post by: christian m. isidro on June 07, 2002, 05:53:15 AM

thanks a lot buddy


chris

chris@redwood.com.ph
philippinesjames douglas wrote:
>
> if youre looking for the ecommerce software check
> www.oscommerce.com, search for oscommerce here for the howto.