RE: [cobalt-users] newbie postgresql

["Jason Humphrey" <Jasonh@xxxxxxxxxxxx>]

Sorry to be a pain but at the command prompt i get a message saying that
"bash: create: command not found"

I'm guessing i'm typing something wrong can you explain in a little more
detail.
Thank You :)

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of PageKeeper
Service
Sent: 13 January 2004 15:55
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-users] newbie postgresql


Subject: [cobalt-users] newbie postgresql


> Hi,
> I'm trying to run a php web content manager called "mambo". When I'm
> installing it tells me that my server (a raq4) supports sql and there is
no
> problems. The next step asks for a mysql username and password and the
> database name.
>
> So.. I need to create a database with a username and password. I ssh in as
> admin then su -. im using the command line "createdb mambodbbws -u
> jhumphrey"
> I believe this Should create a database called mambodbbws with a user
> jhumphrey.
>
> I get this error message
> "psql: No pg_hba.conf entry for host localhost, user admin, database
> template1"
>
> I have tried su postgresql but it asks for a password and I don't know
what
> it is because I guess cobalt sets a standard one.
>
> Is this the right way to create a database? and then how do I set a
password
> for the username?
>
> Thanks Jason

 mysql -u root -p
ENTER ROOT PASSWORD

create database DATABASE_NAME;
grant select, insert, update, delete, create, drop, alter, index on
DATABASE_NAME.* to USER_NAME@localhost identified by 'PASSWORD';

The above is one line
\q to quit

  David Hahn
  PageKeeper Service
  http://www.pagekeeperservice.com


_____________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users