MySQL

From Secure Computing Wiki
Revision as of 08:32, 19 July 2007 by Ecrist (Talk | contribs) (Mysql moved to MySQL: case)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  1. Install MySQL 5.1 from the FreeBSD ports collection:
    # cd /usr/ports/databases/mysql51-server
    # make install clean
  2. Modify /etc/rc.conf to enable mysql server:
    # echo 'mysql_enable="YES"' >> /etc/rc.conf
  3. Start the MySQL Database server:
    # /usr/local/etc/rc.d/mysql-server start
    
    <li>Secure MySQL root account:
    <pre># mysql -u root
    mysql> use mysql;
    
    Database changed
    
    mysql> UPDATE user SET password=PASSWORD('yuf9898a') WHERE user='root';
    
    Query OK, 3 rows affected (0.00 sec)
    Rows matched: 3  Changed: 3  Warnings: 0
    
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.00 sec)