本地数据库可视化客户端工具:sqlyog,当然其他工具也应该是一个道理
远程服务器:阿里云服务器上的MariaDB服务(其他远程数据库也是同样的道理)一、阿里云服务器自带MariaDB数据库,你在远程连接时,需要将3306端口添加至安全组
二、使用远程工具,连接到阿里云服务器,例如,FinalShell;
1、关于MariaDB数据库的操作
- 启动MariaDB命令:
systemctl start mariadb.service
- 停止MariaDB命令:
systemctl stop mariadb.service
- 重启MariaDB命令:
systemctl restart mariadb.service
2、启动数据库之后
- mysql -u root -p
- 然后输入密码
- show databases;
- use mysql;
- UPDATE user set password=PASSWORD('*****')where user='root'; (**代表你的密码,root是你的用户名)
- GRANT ALL PRIVILEGES ON *.* TO root@'%' WITH GRANT OPTION;
- commit;
- flush privileges;
- exit;
- 重启Maria:
systemctl restart mariadb.service
3、客户端连接
三、其实前面的操作已经完了,但是好多和我一样的菜鸟,命令都不知道怎么敲。下面复制一下我的命令
[root@wyx ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> UPDATE user set password=PASSWORD('wyx123456')where user='root';
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4 Changed: 4 Warnings: 0
MariaDB [mysql]> exit
Bye
=================下面第二次,上面没有重启,已经改了,但并没有生效,下面接着操作后面的==========
[root@wyx ~]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 18
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> GRANT ALL PRIVILEGES ON *.* TO root@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)
MariaDB [mysql]> commit;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit
Bye
[root@wyx ~]# systemctl restart mariadb.service
[root@wyx ~]#
最后:推荐一篇别人的https://blog.csdn.net/sihai12345/article/details/73381665