云服务器安装Mariadb
yum install mariadb mariadb-server #安装
systemctl start mariadb #启动mariadb
systemctl enable mariadb #设置开机自启动
mysql_secure_installation #设置root密码等相关
mysql -u root -p #测试登录
- 本地远程连接 云服务器mysql ，MariaDB ，连接不上 参考 juejin.cn/post/736717…
MariaDB添加用户
-- 登录到MariaDB
mysql -u root -p
-- 创建新用户（这里以'new_user'为例，'password'替换为你的密码）
CREATE USER 'new_user'@'%' IDENTIFIED BY 'password';
-- 给予用户权限所有权限这里以'new_user'为例）
GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'%'; //或 % 改为 localhost
-- 刷新权限使其生效
FLUSH PRIVILEGES;
-- 退出
EXIT;
创建用户并授权： 创建wang用户并给予%远程登陆的权限，并对所有数据库全部授权
感觉这个更有用。开启远程权限。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
MariaDB [(none)]> GRANT ALL ON *.* TO 'wang'@'%' IDENTIFIED BY '123';
Query OK, 0 rows affected (0.000 sec)
MariaDB [(none)]> SHOW GRANTS FOR 'wang'@'%';
+--------------------------------------------------------------------------------------------------------------+
| Grants for wang@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `wang`@`%` IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
只授权用户权限： 授权一个已存在账号允许远程登陆最大权限
MariaDB [(none)]> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected (0.07 sec)
MariaDB 权限用户参考：segmentfault.com/a/119000004…
MariaDB设置初始化密码及修改密码
方法一：
代码语言：javascript
**复制
[root@localhost ~]# mysql -uroot -p
MariaDB [(none)]> use mysql;
MariaDB [mysql]> UPDATE mysql.user SET password = PASSWORD('newpassward') WHERE user = 'root';
MariaDB [mysql]> FLUSH PRIVILEGES;
方法二：
代码语言：javascript
**复制
[root@localhost ~]# mysql -uroot -p
MariaDB [(none)]> use mysql;
MariaDB [mysql]> SET password=PASSWORD('newpassward');
MariaDB [mysql]> FLUSH PRIVILEGES;
方法三：
代码语言：javascript
**复制
[root@localhost ~]# mysqladmin -u root password 'newpassword'
#如果root已经设置过密码，采用如下方法
[root@localhost ~]# mysqladmin -u root -p 'oldpassword' password 'newpassword'
参考：cloud.tencent.com/developer/a…
其它
显示收据库
show databases;
