[Refdb-users] skip_networking...

[Markus H. <hoe...@co...>]

Hi Juan,

Juan de la Figuera writes:
 > From the my.conf with mysql-server  3.23.47-2 (debian/unstable i386) and also 
 > with ppc:
 > # The skip-networkin option will no longer be set via debconf menu.
 > # You have to manually change it if you want networking i.e. the server
 > # listening on port 3306. The default is "disable" - for security reasons.
 > 

Good to know. Thanks.

 > Also, what are the default passwords set by refdba adduser?

This is a good question. I was reworking the adduser stuff just
yesterday, mainly to switch to the GRANT/REVOKE syntax that newer
MySQL versions support. I was surprised to see that refdba sets a
default password at all (I thought no password was the
default). Anyway, the default password is "refdb" (who would've
thought). I think about adding an option to set the password for a new
user with the adduser command.

I also found a glitch with the default privileges for the refdbvar
database. This one is only used when creating SGML databases, so many
people may not have noticed this. Users need also CREATE and DROP
privileges in addition to SELECT, INSERT, DELETE, UPDATE. This is easy
to fix in refdbda.c or by running a GRANT command in the mysql client.

regards,
Markus

-- 
Markus Hoenicka
hoe...@co...
http://ourworld.compuserve.com/homepages/hoenicka_markus/