Difference between revisions of "MySQL"

From Secure Computing Wiki
Jump to: navigation, search
m (Mysql moved to MySQL: case)
(No difference)

Latest revision as of 09:32, 19 July 2007

  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
    Query OK, 0 rows affected (0.00 sec)