Re: MySQL and PostgreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux