markiemrboo Posted July 30, 2005 Posted July 30, 2005 Installing..... =)}{ 519544[/snapback] nice little stick man type thing there. Like it!!! Share this post Link to post Share on other sites More sharing options...
galla2k4eva Posted July 30, 2005 Posted July 30, 2005 (edited) or not..... x1-6-00-07-95-dd-01-ee# portinstall mysql41-server ** No such installed package or port: mysql41-server 0.o what now?? Edited July 30, 2005 by galla2k4eva Share this post Link to post Share on other sites More sharing options...
markiemrboo Posted July 30, 2005 Posted July 30, 2005 Try just `portinstall mysql-server` I think... Share this post Link to post Share on other sites More sharing options...
galla2k4eva Posted July 30, 2005 Posted July 30, 2005 yea it works... same name came up... Strange, is there any configuration to do? Share this post Link to post Share on other sites More sharing options...
markiemrboo Posted July 30, 2005 Posted July 30, 2005 yea it works...same name came up... Strange, is there any configuration to do? 519556[/snapback] EDIT: As for having to use mysql-server instead of mysql41-server... that might be portinstall trying to be clever removing version numbers from the port names. If you ask me, that just confuses me... I would much rather it be mysql41-server, mysql50-server or whatever You can do, but the default configuration is probly fine and I don't think there's a sample file to work from, sooo... you'd have to look that up in the documentation. Other than that I think it's just a case of adding MySQL users and creating databases / tables. I assume you know how to do that much from having it installed on Windows before..? Share this post Link to post Share on other sites More sharing options...
galla2k4eva Posted July 30, 2005 Posted July 30, 2005 I can do all the admin from Naviact one its up. Do I have to add it to the startup? Share this post Link to post Share on other sites More sharing options...
markiemrboo Posted July 30, 2005 Posted July 30, 2005 I can do all the admin from Naviact one its up. Do I have to add it to the startup? 519562[/snapback] Well of course, it's no different from any other server mysql_enable="YES" should be it. Have a look for the MySQL startup script in /usr/local/etc/rc.d to make sure if you want though. Share this post Link to post Share on other sites More sharing options...
galla2k4eva Posted July 30, 2005 Posted July 30, 2005 Hmm.. how do I add allowed hosts? Share this post Link to post Share on other sites More sharing options...
markiemrboo Posted July 30, 2005 Posted July 30, 2005 Hmm.. how do I add allowed hosts? 519590[/snapback] Figured you might be back asking that one. By default it only sets up the root account to be allowed from localhost or the boxes own hostname (.... local connections only basically). Small security measure. I think if you log in to mysql from the console, `mysql -u root`, then execute the following: GRANT ALL, GRANT OPTION ON *.* TO root IDENTIFIED BY 'password here'; That might do it... EDIT: edited that SQL, needs GRANT OPTION as well apparently.. Share this post Link to post Share on other sites More sharing options...
galla2k4eva Posted July 30, 2005 Posted July 30, 2005 (edited) already figured it out. =P Server UP! Edited July 30, 2005 by galla2k4eva Share this post Link to post Share on other sites More sharing options...
markiemrboo Posted July 31, 2005 Posted July 31, 2005 already figured it out. =P Server UP! 519613[/snapback] Does that mean my brain can take a short break now? Share this post Link to post Share on other sites More sharing options...
galla2k4eva Posted July 31, 2005 Posted July 31, 2005 I'll make sure its an extremely short break. Share this post Link to post Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now