Mysql install: Difference between revisions
From wikinotes
(Created page with "= Linux = <blockquote> <syntaxhighlight lang="bash"> sudo pacman -S mariadb mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql sudo systemctl enable mariadb...") |
|||
Line 19: | Line 19: | ||
echo "MYSQL_ENABLE=\"YES\"" >> /etc/rc.conf | echo "MYSQL_ENABLE=\"YES\"" >> /etc/rc.conf | ||
sudo service mysql-server start | sudo service mysql-server start | ||
</syntaxhighlight> | |||
Starting with mysql-5.7, a temporary root password is assigned.<br> | |||
You must reassign it to use the database. | |||
<syntaxhighlight lang="bash"> | |||
mysql -u root --password=$(cat /root/.mysql_secret | tail -n1) | |||
ALTER USER `root`@`localhost` IDENTIFIED BY 'some-password'; | |||
FLUSH PRIVILEGES; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
</blockquote><!-- FreeBSD --> | </blockquote><!-- FreeBSD --> |
Revision as of 05:02, 28 August 2022
Linux
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`
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;