tutorial mariadb

[SFXTM 0]

someone help me to install mariadb.. ? 

[alpha000network 0]

1) pkg update

2) pkg install mariadb105-server mariadb105-client

3) mysql_install_db --datadir=/usr/local/mysql/data

4) mysql_enable="YES" 

5) service mysql-server start

6) mysql_secure_installation

7) mysql -u root -p

If you have more questions I will help you.

[SFXTM 0]

Hello, and în navicat what i need to change, and in source i have to change something?

[iFreakTime~.~ 56]

Hi, you can follow this tutorial wrote by Shogun here.

https://web.archive.org/web/20240524103018/https://freebsdis.fun/switching-to-mariadb-on-freebsd/

Edited October 16, 2024 by iFreakTime~.~

[SFXTM 0]

hello, i installed mariadb, but i can t change password

[iFreakTime~.~ 56]

11 hours ago, SFXTM said:

hello, i installed mariadb, but i can t change password

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
Follow this tutorial to reset your root password, by default the user do not have a password.