linux mysql 简单操作命令_*e9e97379046088f46b96eda0e4e4e972cec52e54-CSDN博客

本文链接：https://blog.csdn.net/seven_begain/article/details/74332615

启动mysql

service mysqld start

关闭

service mysqld stop

重启

service mysqld restart

查看状态mysql启动

service mysqld status

查看MySQL的用户密码

mysql> 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
mysql> select host,user,password from mysql.user;
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *DE7010E8D422A39DBEAF62B32B013E488A497A8B |
| localhost.localdomain | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
| localhost             |      |                                           |
| localhost.localdomain |      |                                           |
| %                     | root | *E9E97379046088F46B96EDA0E4E4E972CEC52E54 |
+-----------------------+------+-------------------------------------------+
7 rows in set (0.00 sec)

这是用户密码

mysql> set password for 'root'@'%'=password('111111')
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> select host,user,password from mysql.user;
+-----------------------+------+-------------------------------------------+
| host                  | user | password                                  |
+-----------------------+------+-------------------------------------------+
| localhost             | root | *DE7010E8D422A39DBEAF62B32B013E488A497A8B |
| localhost.localdomain | root |                                           |
| 127.0.0.1             | root |                                           |
| ::1                   | root |                                           |
| localhost             |      |                                           |
| localhost.localdomain |      |                                           |
| %                     | root | *FD571203974BA9AFE270FE62151AE967ECA5E0AA |
+-----------------------+------+-------------------------------------------+
7 rows in set (0.00 sec)

查看mysql端口信息

[root@localhost ~]# netstat -anp| grep 3306
tcp6 0 0 :::3306 :::* LISTEN 12665/mysqld
unix 2 [ ACC ] SEQPACKET LISTENING 13306 1/systemd /run/udev/control