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';
© 版权声明
文章版权归作者所有,未经允许请勿转载。
相关文章
暂无评论...