linux mysql 简单操作命令

来源：互联网发布：皮影客电脑软件下载编辑：程序博客网时间：2024/06/05 16:12

启动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 namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> 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

阅读全文

0 0