数据库-day01-20201006-安装-查看-修改字段-mycli安装

# 裂开 没保存 # 安装数据库 yum -y remove mariadb wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm yum -y install mysql80-community-release-el8-1.noarch.rpm vim /etc/yum.repos.d/mysql-community.repo [mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/8/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql57-community] name=MySQL 5.7 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql yum -y install mysql-community-server systemctl start mysqld cat /var/log/mysqld.log | grep password mysql -uroot -p # 修改默认密码 alter user 'root'@'localhost' identified by '123456'; # 重置密码 vim /etc/my.cnf skip-grant-tables systemctl restart mysqld mysql -uroot -p update mysql.user set authentication_string=password('123456') where user= 'root'; exit systemctl restart mysqld mysql -uroot -p # 授予新建用户权限 8.0之前 mysql> GRANT ALL PRIVILEGES ON *.* TO 'zss'@'localhost' IDENTIFIED BY 'zss@!123S' WITH GRANT OPTION; flush privileges; 刷新权限 8.0之后 些微不一样 GRANT 授予 ALL PRIVILEGES 所有的权限 *.* 所有数据库的所有表 'zss'@'localhost' 允许本机登陆 IDENTIFIED BY 'zss@!123S' 设置密码 WITH GRANT OPTION 权限可以往下传递 mysql -uzss -p # 修改密码 alter update # 查看权限 show grants; # 回收权限 revoke # 删除用户 drop # 创建一个允许任意主机远程登陆的账户 mysql> GRANT ALL PRIVILEGES ON *.* TO 'zsss'@'%' IDENTIFIED BY 'zsss@!1234S' WITH GRANT OPTION; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql -uzsss -h192.168.0.1 -p # 只允许本机登陆 vim /etc/my.cnf bind-address=127.0.0.1 # 数据库的操作 # 创建数据库 mysql> create database zss charset=utf8; Query OK, 1 row affected (0.00 sec) # 查看数据库 mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | zss | +--------------------+ 5 rows in set (0.01 sec) mysql> # 选择数据库 mysql> use zss; Database changed mysql> create table student(id int primary key auto_increment comment "用户的唯一标识",name varchar(128),age int)charset=utf8; Query OK, 0 rows affected (0.00 sec) # 创建表 mysql> show tables; +---------------+ | Tables_in_zss | +---------------+ | student | +---------------+ 1 row in set (0.00 sec) mysql> create table teacher(id int primary key auto_increment comment "用户的唯一标识",name varchar(128),age int,height float)charset=utf8; Query OK, 0 rows affected (0.00 sec) # 查看表格结构 desc student; sescribe <tablename> # 查看建表语句 show create table student; # 修改表名字 alter table <tablename> rename <newname> # 移动表格 xusheng 移动到了test库下 改成了student表 alter table xuesheng rename to test.student; alter table <tablename> rename to <newdbname.newtablename> # 表添加字段 alter table student add score float; # 表添加字段 到最前面 alter table student add xxx int first; # 表添加字段 在某个字段后面添加 alter table student add tell int after age; # 修改字段属性 modify alter table student modify tell varchar(12) unique; # 修改字段名 change alter table student change tell ppp varchar(12) unique; # 删除字段 alter table student drop xxx; # 删除表 drop table student; # 删除库 drop database zss; # 修改数据库的编码方式 alter databse <dbname> charset=utf8; # mycli 工具 数据库命令 语法高亮 wget https://bootstrap.pypa.io/get-pip.py python3 get-pip.py pip3 install mycli pip install --ignore-installed mycli yum -y install gcc libffi-devel python-devel openssl-devel && pip install mycli==1.8.1 pip install pymysql==0.9.2 mycli -uroot ok 报错参考 https://blog.csdn.net/querydata_boke/article/details/106079018 https://blog.csdn.net/qq_33392383/article/details/107594747