centos 安装mysql
安装mysql
wget https://repo.mysql.com//mysql80-community-release-el7-5.noarch.rpm
rpm -ivh mysql80-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server
初始化mysql
mysqld --initialize
设置权限
chown -R mysql:mysql /var/lib/mysql/
启动mysql
systemctl start mysqld
查看mysql运行状态
systemctl status mysqld
查看安装mysql版本
mysqladmin --version
查看默认密码
sudo grep 'temporary password' /var/log/mysqld.log
现在你可以通过以下命令来连接到Mysql服务器:
mysql -u root -p
mysql修改密码步骤
-
打开跳过权限认证
# 编辑my.cnf文件 vi /etc/my.cnf # [mysqld]最后添加 skip-grant-tables
-
重启mysql
systemctl restart mysqld
-
进入数据库
mysql
-
刷新权限
flush privileges;
-
修改数据库密码
# 进入mysql表 use mysql # 必须置空验证,不然不能修改 update user set authentication_string='' where user='root'; # 刷新权限 flush privileges; # 修改密码 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456 # 退出数据库 exit
-
关闭跳过权限验证
```shell vim /etc/my.cnf # [mysqld]最后添加 skip-grant-tables ```
-
重新连接mysql数据库
# -u [user] -p [password] mysql -u root -p 123456