远程访问操作mysql数据库

最新推荐文章于 2024-06-13 15:02:00 发布

kalibiubiubiu

最新推荐文章于 2024-06-13 15:02:00 发布

阅读量1k

点赞数 1

本文链接：https://blog.csdn.net/qq_37759106/article/details/80228239

版权

本文档介绍了如何在CentOS上安装并配置MySQL，包括安装mysql-server、设置root密码、创建新用户、开放3306端口，并提供了一些基本的MySQL命令，如创建表、查询数据和修改用户权限。

摘要由CSDN通过智能技术生成

1.使用yum命令安装mysql

[root@bogon ~]# yum -y install mysql-server

2.设置开机启动

[root@bogon ~]#  chkconfig mysqld on

3.启动MySQL服务

[root@bogon ~]#  service mysqld start

4.设置MySQL的root用户设置密码

[root@bogon ~]#  mysql -u root

mysql> select user,host,password from mysql.user;  
+------+-----------+----------+  
| user | host      | password |  
+------+-----------+----------+  
| root | localhost |          |  
| root | bogon     |          |  
| root | 127.0.0.1 |          |  
|      | localhost |          |  
|      | bogon     |          |  
+------+-----------+----------+  
5 rows in set (0.01 sec)

5.查询用户的密码，都为空，用下面的命令设置root的密码为root

mysql> set password for root@localhost=password('root');

Query OK, 0 rows affected (0.00 sec)

6.创建mysql新用户test_user identified by'你的密码'

mysql> create user 'test_user'@'%' identified by 'test_user';

Query OK, 0 rows affected (0.00 sec)

7.给新用户test_user授权，让他可以从外部登陆和本地登陆

注意：@左边是用户名，右边是域名、IP和%，表示可以访问mysql的域名和IP，%表示外部任何地址都能访问。

mysql> grant all privileges on *.* to 'test_user'@'localhost' identified by 'test_user';  
Query OK, 0 rows affected (0.00 sec)  
mysql> grant all privileges on *.* to 'test_user'@'%' identified by 'test_user';  
Query OK, 0 rows affected (0.00 sec)  
mysql> select user,host,password from mysql.user;  
+----------+-----------+-------------------------------------------+  
| user     | host      | password                                  |  
+----------+-----------+-------------------------------------------+  
| root     | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |  
| root     | bogon     |                                           |  
| root     | 127.0.0.1 |                                           |  
|          | localhost |                                           |  
|          | bogon     |                                           |  
| test_user | %         | *3046CF87132BBD4FDDF06F321C6859074843B7D3 |  
| test_user | localhost | *3046CF87132BBD4FDDF06F321C6859074843B7D3 |  
+----------+-----------+-------------------------------------------+  
7 rows in set (0.00 sec)  
mysql> flush privileges;  
Query OK, 0 rows affected (0.01 sec)