Date: Tue, 20 May 2003 23:35:17 -0500 From: "Philip M. Gollucci" <philip@p6m7g8.com> To: Gary D Kline <kline@thought.org> Cc: questions@FreeBSD.org Subject: Re: mysql-4.1.0? Message-ID: <200305202335.17901.philip@p6m7g8.com> In-Reply-To: <20030521032950.GA29147@tao.thought.org> References: <E19IJoI-0003MD-00@host02.ipowerweb.com> <20030521032950.GA29147@tao.thought.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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@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. -- END ------------------------------------------------------------------------------ Philip M. Gollucci Consultant E-Mail: philip@p6m7g8.com URL : http://p6m7g8.net/Resume/resume.shtml Phone : 301.474.9598 eJournalPress DBA / Software Engineer / System Administrator E-Mail: pgollucci@ejournalpress.com URL : http://www.ejournalpress.com Phone : 301.530.6375 $Id: .signature,v 1.4 2003/05/02 23:46:37 philip Exp $
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200305202335.17901.philip>