通常我们在一些场景下会用到一个字符串是否包含某种特定字符,比如判断密码是否只包含数字,检查url是否有不规范字符,删除多余空格等操作 CharacterSet简单描述 ---- CharacterSet...下面是简单分组总结: 属性 描述 CharacterSet.alphanumerics 字母和数字的组合,包含大小写, 不包含小数点 CharacterSet.capitalizedLetters 字母...,首字母大写,Lt类别 CharacterSet.decimalDigits 0-9的数字,也不包含小数点 CharacterSet.whitespaces 空格 CharacterSet.whitespacesAndNewlines...空格和换行 CharacterSet.letters 所有英文字母,包含大小写 65-90 97-122 CharacterSet.lowercaseLetters 小写英文字母 97-122 CharacterSet.uppercaseLetters...大写英文字母 65-90 CharacterSet.nonBaseCharacters 非基础字符 M* CharacterSet.illegalCharacters 不合规字符,没有在Unicode
GPL), Release 21, Revision 2a37e4e Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: utf8 Db characterset: utf8 Client characterset: utf8 Conn....characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 26 min 14 sec Threads: 1 Questions...: utf8Db characterset: utf8Client characterset: utf8Conn. ...characterset: utf8UNIX socket: /var/lib/mysql/mysql.sockUptime: 26 min 14 sec Threads: 1 Questions
MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: latin1 Db characterset: latin1 Client characterset: utf8 Conn....characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 2 min...: latin1 Db characterset: latin1 Client characterset: gbk Conn....characterset: gbk TCP port: 3307 Uptime: 4 hours 9 min 29 sec Threads
Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset...: latin1 Db characterset: latin1 Client characterset: gbk Conn....characterset: gbk TCP port: 3307 Uptime: 4 hours 7 min 11 sec Threads...: latin1 Db characterset: latin1 Client characterset: gbk Conn....characterset: gbk TCP port: 3307 Uptime: 4 hours 9 min 29 sec Threads
一、使用命令行模式进入mysql会看到最开始的提示符; 查看版本信息 #1使用命令行模式进入mysql会看到最开始的提示符 Your MySQL connection id is 3 Server...5.1.69 Source distribution Protocol version:10 Connection: Localhost via UNIX socket Server characterset...:utf8 Db characterset:utf8 Client characterset:utf8 Conn. characterset:utf8 UNIX socket:...GPL), Release 5, Revision a2f663a Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var
Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: latin1 Db characterset: latin1 Client characterset: latin1 Conn. ...characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 2...: latin1 Db characterset: latin1 Client characterset: latin1 Conn. ...characterset: latin1 UNIX socket: /tmp/mysql5.sock Uptime:
查看所有数据库 show databases; 切换数据库 # 切换到student数据库 use student; 查看当前数据库 select database(); 或 通过show tables查看 mysql...| employee | | student | +-----------------+ 8 rows in set (0.04 sec) 或 通过status查看 mysql...> status; -------------- mysql Ver 8.0.18 for osx10.15 on x86_64 (Homebrew) Connection id: 12...: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn....characterset: utf8mb4 UNIX socket: /tmp/mysql.sock Uptime: 4 days 20 hours 19 min
关于mysql的端口号 先登录mysql: fegy@fegy-X542UN:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor...socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted...5.7.26-0ubuntu0.18.04.1 (Ubuntu) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: latin1 Db characterset: latin1 Client characterset: utf8 Conn....characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 3 hours 10 min 3 sec Threads:
[root@localhost ~]# mysql -uroot -p -P 3306 -h 127.0.0.1 mysql: [Warning] Using a password on the command...Type '\c' to clear the current input statement. mysql> status -------------- mysql Ver 14.14 Distrib...5.7.26-29-log Percona Server (GPL) Protocol version: 10 Connection: 127.0.0.1 via TCP/IP Server characterset...: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8 Conn. ...characterset: utf8 TCP port: 3306 Uptime: 39 days 8 hours 53 min 39 sec Threads: 4
8.0.28 Connection: 127.0.0.1 via TCP/IP TCP port: 3350 Server characterset...: utf8mb4 Schema characterset: utf8mb4 Client characterset: utf8mb4 Conn....characterset: utf8mb4 Result characterset: utf8mb4 Compression: Disabled...: utf8mb4 Schema characterset: utf8mb4 Client characterset: utf8mb4 Conn....characterset: utf8mb4 Result characterset: utf8mb4 Compression: Disabled
但是,如果我们用的是Percona分支的MySQL,这件事就变得简单多了。...Percona MySQL 下,我们可以打开userstat参数,通过查询系统统计表来获取用户、客户端和库表访问情况,注意:该功能只在MySQL的 Percona 发行版有效,社区版不带这个功能。... Release 83.0, Revision dc97471bd40 Protocol version:10 Connection:Localhost via UNIX socket Server characterset...:utf8 Db characterset:utf8 Client characterset:utf8 Conn. ...characterset:utf8 UNIX socket:/tmp/mysql.sock Uptime:110 days 8 hours 34 min 25 sec Threads: 32 Questions
,足以看到MySQL的格局,它是把很多能做不能做得都揽过来自己做了。...wget https://dev.mysql.com/get/Downloads/MySQL-Shell/mysql-shell-1.0.9-linux-glibc2.12-x86-64bit.tar.gz...如果查看MySQL服务的状态,就是一个很简单的status mysql-js> \status MySQL Shell Version 1.0.9 Session type:...5.7.17-log Protocol version: 10 Connection: 127.0.0.1 via TCP/IP Server characterset...: latin1 Schema characterset: latin1 Client characterset: latin1 Conn. characterset
=================搭建环境 一、数据库 //命令行进入数据库 mysql -uroot -p //创建数据库,并指定编码 mysql> create database itcastoa0720...default character set utf8; Query OK, 1 row affected (0.21 sec) //查询创建的数据库 mysql> show create database...Edition (Commercial) Protocol version: 10 Connection: localhost via TCP/IP Server characterset...: utf8 Db characterset: utf8 Client characterset: gbk Conn....characterset: gbk TCP port: 3306 Uptime: 2 hours 5 min 35 sec Threads
Community Server (GPL) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: latin1 Db characterset: utf8 Client characterset: latin1 Conn....characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 3 hours...: latin1 Db characterset: utf8 Client characterset: gbk ---客户端和conn端字符集都变成gbk了。...characterset: gbk UNIX socket: /var/lib/mysql/mysql.sock Uptime: 3 hours
: latin1 Db characterset: latin1 Client characterset: latin1 Conn....characterset: latin1 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 128 days 13 hours 4 min 59 sec...: latin1 Db characterset: latin1 Client characterset: utf8 Conn....: utf8 Db characterset: utf8 Client characterset: utf8 Conn....: latin1 Db characterset: utf8 Client characterset: utf8 Conn.
\MySQL Server 5.7\bin下 运行cmd窗口 mysql -uroot -p 输入密码 然后status D:\MySQL\MySQL Server 5.7\bin>mysql -uroot...Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset...: utf8 Db characterset: utf8 Client characterset: utf8 Conn....characterset: utf8 TCP port: 3306 Uptime: 10 min 17 sec Threads: 1...> 最终显示utf8 MySQL调试完毕 导入数据库 常用source 命令 进入mysql数据库控制台 如 mysql -uroot -p show databases; mysql>use
MySQL刷新权限,将某些权限从硬盘刷新到内存中(修改root密码自带隐式刷新权限操作) mysql> flush privileges; Query OK, 0 rows affected (0.00...sec) mysql> 查看服务端口 mysql> show variables like 'port'; +---------------+-------+ | Variable_name |...Community Server (GPL) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset...: latin1 Db characterset: latin1 Client characterset: utf8 Conn....characterset: utf8 UNIX socket: /tmp/mysql.sock Uptime: 2 days 16 hours
MySql版本信息的查询: 1、通过mysql -V命令查询 C:/mysql/bin>mysql -V mysql Ver 12.22 Distrib 4.0.18, for Win95/Win98...(i32) 2、通过mysql模式下的status命令查看状态 mysql> status -------------- mysql Ver 12.22 Distrib 4.0.18, for Win95...version: 4.0.18-nt Protocol version: 10 Connection: localhost via TCP/IP Client characterset...: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 19 hours...-nt | +-----------+ 1 row in set (0.00 sec) mysql> 4、通过mysql --help命令进行查看 C:/mysql/bin>mysql --help mysql
> insertinto user_info values(1,"yhd","yhd",1); Query OK, 1 row affected(0.00 sec) mysql> insertinto...英文就可以 mysql> status -------------- D:/wamp64/bin/mysql/mysql5.7.14/bin/mysql.exe Ver 14.14 Distrib 5.7.14...Protocolversion: 10 Connection: localhost via TCP/IP Servercharacterset: gbk Db characterset...: latin1 Client characterset: gbk Conn....characterset: gbk TCP port: 3306 Uptime: 47 min 25 sec Threads: 1 Questions
mysql的安装与配置 windows 对于Windows用户来说,直接点击进入官网下载安装mysql安装包,傻瓜式安装即可,注意要记住你设置的mysql密码。...密码,接着执行mysql -uroot -p登陆mysql。...systemctl restart mysqld.service # 查看是否配置成功 mysql> status; Server characterset: utf8 Db characterset...: utf8 Client characterset: utf8 Conn....characterset: utf8 到此,大功告成。如果想修改密码,可以使用下面的三种方法 # 方法一.
领取专属 10元无门槛券
手把手带您无忧上云