[Serusers] Problem creating mysql database

[Klaus Darilion]

Hi!

> -----Original Message-----
> From: Nils Ohlmeier [mailto:nils at iptel.org] 
> Sent: Thursday, December 04, 2003 1:39 PM
> To: franz.edler at utanet.at; serusers at lists.iptel.org
> Subject: Re: [Serusers] Problem creating mysql database
> 
> 
> Hello,
> On Thursday 04 December 2003 11:13, Franz Edler wrote:
> > Hello,
...
> > MySQL server is running.
> > I called /usr/sbin/ser_mysql.sh.
     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

> > But the mySQL management tool command "SHOW DATABASES" 
> shows only two
> > databases mySQL and test, where I also expected ser.
> > When I issue the mySQL management tool command "SELECT * 
> FROM USER" I get
> > the error "ERROR 1046: No database selected"
> >
> > Has anyone an idea what I can do?
> > Is the problem caused by the ignored inconsistencies of
> > libmysqlclient.so.1x?
> 
> Sorry that i have to say: RTFM.
> It is no where mentioned that the installation of the rpm 
> also creates the 
> databases. That would IMHO often end in a real disaster.
> After you installed the rpm's you have to create the required 
> database with 
> the ser_mysql.sh script.

To me it looks like as Franz already started the script.

I also suggest compiling from source - never had any problems, and you
never have conflicts because of wrong library versions.

Klaus