Mysql install: Difference between revisions
From wikinotes
No edit summary |
(→Docker) |
||
Line 15: | Line 15: | ||
= Docker = | = Docker = | ||
<blockquote> | <blockquote> | ||
<syntaxhighlight lang="bash"> | |||
docker run --name mysql -e MYSQL_ROOT_PASSWORD=password -d mysql:5.7 | |||
</syntaxhighlight> | |||
</blockquote><!-- Docker --> | </blockquote><!-- Docker --> | ||
Latest revision as of 04:09, 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
docker run --name mysql -e MYSQL_ROOT_PASSWORD=password -d mysql:5.7
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;