1. 先卸载centos7 上面的mariadb与mysql的冲突(mariadb可自行百度搜索,由原mysql团队开发)
yum remove mysql-libs
=============================================================================
还看到了另外一种解决方案,感觉可行,但我未测试,保留以备不时之需
需要检查环境中是否安装了mysql的其他包:
rpm -qa | grep mysql
rpm -qa | grep Mysql
rpm -qa | grep maridb
如果安装了,需要进行卸载: rpm -e --nodeps XXXXX
=============================================================================
2.依次安装rpm包:
rpm -ivh mysql-community-common-版本号-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-版本号-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-版本号-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-版本号-1.el7.x86_64.rpm
3.如果执行 rpm -ivh mysql-community-server-版本号-1.el7.x86_64.rpm 报错的话
执行此命令:yum install numactl
然后再执行 rpm -ivh mysql-community-server-版本号-1.el7.x86_64.rpm 即可
4.启动
# systemctl start mysqld
查看状态:
# systemctl status mysqld
5.登录
这种方式安装好后,会再my.cnf文件中自动生成一个密码,执行看一下吧:
# cat /var/log/mysqld.log | grep password
2017-05-13T05:39:44.497086Z 1 [Note] A temporary password is generated for root@localhost: pKsO:Jin<4f%
2017-05-13T05:39:44.497086Z 1 [Note] A temporary password is generated for root@localhost: pKsO:Jin<4f%
密码就是这么复杂,复制吧,不然手输还容易出错。
登陆:#mysql -u root -p
.--登陆成功,但是这时候,还不能做任何事情。随便你做什么都会提示你:
ERROR 1820 (HY000):
You must reset your password
using ALTER USER statement before executing this statement.
那就来reset吧:
mysql> SET PASSWORD = PASSWORD('Mysql5718');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
(密码过于简单,必须大写,小写,数字,符号)
mysql> SET PASSWORD = PASSWORD('Mysql5718%');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> SET PASSWORD = PASSWORD('Mysql5718%');
Query OK, 0 rows affected, 1 warning (0.00 sec)
好了,现在终于可以操作了:
mysql> create database roger;
Query OK, 1 row affected (0.01 sec)
mysql> use roger;
Database changed
mysql>
Query OK, 1 row affected (0.01 sec)
mysql> use roger;
Database changed
mysql>
额外:一般自己装个mysql就是用来测试的,结果密码还那么麻烦,哪天忘记了都有可能,想要设置简单的密码,把密码安全级别设置低一点吧:
mysql> set global validate_password_policy=0;//0最低,1中级,2最强验证级别
Query OK, 0 rows affected (0.00 sec)
6.授权远程登录
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Mysql5718%' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.01 sec)
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.01 sec)