MySQL

From Secure Computing Wiki
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)
Retrieved from "http://www.secure-computing.net/wiki/index.php/MySQL"
Personal tools
Namespaces
Variants
Actions
Miscellaneous
Operating Systems
Toolbox