--- title: 'Ubuntu 22.04 Mariadb install' tags: ubuntu,Mariadb description: Ubuntu 22.04 Mariadb install --- # Ubuntu 22.04 Mariadb install --- [TOC] --- ## Install Mariadb ``` terminal sudo apt update && sudo apt upgrade -y sudo apt-get install wget software-properties-common dirmngr ca-certificates apt-transport-https -y sudo apt install mariadb-server mariadb-client mariadb --version ``` ![](https://i.imgur.com/3b3hrM5.png) --- ## 設定root資料 ``` terminal sudo mysql_secure_installation ``` ![](https://i.imgur.com/Ti0wDdu.png) ![](https://i.imgur.com/3GHZZS1.png) --- ## 開通可遠端連線 ``` terminal mysql -u root -p mysql> GRANT ALL ON *.* to 'root'@'%' IDENTIFIED BY '*****' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; mysql> exit; ``` 開防火牆 ``` terminal sudo ufw allow 3306/tcp ``` 修改config ``` terminal sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf ... bind-address = 0.0.0.0 ... ``` --- ## 參考鏈結 https://linuxhint.com/install-mariadb-ubuntu-22-04/ https://www.ewdna.com/2011/09/mysqlmessage-from-server-host-xxx-is.html https://webdock.io/en/docs/how-guides/database-guides/how-enable-remote-access-your-mariadbmysql-database