在centos安装mysql
1、安装rpm
从官方下载:mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
解压后安装(请按提示安装):
mysql-community-libs-5.7.17-1.el7.x86_64.rpm
mysql-community-server-5.7.17-1.el7.x86_64.rpm
mysql-community-common-5.7.17-1.el7.x86_64.rpm
mysql-community-client-5.7.17-1.el7.x86_64.rpm
rpm -ivh 包名
yum install net-tools
问题参考:
http://blog.csdn.net/fanshujuntuan/article/details/78077433
2、修改默认密码
获取默认密码
cat /etc/my.cnf
找到 log-error=/var/log/mysqld.log
cat /var/log/mysqld.log
mysqld.log有默认密码
修改密码,先进入mysql,再执行下面sql语句
SET PASSWORD = PASSWORD('your new password'); ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; flush privileges;
3、设置日期严谨模式
explicit_defaults_for_timestamp=1
4、设置远程连接
update user set Host = '%' where User='root'; flush privileges;
5、我在安装时碰到问题
启动参考
http://www.cnblogs.com/lyongde/p/3725502.html
http://blog.csdn.net/lzq123_1/article/details/51354179
CentOS安装rpm安装MySQL时爆出警告:
警告:MySQL-server-5.5.46-1.linux2.6.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
原因:这是由于yum安装了旧版本的GPG keys造成的
解决办法:后面加上
--force --nodeps
如:
rpm -ivh MySQL-server-5.5.46-1.linux2.6.x86_64.rpm --force --nodeps
mysql | 2018-02-18 02:44:53