centos7环境mysql安装与配置

# 1.下载并安装MySQL官方的 Yum Repository
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

# 2.yum安装
yum -y install mysql57-community-release-el7-10.noarch.rpm

# 3.安装MySQL服务器

yum -y install mysql-community-server

# 4.首先启动MySQL

systemctl start mysqld.service

# 5.查看MySQL运行状态

systemctl status mysqld.service

 

# 6.找出默认密码, 密码是localhost：后面部分
grep "password" /var/log/mysqld.log

# 7.进入MySQL
mysql -uroot -p

# 8.修改默认密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '自己的密码';

我设置的密码为 Gxl123#0

# 9.开启mysql的远程访问
grant all privileges on *.* to 'root'@'ip地址，开启所有用%' identified by 'password' with grant option;

# 10.在MySQL中查看编码， server characterset如果不是utf8 修改
status

# 11.退出MySQL并修改配置文件
exit
vi /etc/my.cnf1

# 12.在第一行新增
[client]
default-character-set=utf8 # 如果用utf8mb4，把utf替换即可

# 13.在最后新增
character-set-server=utf8
collation-server=utf8_general_ci

 

# 13.1忽略表名大小写
lower_case_table_names=1

# 14.如果想开启sql-bin则继续在后面新增
log-bin=mysql-bin
server-id=1

# 15.保存并重启MySQL
service mysqld restart

# 16.进入MySQL查看status观察编码是否改变

# 17.创建数据库

create database MyDB_two character set utf8;

#18.进入或者切换数据库

use MyDB_two;

#19.显示当前数据库

select database();

#20.建表

create table Phone_table(pid INT, name CHAR(20), price INT);

#21.显示表信息

show create table Phone_table;

#22.给表增加字段

alter table Phone_table add color CHAR(20);