在linux中安装mysql

来源：互联网发布：javascript精粹编辑：程序博客网时间：2024/05/22 17:40

我用的是mysql 5.6.31 版本，采用rpm包的方式安装。

mysql百度网盘下载地址

步骤：

1.解压tar包
tar -xvf MySQL-5.6.31-1.el6.x86_64.rpm-bundle.tar
解压后存在以下rpm包
MySQL-server-5.6.31-1.el6.x86_64.rpm
MySQL-client-5.6.31-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.31-1.el6.x86_64.rpm
MySQL-embedded-5.6.31-1.el6.x86_64.rpm
MySQL-test-5.6.31-1.el6.x86_64.rpm
MySQL-shared-5.6.31-1.el6.x86_64.rpm
MySQL-devel-5.6.31-1.el6.x86_64.rpm

2.在解压的目录中安装server和client
rpm -ivh MySQL-server-5.6.31-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.31-1.el6.x86_64.rpm
3 可rpm -qa |grep -i mysql查看mysql安装情况（如果已经安装mysql 删除mysql的依赖
rpm -e --nodeps `rpm -qa | grep mysql`或者
rpm -e --nodeps `rpm -qa | grep MySQL`）

4 启动mysql服务

执行 service mysql start命令

5mysql5.5以前密码都是空，从5.6开始密码改为随机密码了
less /root/.mysql_secret查看随机密码
[root@node1 bin]# less /root/.mysql_secret
# The random password set for the root user at Fri Jul 29 02:31:18 2016 (local time): QVCctC6L6RH1ausR

6root用户登录

执行命令mysql -uroot -pQVCctC6L6RH1ausR

7登陆后修改密码
set PASSWORD=PASSWORD("hadoop222");

8mysql加入到开机启动项
chkconfig mysql on

9执行mysql -h node1 -uroot -phadoop222
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'node1' (using password: YES)
解决办法：
mysql> grant all privileges on *.* to 'root'@'%' identified by 'hadoop222';
mysql> flush privileges;

0 0