linux下安装mysql

来源：互联网发布：虚拟机 linux nat 编辑：程序博客网时间：2024/06/16 10:35

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

成功安装之后重启mysql服务

# service mysqld restart

初次安装mysql是root账户是没有密码的

设置密码的方法

# mysql -uroot

mysql> set password for ‘root’@‘localhost’ = password('mypasswd');

mysql> exit

解决nokey问题

rpm -ivh MySQL-community-server-5.7.10-1.el5.i686.rpm --nodeps --force

You must reset your password using ALTER USER statement before executing this statement

安装完mysql 之后，登陆以后，不管运行任何命令，总是提示这个

step 1: SET PASSWORD = PASSWORD(‘your new password‘);

step 2: ALTER USER ‘root‘@‘localhost‘ PASSWORD EXPIRE NEVER;

step 3: flush privileges;

0 0