MariaDB数据库常用操作

ubuntu安装：
#卸载mysql
sudo apt-get remove mysql-*
sudo apt-get remove mariadb-*
sudo apt-get remove mariadb-server-*
#卸载依赖
sudo apt-get remove --purge mariadb-server-core-10.1 mariadb-client-core-10.1 mariadb-common

检查是否安装和运行：
sudo systemctl status mariadb

安装：
sudo apt-get update

sudo apt-get install whiptail #一个界面库，安装mariadb的必要条件

sudo apt-get install mariadb-server

启动
sudo systemctl start mariadb

停止
sudo systemctl stop mariadb

#连接
sudo mysql -u root -p

#修改数据库密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD(密码');
UPDATE mysql.user SET Password=PASSWORD('密码') WHERE User='root';

#创建一个允许连接的用户
CREATE USER 'usdt'@'%' IDENTIFIED BY '16838638';
GRANT ALL PRIVILEGES ON . TO 'usdt'@'%';
FLUSH PRIVILEGES;

CREATE USER 'usdt2'@'127.0.0.1' IDENTIFIED BY '16838638';
GRANT ALL PRIVILEGES ON . TO 'usdt2'@'127.0.0.1';
FLUSH PRIVILEGES;

#查询当前用户和允许的IP访问列表
SELECT User, Host FROM mysql.user;

#创建数据库
CREATE DATABASE usdt;
SELECT HOST,root,PASSWORD FROM USER;

#查看监听端口
sudo ss -plnt | grep 3306