+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: General Guides (https://lckb.dev/forum/forumdisplay.php?fid=194)
+----- Thread: [How To] Install CentOS 7 Server MariaDB (/showthread.php?tid=4337)
- Groby - 12-29-2014
2
1. yum update
2. yum install -y mysql mysql-server mysql-devel mysql-libs php-mysql httpd php gcc-c++ libstdc++.so.6 libz.so.1 libstdc++-libc6.2-2.so.3 libgssapi_krb5.so.2 screen lm_sensors lm_sensors-devel gtk+ php-devel
3. yum install httpd
4. systemctl start httpd.service
5. systemctl enable httpd.service
6. yum install mariadb-server mariadb
7. systemctl start mariadb
8. mysql_secure_installation
Enter current password for root (enter for none): <---- !!
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorization.
New password: password
Re-enter new password: password
Password updated successfully!
Reloading privilege tables..
... Success!
9. mysql -u root -p
10. GRANT ALL ON *.* TO 'USER'@'%' IDENTIFIED BY 'PASSWORD';
11. set global max_allowed_packet=100000000;
12.flush privileges;
13. quit
14. su --login
15. iptables -I INPUT -m tcp -p tcp --dport [CeNsOrEd] -j ACCEPT
16. service iptables save
Navicat MariaDB 2