mysql常用命令
1. sudo apt-get install mysql-server设置密码: 123456
2. apt-get isntall mysql-client
如果出现错误
执行 sudo apt-get update
判断mysql是否安装成功
sudo netstat -tap | grep mysql
通过上述命令检查之后,如果看到有mysql 的socket处于 listen 状态则表示安装成功。
登陆mysql数据库可以通过如下命令:
mysql -u root -p
-u 表示选择登陆的用户名, -p 表示登陆的用户密码,上面命令输入之后会提示输入密码,此时输入密码就可以登录到mysql。
查看当前的数据库。
show databases;
我们选择 mysql数据库就行下一步操作,使用use mysql 命令,显示当前数据库的表单:show tables;
退出 exit
默认安装后的字符集 查看
show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.03 sec)
Ubuntu中MySQL5.7设置utf8编码格式步骤
http://blog.csdn.net/qq_32144341/article/details/51318390
a. sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf
打开mysqld.cnf 文件,在lc-messages-dir= /usr/share/mysql 语句后(下) 添加 character-set-server=utf8 语句
b.在终端输入 sudo gedit /etc/mysql/conf.d/mysql.cnf 命令打开mysql.cnf配置文件(下),添加代码:default-character-set=utf8
c. /etc/init.d/mysql restart 命令重启MySQL服务
或mysql重启一下
sudo service mysql restart
SHOW VARIABLES LIKE 'char%';命令 ,显示修改成功
查看 mysql版本号
方法1
mysql -V
mysqlVer 14.14 Distrib 5.7.17, for Linux (x86_64) usingEditLine wrapper
方法2
mysql --help | grep Distrib
mysqlVer 14.14 Distrib 5.7.17, for Linux (x86_64) usingEditLine wrapper
方法3
mysql> status;
--------------
mysqlVer 14.14 Distrib 5.7.17, for Linux (x86_64) usingEditLine wrapper
Connection id: 6
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.17-0ubuntu0.16.04.2 (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: 5 min 41 sec
Threads: 1Questions: 6Slow queries: 0Opens: 107Flush tables: 1Open tables: 26Queries per second avg: 0.017
--------------
方法4 使用mysql的函数
mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 5.7.17-0ubuntu0.16.04.2 |
+-------------------------+
1 row in set (0.02 sec)
本帖最后由 java 于 2018-6-7 15:07 编辑
登录
mysql -u root -p -------本机登录
mysql -h192.168.134.106 -P3306 -uadmin -padmin123 --default-character-set=utf8mb4 -A
mysql -h10.249.1.130 -P3306 -uRoot -pPASSWORD --default-character-set=utf8mb4 -A
show databases;
use <数据库名>;
//查看表结构
desc tabl_name;
查看表生成的DDL
show create table table_name;
select * from table_name;
创建库CREATE DATABASE `school` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;创建表CREATE TABLE `sys_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`nickname` varchar(50) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 可用 1 删除',
`descinfo` varchar(200) DEFAULT ' ',
`create_time` bigint(20) NOT NULL,
`modify_time` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username_UNIQUE` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
增加唯一键ALTER TABLE `school`.`sys_user` ADD UNIQUE INDEX `username_UNIQUE` (`username` ASC);
页:
[1]