On Thursday 15 June 2006 11:40, Karl Larsen wrote: > Both of these software DB packages on FC4 do not work because of > permissions problems. MySQL info has a lot to say about permission > problems but nothing to say about the problem I was having. PostgreSQL > has nothing but a long criptic man page. > > It's clear that these software which I have used in past years have > matured to a level I cannot understand any more. I am going to just > forget a DB and do it another way. I have wasted 3 days. > > Karl Karl, sorry if it sounds harsh but I would rather say "both of these software DB packages on FC do not work because you do not know what you have to configure". I maintain several DB servers running both mysql and pgsql - without any issues. If you really expect help then you should ask a direct question rather than slam the work contirubuted by the people on this and other lists. No one here is obligated to help you - people do because they are nice and try to help out. The basic procedure in mysql is: 1) create DB with "mysqladmin create <dbname>" 2) grant user privileges by typing "mysql mysql" and then executing the command: grant all privileges on <dbname>.* to 'username'@'%' identified by 'password' The % is the wildcard for all remote hosts. If you want to configure local connections use 'localhost' instead of '%' 3) exit mysql and then run "mysqladmin reload" to tell the engine to reload its cached permissions data. In Postgres you do 1) To create a postgres db you login in as user postgres. Then run 'psql template1' . then type "create database <dbname>;" 2) exit the psql and run "psql <dbname>" Then execute "CREATE USER <username> WITH PASSWORD '<password>';" 3) if you want password auth rather than ident you'll have to add a line to ~postgres/data/pg_hba.conf host <dbname> all 127.0.0.1/32 password 4) For that change to take effect you run pg_ctl reload That should allow you to do whatever you need - if it doesn't post error messages, error codes or anything else that may help people to track things down rather than just throwing it into their face how stuff does't work and how we jsut waste your time... Peter.
