mysql-4.1.0?

[Philip M. Gollucci]

I just did this yesterday
4.1 gives me my subselects !!!!! whowhoooo!

su
cvsup -g -L2 /usr/share/examples/cvsup/ports-supfile
cd /usr/ports/databases/mysql4.1-server
make install distclean
rehash
mysqld_safe &
mysqladmin -u root password 'this_is_the_password'
mysql -u root --password='this_is_the_password''
mysql>

FYI: mysql 5.0 compiles on FreeBSD aswell depending on your compile options.

On Tuesday 20 May 2003 10:29 pm, Gary D Kline wrote:
> On Tue, May 20, 2003 at 07:58:34PM -0700, Aaron Peterson wrote:
> > > 	Hi,
> > >
> > > 	Can anyone give me the magic incantation to get mysql4
> > > 	running and howto set up the admin acct?
> > >
> > > 	I am trying to get phpbbs running on my domain and test
> > > 	several other BBS and message-board apps that require an
> > > 	SQL database.  For the time being I'm wedged, so any
> > > 	help or pointers to tutorials would be very welcome.
> > >
> > > 	tia, y'all,
> >
> > ---
> >
> > install mysql-server from ports or pkg, whatever your choice.  after
> > installation execute "/usr/local/bin/mysql_install_db &&
> > /usr/local/etc/rc.d/mysql-server.sh start"
> >
> > after that, you can set the root password with
> > "/usr/local/bin/mysqladmin -u root password 'newrootpassword'"
> >
> > to enter the sql shell and talk to the database interactively, you can
> > then use "/usr/local/bin/mysql -u root -p" after which it will ask for a
> > password and drop you at a mysql shell console prompt.  to create a new
> > database there you might try "create database phpbb" after which you can
> > create a user with permissions only to that database from localmachine
> > with "grant all on phpbb.* to phpbb_user at localhost identified by
> > 'phpbbpassword';"
> >
> > then when you configure phpbb, you would use database name "phpbb"
> > username "phpbb_user" and password "phpbbpassword".  mysql operates on
> > port 3306 by default and the server name would be "localhost"
> >
> > hope that helps.  you should really buy a book on mysql or visit the
> > docs on the mysql.com site if you use it any more than i just described.
>
> 	I looked for some kin d of installation script; found none.
> 	Maybe trying v4 was too ambitious; I'll try an earlier
> 	version.  Here's what happened with the -alpha port:
>
> root at sage:/etc# /usr/local/bin/mysql_install_db
> /usr/local/bin/mysql_install_db: Command not found.
>
>
> 	thanks,
>
> 	gary
>
> 	PS:   I have been digging into the www.mysql.com site.  It
> 	      should help later on.  -gdk.

-- 
END 
------------------------------------------------------------------------------ 
Philip M. Gollucci
Consultant
E-Mail: philip at p6m7g8.com 
URL   : http://p6m7g8.net/Resume/resume.shtml
Phone : 301.474.9598

eJournalPress 
DBA / Software Engineer / System Administrator 
E-Mail: pgollucci at ejournalpress.com
URL   : http://www.ejournalpress.com 
Phone : 301.530.6375

$Id: .signature,v 1.4 2003/05/02 23:46:37 philip Exp $