debian10 mariadb安装过程详解
<p>安装</p><div class="jb51code">
<pre class="brush:plain;">
apt-get install mariadb-server</pre>
</div>
<p>修改配置</p>
<div class="jb51code">
<pre class="brush:plain;">
vim /etc/mysql/mariadb.conf.d/50-server.cnf</pre>
</div>
<p style="text-align: center"><img alt="在这里插入图片描述" src="https://img.jbzj.com/file_images/article/202011/2020113014191778.png" /><br />
</p>
<p>修改允许所有IP连接数据库</p>
<div class="jb51code">
<pre class="brush:plain;">
bind-address =0.0.0.0</pre>
</div>
<p>修改root密码</p>
<div class="jb51code">
<pre class="brush:plain;">
mariadb</pre>
</div>
<div class="jb51code">
<pre class="brush:plain;">
update mysql.user set password=password('ChinaSkill20!') where user='root';
flush privileges;</pre>
</div>
<p>给予远程访问权限</p>
<div class="jb51code">
<pre class="brush:plain;">
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '您的数据库密码' WITH GRANT OPTION;
flush privileges;</pre>
</div>
<p>默认使用UNIX SOCKET 认证，有些 phpMyAdmin 在登入时会发生 “Access Denied” 错误。我们可以使用原生 MySQL 认证.</p>
<div class="jb51code">
<pre class="brush:plain;">
update mysql.user set plugin = 'mysql_native_password' where User='root';
flush privileges;
quit</pre>
</div>
<p>重启</p>
<div class="jb51code">
<pre class="brush:plain;">
systemctl restart mariadb</pre>
</div>
頁:
[1]