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 [...]
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’);