Mysql install: Difference between revisions
From wikinotes
(→Linux) |
No edit summary |
||
Line 12: | Line 12: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
</blockquote><!-- Linux --> | </blockquote><!-- Linux --> | ||
= Docker = | |||
<blockquote> | |||
</blockquote><!-- Docker --> | |||
= FreeBSD = | = FreeBSD = |
Revision as of 04:05, 11 September 2022
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 startStarting 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;