本帖最后由 csq39 于 2018-5-18 09:36 编辑
1:卸载系统自带的Mariadb [root@localhost ~]
2:CentOS 7的yum源中貌似没有正常安装mysql时的mysql-sever文件,需要去官网上下载
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
# rpm -ivh mysql-community-release-el7-5.noarch.rpm # yum install mysql-community-server 3:成功安装之后重启mysql服务
service mysqld restart
4:初次安装mysql是root账户是没有密码的,设置密码的方法
mysql -uroot use mysql update user set password=password( '123456' ) where user= 'root' ;
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
delete from user where Host!='127.0.0.1'; update user set host='%'; flush privileges;
|