Date: Tue, 20 May 2003 20:29:50 -0700 From: Gary D Kline <kline@thought.org> To: Aaron Peterson <aaron@alpete.com> Cc: FreeBSD Mailing List <freebsd-questions@FreeBSD.ORG> Subject: Re: mysql-4.1.0? Message-ID: <20030521032950.GA29147@tao.thought.org> In-Reply-To: <E19IJoI-0003MD-00@host02.ipowerweb.com> References: <E19IJoI-0003MD-00@host02.ipowerweb.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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@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. -- Gary Kline kline@thought.org www.thought.org Public service Unix
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030521032950.GA29147>