1、在 /etc/yum.repos.d/ 下建立 MariaDB.repo,内容如下:
|
1 2 3 |
[azureuser<span class="hljs-variable">@mono</span> etc]<span class="hljs-variable">$ </span>cd /etc/yum.repos.d [azureuser<span class="hljs-variable">@mono</span> yum.repos.d]<span class="hljs-variable">$ </span>vi MariaDB.repo |
拷贝以下内容：
|
1 2 3 4 5 6 7 8 |
<span class="hljs-comment"># MariaDB 10.0 CentOS repository list - created 2013-08-23 13:08 UTC </span> <span class="hljs-comment"># http://mariadb.org/mariadb/repositories/ </span> <span class="hljs-section">[mariadb]</span> <span class="hljs-attr">name</span> = MariaDB <span class="hljs-attr">baseurl</span> = http://yum.mariadb.org/<span class="hljs-number">10.0</span>/centos6-amd64 <span class="hljs-attr">gpgkey</span>=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB <span class="hljs-attr">gpgcheck</span>=<span class="hljs-number">1</span> |
如果是其他的操作系统，可以在这里找到相关信息。
2、使用YUM安装MariaDB
|
1 2 |
[azureuser@mono yum.repos.d]$ sudo yum -y <span class="hljs-keyword">install</span> MariaDB-<span class="hljs-keyword">client</span> MariaDB-<span class="hljs-keyword">server</span> MariaDB-devel |
3、启动数据库
|
1 2 |
[azureuser<span class="hljs-variable">@mono</span> yum.repos.d]<span class="hljs-variable">$ </span>sudo service mysql start |
4、修改Root的密码
|
1 2 |
[azureuser<span class="hljs-variable">@mono</span> yum.repos.d]<span class="hljs-variable">$ </span>mysqladmin -u root password ‘passwd’ |
5、配置远程访问，MariaDB为了安全起见，默认情况下绑定ip（ 127.0.0.1）。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[azureuser<span class="hljs-variable">@mono</span> yum.repos.d]<span class="hljs-variable">$ </span>mysql -u root -p Enter <span class="hljs-symbol">password:</span> Welcome to the MariaDB monitor. Commands <span class="hljs-keyword">end</span> with ; <span class="hljs-keyword">or</span> \g. Your MariaDB connection id is <span class="hljs-number">4</span> Server <span class="hljs-symbol">version:</span> <span class="hljs-number">10.0</span>.<span class="hljs-number">4</span>-MariaDB MariaDB Server Copyright (c) <span class="hljs-number">2000</span>, <span class="hljs-number">2013</span>, Oracle, Monty Program Ab <span class="hljs-keyword">and</span> others. Type <span class="hljs-string">'help;'</span> <span class="hljs-keyword">or</span> <span class="hljs-string">'\h'</span> <span class="hljs-keyword">for</span> help. Type <span class="hljs-string">'\c'</span> to clear the current input statement. MariaDB [(none)]>GRANT ALL PRIVILEGES ON *.* TO <span class="hljs-string">'root'</span>@<span class="hljs-string">'%'</span> IDENTIFIED BY ‘passwd’ WITH GRANT OPTION; MariaDB [(none)]> flush privileges; |
第一句中”%”表示任何主机都可以远程登录到该服务器上访问。如果要限制只有某台机器可以访问，将其换成相应的IP即可，如：
|
1 2 |
<span class="hljs-keyword">GRANT</span> ALL <span class="hljs-keyword">PRIVILEGES</span> <span class="hljs-keyword">ON</span> *.* <span class="hljs-keyword">TO</span> root@<span class="hljs-string">"172.168.193.25"</span> <span class="hljs-keyword">IDENTIFIED</span> <span class="hljs-keyword">BY</span> <span class="hljs-string">"root"</span>; |
第二句表示从mysql数据库的grant表中重新加载权限数据。因为MySQL把权限都放在了cache中，所以在做完更改后需要重新加载。
6、如果系统的防火墙开着(or behind a hardware firewall or NAT)你必须放开mysql使用的TCP端口，通常都是3306。
7、大小写敏感
用root帐号登录后，在/etc/my.cnf 中的[mysqld]后添加添加lower_case_table_names=1，重启MYSQL服务，这时已设置成功：不区分表名的大小写;
其中 0：区分大小写，1：不区分大小写