mysql主流版本2020_mysql高级2020.7.12-2020.7.13

易学难精

rpm -ivh .rpm

rpm -qa|grep -i mysql

mysql安装时创建mysql用户和mysql组

cat /etc/passwd|grep mysql

cat /etc/group|grep mysql

mysqladmin --version查看版本

service mysql start/stop/restart

rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps 强制删除冲突库

serverTimeZone=GMT

serverTimezone=Asia/Shanghai

login-username:druid

login-password:druid

/usr/bin/mysqladmin -u root password 123456

设置自启动:chkconfig mysql on

chkconfig --list|grep mysql

ntsysv

cp /usr/share/mysql/my-huge.cnf /etc/my.cnf

把字符集改为utf-8,解决中文乱码

修改数据的存储路径

show variables like '%char%';

default-character-set=utf8

character_set_server=utf8

character_set_client=utf8

collation-server=utf8_general_ci

service mysql start/stop

连接层

引擎层

文件层

show engines;

show variables like

create index idx_user_name on user(name)

索引单值，复合

select * from table a inner join table b on a.key=b.key

select * from table right join table b on a.key=b.key where a.key=null