企业电子商务网站开发,如何做商城网站小程序,怎么做cms网站,苏州网络seo客户端工具的使用#xff1a;
MySQL#xff1a; mysql命令行工具#xff0c;一般用来连接访问mysql的数据。 案例#xff1a;使用mysql客户端工具连接服务器端#xff08;用户名#xff1a;root#xff1b;密码#xff1a;123456#xff09;.
[rootmysql-server ~]#…
客户端工具的使用
MySQL mysql命令行工具一般用来连接访问mysql的数据。 案例使用mysql客户端工具连接服务器端用户名root密码123456.
[rootmysql-server ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.43 MySQL Community Server (GPL)Copyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type help; or \h for help. Type \c to clear the current input statement.mysqlmysql官方不建议将密码直接写在-p选项之后。而是-p之后按回车键然后在Enter password后面输入密码。这样安全些。 案例连接10.1.1.100服务器上的MySQL数据库用户名chang密码123
mysql -h 10.1.1.100 -P 3306 -uchang -p
Enter Password: 123 案例根据不同的套接字连接不同的数据库。
[rootmysql-server ~]# mysql -S /mysql_3307/mysql.sock -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.43 Source distributionCopyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type help; or \h for help. Type \c to clear the current input statement.mysql
mysql show databases;
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| mysql_3307 |
| performance_schema |
| sys |
--------------------
5 rows in set (0.01 sec)[rootmysql-server ~]# mysql -S /tmp/mysql.sock -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.43 MySQL Community Server (GPL)Copyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type help; or \h for help. Type \c to clear the current input statement.mysql
mysql show databases;
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| mysql_3306 |
| performance_schema |
| sys |
--------------------
5 rows in set (0.00 sec)连接哪个数据库是由套接字来连接的。-S这个选项。 案例使用非交互式操作(在shell终端执行sql语句)在不进入MySQL内部的情况下执行SQL语句获取数据信息。
[rootmysql-server ~]# mysql -uroot -p -e show databases;
Enter password:
--------------------
| Database |
--------------------
| information_schema |
| mysql |
| mysql_3306 |
| performance_schema |
| sys |
--------------------没有进入到数据库直接在外边执行了show databases命令查看数据库。 扩展了解 客户端工具mysqladmin使用
mysqladmin客户端管理mysql数据库工具。 案例更改root账号的密码为root。
mysqladmin password root -uroot -p
Enter Password: 案例更改密码后建议刷新授权表mysqlflush privileges;
mysqladmin reload -uroot -p
Enter password: 案例停止mysql实例
mysqladmin shutdown -p
Enter password:
我们也可以使用service mysql_3306 stop命令来停止是可以的。 案例查看mysql的状态
mysqladmin status -p
Enter password:
[rootmysql-server ~]# mysqladmin status -p
Enter password:
Uptime: 2864 Threads: 1 Questions: 24 Slow queries: 0 Opens: 115 Flush tables: 1 Open tables: 108 Queries per second avg: 0.008案例打印可用变量mysql本身预置了很多变量信息。
mysqladmin variables -p
Enter password: 案例管理mysql的时候要确认下mysql的版本。
[rootmysql-server ~]# mysqladmin version -p
Enter password:
mysqladmin Ver 8.42 Distrib 5.7.43, for linux-glibc2.12 on x86_64
Copyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Server version 5.7.43
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 53 min 0 secThreads: 1 Questions: 28 Slow queries: 0 Opens: 116 Flush tables: 1 Open tables: 109 Queries per second avg: 0.008
