Installation overview:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip cd mysql-VERSION
shell> ./configure –prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> bin/mysql_install_db –user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> chgrp -R mysql .
shell> bin/mysqld_safe –user=mysql &
shell> /usr/local/mysql/bin/mysqladmin -u root password \
‘new-password’
shell> /usr/local/mysql/bin/mysqladmin -u root -h \
www.hurricane-ridge.com password ‘new-password’
Then, log into the database as [...]
Log in to the database as root and do the following:
mysql> USE mysql;
mysql> UPDATE user SET password = password(‘newpassword’)
WHERE User=’username’;
mysql> FLUSH PRIVILEGES;
A brief summary of after-installation MySQL configuration when using FreeBSD’s ports system.
Log into the database as root, and run the following commands to remove anonymous accounts:
use mysql;
delete from user where User=”;
delete from db where User=”;
flush privileges;
SET PASSWORD FOR root@localhost=PASSWORD(‘newgoodstrongpassword’);
SET PASSWORD FOR root@127.0.0.1=PASSWORD(‘newgoodstrongpassword’);
SET PASSWORD FOR root@host.example.com=PASSWORD(‘newgoodstrongpassword’);