linux里的MySQL安装
一、 切换至usr/local/src/ ,一般情况下是安装到这
[root@192 yunn]# cd /usr/local/src/
二、MySQL安装
- 第一步
[root@192 src]# wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
- 第二步
[root@192 src]# wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm
- 第三步
[root@192 src]# yum -y install mysql-server
- 第四步,更改一下设置简单密码
[root@192 src]# vim /etc/my.cnf
在下面添加:validate_password=off,保存并退出
- 第五步,启动MySQL服务:service mysqld restart
[root@192 src]# service mysqld restart
Redirecting to /bin/systemctl restart mysqld.service
[root@192 src]#
可以查看一下状态:service mysqld status
[root@192 src]# service mysqld status
- 第六步,获取随机产生的密码:cat /var/log/mysqld.log | grep password
[root@192 src]# cat /var/log/mysqld.log | grep password
2020-05-05T16:36:39.415279Z 1 [Note] A temporary password is generated for root@localhost: =Z?awrouX8kq
[root@192 src]#
- 第七步,进入MySQL:mysql -uroot -p
[root@192 src]# mysql -uroot -p
Enter password:
- 修改密码:alter user ‘root’@‘localhost’ identified by ‘123456’;
mysql> alter user 'root'@'localhost' identified by '123456';
- 刷新权限
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
mysql> flush privileges;
三、打开Navicat连接即可
可能会出现的问题
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)