Bug 93133

Summary: add pkg-message to mysql-server-4.0.26
Product: Ports & Packages Reporter: FBSD mailing List <fbsd_user>
Component: Individual Port(s)Assignee: Alex Dupre <ale>
Status: Closed FIXED    
Severity: Affects Only Me    
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   

Description FBSD mailing List 2006-02-10 16:20:05 UTC 
  The port has no instruction on how to activate it or use it. Add a pkg-message containing usage info so at end of the install this info will display to the installer. 

Here is the content.

To autostart mysql at boot add this to /etc/rc.conf
    mysql_enable="YES"

To start or stop mysql server do this
    /usr/local/share/mysql/mysql.server start
    /usr/local/share/mysql/mysql.server stop

You have to tell mysql to create its internel control db
by running this command.
    mysql_install_db --user=mysql

To verify mysql is operational issue these commands
    mysqladmin version
    mysqladmin variables

To start command line session with mysql server to create a DB enter
    mysql -u root 

The online mysql manual is at 
    http://dev.mysql.com/doc/refman/5.0/en/index.html

The mysql databases and log files are written here
   /var/db/mysql
Comment 1 Sergey Matveychuk freebsd_committer freebsd_triage 2006-02-10 20:41:29 UTC 
Responsible Changed
From-To: freebsd-ports-bugs->ale

Over to maintainer.
Comment 2 Alex Dupre freebsd_committer freebsd_triage 2006-05-23 07:25:34 UTC 
State Changed
From-To: open->closed

Not needed, thanks anyway.