MariaDB 版本 10.1.21
Fedora 版本 25
1.Change root user
sudo -i
2. dnf install -y mysql
dnf install -y mariadb mariadb-server
3. Start mariadb server and autostart mariadb on boot
systemctl start mariadb.server #启动
systemctl enable mariadb.service #随系统启动
4. 初始设置 mariadb
/usr/bin/mysql_secure_installation
- NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
- SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
- In order to log into MariaDB to secure it, we\'ll need the current
- password for the root user. If you\'ve just installed MariaDB, and
- you haven\'t set the root password yet, the password will be blank,
- so you should just press enter here.
- 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 authorisation.
- Set root password? [Y/n] y
- New password:
- Re-enter new password:
- Password updated successfully!
- Reloading privilege tables..
- ... Success!
- By default, a MariaDB installation has an anonymous user, allowing anyone
- to log into MariaDB without having to have a user account created for
- them. This is intended only for testing, and to make the installation
- go a bit smoother. You should remove them before moving into a
- production environment.
- Remove anonymous users? [Y/n] y
- ... Success!
- Normally, root should only be allowed to connect from \'localhost\'. This
- ensures that someone cannot guess at the root password from the network.
- Disallow root login remotely? [Y/n] y
- ... Success!
- By default, MariaDB comes with a database named \'test\' that anyone can
- access. This is also intended only for testing, and should be removed
- before moving into a production environment.
- Remove test database and access to it? [Y/n] y
- - Dropping test database...
- ... Success!
- - Removing privileges on test database...
- ... Success!
- Reloading the privilege tables will ensure that all changes made so far
- will take effect immediately.
- Reload privilege tables now? [Y/n] y
- ... Success!
- Cleaning up...
- All done! If you\'ve completed all of the above steps, your MariaDB
- installation should now be secure.
- Thanks for using MariaDB!
- 5.Connect to mysql database(localhost) with password
- mysql -u root -p
- 6.设置远程访问权限
GRANT ALL PRIVILEGES ON *.* TO %'IDENTIFIED BY'123' WITH GRANT OPTION; ##root 用户可以使用密码 123 从任何地方访问
FLUSH PRIVILEGES; #刷新生效
GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '123' WITH GRANT OPTION;##root 用户可以使用密码 123 从 192.168.1.3 访问
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON mydb.* TO IDENTIFIED BY '123' WITH GRANT OPTION; ##root 用户可以使用密码 123 从 192.168.1.3 访问 mydb 数据库
FLUSH PRIVILEGES;
7. 设置 firewall 防火墙
7.1 取得激活的防火墙区域
firewall-cmd --get-active-zones
例如输出:
FedoraServer #区域
interfaces:ens33# 网卡
7.2 添加防火墙规则
firewall-cmd --permanent --zone=FedoraServer --and-service=mysql
或者
firewall-cmd --permanent --zone=FedoraServer --add-port=3306/tcp
7.3 重启防火墙
systemctl restart firewalld.service
8.done
来源: http://www.bubuko.com/infodetail-1975905.html