Mysql install

From wikinotes
Revision as of 04:05, 11 September 2022 by Will (talk | contribs)

Archlinux

sudo pacman -S mariadb
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl enable mariadb
sudo systemctl start  mariadb

## you can then modify the database as the user `root`
## `mysql -u root`

Docker

FreeBSD

sudo pkg install mysql57-server
echo "MYSQL_ENABLE=\"YES\"" >> /etc/rc.conf
sudo service mysql-server start

Starting with mysql-5.7, a temporary root password is assigned.
You must reassign it to use the database.

mysql -u root --password=$(cat /root/.mysql_secret | tail -n1)
ALTER USER `root`@`localhost` IDENTIFIED BY 'some-password';
FLUSH PRIVILEGES;