1.下载mysql的repo源
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
2.安装mysql-community-release-el7-5.noarch.rpm包
rpm -ivh mysql-community-release-el7-5.noarch.rpm
3.安装mysql
yum install -y mysql-server
安装后没有密码,需要重置密码
4.重置密码
mysql -u root需先登录
登录时有可能报这样的错: ERROR 2002 (HY000): Can 't connect to local MySQL s erver through socket '/var/ib/mysql/mysql.sock ’ (2)原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysq|的拥有者改用户: chown -R root:root /var/lib/mysql然后,重启服务:
systemctl restart mysqld再进行登录mysql -u root
登录进数据库后,重置密码
use mysql;
update user set password=password(‘123456’) where user=‘root’;
{或者 select User from user; update mysql.user set authentication_string=password(‘123456’) where user=‘root’;
flush privileges;
}
我这里,账号是root,密码是123456
重置密码后退出,重启服务
systemctl restart myslqd
进入数据库
mysql -uroot -p
连接数据库
use mysql
开启远程连接,设置账户密码
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
(修改数据库密码)
(update user set password=password(‘新密码’) where user=‘root’;)
刷新
FLUSH PRIVILEGES;
最后退出重启数据库,完成后如果不能远程连接看看防火墙关掉没有,如果防火墙开启,请关闭
centos7安装mysql并远程连接
最新推荐文章于 2024-06-07 08:38:34 发布