Debian安装部署mariadb数据库

Linux 5个月前 yekei

10 0 0

sudo apt-get install mariadb-server mariadb-client

查看mysql版本和运行状态

查看版本

mysql --version

输出类似以下：

mysql  Ver 15.1 Distrib 10.1.29-MariaDB, for Debian-linux-gnu (x86_64) using readline 5.2

查看服务运行状态

sudo service mysql status

输出类似以下：

● mariadb.service - MariaDB database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: 
   Active: activating (start) since Sat 2018-08-04 18:53:56 CST; 4s ago
  Process: 13651 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VA
  Process: 13648 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_STAR
  Process: 13647 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/r
 Main PID: 13741 (mysqld)
    Tasks: 26 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─13741 /usr/sbin/mysqld

3、后台运行

sudo service mysql start 开启
sudo service mysql stop 关闭
sudo service mysql restart 重起

或
sudo service mariadb start 开启
sudo service mariadb stop 关闭
sudo service mariadb restart 重起

或
sudo service mariadb-server start 开启
sudo service mariadb-server stop 关闭
sudo service mariadb-server restart 重起

4、登录测试

mysql -u root

登录成功，类似如下

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.29-MariaDB-6 Ubuntu 18.04

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

新建数据库和用户

使用root用户登录数据库

mysql -u root -p   # 新安装数据库root用户没有密码，在输入密码界面直接回车

创建用户

createuser 用户名@localhost identified by'密码';  # 比如 createuser yekei@localhost identified by'yekei';

新建数据库并将权限赋值给用户

CREATE DATABASE yekei;GRANTALLON zhaopin.*to 用户@'localhost' IDENTIFIED BY'数据库访问密码';  # 比如  CREATE DATABASE yekei;GRANTALLON zhaopin.*to yekei@'localhost' IDENTIFIED BY'yekei';