YvEs2005

1.安裝 :  pkg install mysql57-server

2.設定初始化db  : cd   /usr/local/libexec/

mysqld --initialize-insecure --user=mysql

3.啟動

/usr/local/etc/rc.d/mysql-server onestart

4.設定密碼 :  

mysqladmin -u root password 'your-password'

5. 登入

mysql -u root -p 

6.改密碼

alter user 'root'@'localhost' identified by 'new password' ;
 

====================================================================================

備註:

If a data directory exists and is not empty (that is, it contains files or subdirectories), the server exits after producing an error message: --資料已存在，需先刪除

[ERROR] --initialize specified but the data directory exists. Aborting.

cd /var/db

rm -rf mysql/

=====================================================================================

7. 新增 phpmyadmin 管理mysql

pkg install phpmyadmin

新增檔案在 /usr/local/etc/apaphe24/Includes/

nano phpmyadmin.conf

=============================

Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"

    <Directory "/usr/local/www/phpMyAdmin/">
        Options None
        AllowOverride none
        Require all granted
    </Directory>

================================

8. 重啟 apache24

/usr/local/etc/rc.d/apache24 restart

9.瀏覽 :  http://192.168.40.224/phpmyadmin/