linux下centos7或者 centos6中的mysql数据库安装

#wget http://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm
下面的这个地址用的是centos7的安装地址（这个下载地址可以去mysql官网下载）
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

安装本地的rmp，yum安装依赖
yum localinstall mysql57-community-release-el7-11.noarch.rpm

如果需要在centos6中安装 把7改为6  如下

https://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm 

如果安装的是centos6则改为yum localinstall mysql57-community-release-el6-11.noarch.rpm

yum install mysql-server
mysqld --initialize --user=mysql
查看默认密码
vi /var/log/mysqld.log
启动（centos7的启动）
systemctl start mysqld
修改密码
mysqladmin -uroot -p password
 

 启动mysql并查看其状态
命令：systemctl start mysqld
命令：systemctl status mysqld

5、设置mysql为系统服务，随系统启动而启动
命令：systemctl enable mysqld
命令：systemctl daemon-reload

#默认引擎
#default-storage-engine=InnoDB

修改密码的操作

          mysql -uroot -ppassword
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=4; 
mysql> SET PASSWORD = PASSWORD('your new password');
mysql> flush privileges;
mysql> exit
使用新密码登录即可

 

配置my.cnf

vim /etc/my.cnf
[mysqld]
character_set_server = utf8
max_allowed_packet=500M
max_allowed_packet=500M
max_connections=1000
#加入下面一行会不分库名的大小写
lower_case_table_names=1

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

plugin-load=validate_password.so
validate_password_policy=0
validate-password=FORCE_PLUS_PERMANENT

9、配置完毕之后保存退出，重启数据库服务生效
命令：systemctl restart mysqld