MariaDB:修订间差异
跳到导航
跳到搜索
此页面具有访问限制。如果您看见此消息,则说明您没有权限访问此页面。
(→安裝) |
(→安裝) |
||
第6行: | 第6行: | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
export GNUPGHOME=$(mktemp -d); gpg --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0x177F4010FE56CA3336300305F1656F24C74CD1D8; gpg --export 0x177F4010FE56CA3336300305F1656F24C74CD1D8 | sudo tee /etc/apt/trusted.gpg.d/mariadb.gpg > /dev/null; unset GNUPGHOME; echo "deb http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.11/ubuntu $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/mariadb.list; sudo apt update; sudo apt install -y mariadb-server; sudo service mysql stop; cd /etc/mysql/mariadb.conf.d; sudo mv 50-server.cnf 50-server.cnf.bak; sudo wget -O 50-server.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mariadb-10.11.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start | export GNUPGHOME=$(mktemp -d); gpg --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0x177F4010FE56CA3336300305F1656F24C74CD1D8; gpg --export 0x177F4010FE56CA3336300305F1656F24C74CD1D8 | sudo tee /etc/apt/trusted.gpg.d/mariadb.gpg > /dev/null; unset GNUPGHOME; echo "deb http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.11/ubuntu $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/mariadb.list; sudo apt update; sudo apt install -y mariadb-server; sudo apt clean; sudo service mysql stop; cd /etc/mysql/mariadb.conf.d; sudo mv 50-server.cnf 50-server.cnf.bak; sudo wget -O 50-server.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mariadb-10.11.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start | ||
</syntaxhighlight> | |||
另外可以加裝mycli: | |||
<syntaxhighlight lang="bash"> | |||
sudo apt install -y mycli; sudo apt clean | |||
</syntaxhighlight> | </syntaxhighlight> | ||
2023年7月26日 (三) 22:17的版本
MariaDB是MySQL的分支版本之一。
安装
MariaDB 10.11是目前最新的LTS版本(前一个LTS是10.6),可以到MariaDB Server Releases这边查询有没有更新的LTS版本:
export GNUPGHOME=$(mktemp -d); gpg --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0x177F4010FE56CA3336300305F1656F24C74CD1D8; gpg --export 0x177F4010FE56CA3336300305F1656F24C74CD1D8 | sudo tee /etc/apt/trusted.gpg.d/mariadb.gpg > /dev/null; unset GNUPGHOME; echo "deb http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.11/ubuntu $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/mariadb.list; sudo apt update; sudo apt install -y mariadb-server; sudo apt clean; sudo service mysql stop; cd /etc/mysql/mariadb.conf.d; sudo mv 50-server.cnf 50-server.cnf.bak; sudo wget -O 50-server.cnf https://raw.githubusercontent.com/gslin/mysql-template/master/mariadb-10.11.cnf; sudo mkdir /srv/tmp; sudo chmod 1777 /srv/tmp; sudo service mysql start
另外可以加装mycli:
sudo apt install -y mycli; sudo apt clean
接下来设定root密码,以便后续可以不需要sudo,用与MySQL相同的方法登入:
echo "SET PASSWORD = PASSWORD('password');" | mysql -u root
比较特别的地方是,在有设定skip-name-resolve
时(在我上面安装的template里面有,算是MySQL系常见的设定),透过mysql -h 127.0.0.1
连线的使用者不会算在username@localhost
的帐号,而会需要另外设定一组username@%
,像是这样:
CREATE USER `trac`@`%` IDENTIFIED BY 'password_here';
GRANT ALL ON trac.* TO `trac`@`%`;
相关连结
外部连结
- 官方网站 (英文)