freebsd13 mysql8 server - bestliutao/freebsd GitHub Wiki

1. pkg install mysql80-server

或者

1. cd /usr/ports/databases/mysql80-server/ && make install clean

启动服务

1. sysrc mysql_enable=YES
2. service mysql-server start

登录

mysql 8.0 默认密码是空，直接回车即可。

root@ykla:~ # mysql -uroot -p

修改密码

设置密码为888888，然后刷新权限。

root@localhost [(none)]> alter user 'root'@'localhost' identified by '888888';

Query OK, 0 rows affected (0.02 sec)

root@localhost [(none)]> flush privileges;

Query OK, 0 rows affected (0.00 sec) 重新登录：

root@localhost [(none)]> quit;

Bye

root@ykla:~ # mysql -uroot -p

root@localhost [(none)]> show databases;

+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec) root@localhost [(none)]>