MariaDB Setup

[Baldwin]

Hi guy i show you how can you setup mariadb

service mysql-server stop
----------------
if you have mariadb
pkg remove mariadb105-server
pkg remove mariadb105-client
----------------
if you have mysql
pkg remove mysql55-server
pkg remove mysql55-client
----------------
you can change version if you have 56
pkg remove mysql56-server
pkg remove mysql56-client
----------------
pkg autoremove
----------------
in filezilla/winscp
 /etc/rc.conf open and delete mysql enable
 ----------------
open putty
cd /var/db
rm -rf mysql
cd /usr/local/etc
rm -rf mysql
rm -rf rc.d
----------------
reboot
----------------
in putty paste
pkg install mariadb106-client mariadb106-server
----------------
pwd_mkdb -p /etc/master.passwd
----------------
chown -R mysql /var/db/mysql/
chgrp -R mysql /var/db/mysql/
----------------
echo 'mysql_enable="YES"' >> /etc/rc.conf
----------------
service mysql-server start
----------------
mysqladmin -uroot -p password
Enter password: <dont write this here.>
New password: <write new pw.>
Confirm new password: <write new pw.>
----------------
mysql -p
----------------
CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;
quit;
write you pw in "password"
----------------
finish if you have psi error
----------------
cd /usr/local/include/mysql/
ln -s /usr/local/include/mysql/server/mysql/psi psi
----------------

 

[Enes K.]

thanks for sharing.

 

[Gabbiano23]

Please help, i can't connect to navicat! it says: Failed to Connect to MYSQL at <Myipaddress>:3306 with user root.