Re: [cobalt-users] newbie postgresql

["PageKeeper Service" <host@xxxxxxxxxxxxxxxxxxxxx>]

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