linux上安装mysql详细步骤

￡神魔★判官ぃ 2022-01-20 03:35 454阅读 0赞

**本来是要安装Hive的，但是要先安装mysql**

**花了大半天才安装成功，原谅我太菜了**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70][]

**一、去官网下载rpm的mysql的tar包**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70 1][]

**二、查看之前是否安装过mysql，如果安装过，执行这行代码，删除之前安装过的mysql  
rpm -qa | grep -i mysql（查看）  
rpm -ev --nodeps mysql-libs-5.1.71-1.el6.x86\_64（如果有，删除）**

**三、增加用户组mysql：groupadd mysql  
       
      增加用户mysql，加入mysql用户组：useradd -r -g mysql mysql    
 **

**四、解压  tar -xvf (注意.gz才用-zxvf)**

**\#安装server  
rpm -ivh MySQL-server-5.6.29-1.linux\_glibc2.5.x86\_64.rpm  
\#安装client  
rpm -ivh MySQL-client-5.6.29-1.linux\_glibc2.5.x86\_64.rpm**

**报错：**

**java HotSpot(TM) Client VM warning:You have loaded library/...libhadoop.so which might have disabled stack guard.The VM will try to fix the stack guard now.It is highly recommended that you fix the library with 'execstack **

**解决方法：rpm -ivh MySQL-server-5.6.29-1.linux\_glibc2.5.x86\_64.rpm --force --nodeps**

**                  rpm -ivh MySQL-client-5.6.29-1.linux\_glibc2.5.x86\_64.rpm  --force --nodeps**

**五、\#修改my.cnf,默认在/usr/my.cnf  
   命令：vim /usr/my.cnf  
    \[client\]  
    default-character-set=utf8  
    \[mysql\]  
    default-character-set=utf8  
    \[mysqld\]  
    character\_set\_server=utf8  
    sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES**

**六、**

**\#启动  
命令：service mysqld start（老版本是mysqld新版本是mysql）**

**报错：error while loading shared libraries:libaio.so.1:cannot open shared object file:  
No such file or directory**

**原因是没有安装libaio.so.1，安装即可。**

**Ubuntu下执行：apt-get install libaio1 libaio-dev**

**Redhat/Fedora/CentOS下执行：yum install libaio**

** 七、   **

**service mysql  status 看mysql是否运行**

**启动过一次mysql才可以查看临时密码**

**error log的位置: 如果安装的是RPM包，则默认是 /var/log/mysqld.log。  
  
查看临时密码：**

**grep 'temporary password' /var/log/mysqld.log 或者**

**grep 'password' /var/log/mysqld.log   或者  cat /root/.mysql\_secret **

**local后面的就是密码，记下来**

**八、修改密码（必须修改初始密码）**

**在mysql系统外，使用mysqladmin  
命令：mysqladmin -u root -p password "hadoop"  
Enter password:\[ 输入第七步的初始密码\]**

**九、登陆  mysql -u root -p**

**输入密码：hadoop**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70 2][]

**                                                                                         成功！！**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70 3][]

我的公众号

![20190610171045804.jpg][]

** **

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70]: /images/20220120/daf06c64f0b542c3a23e68d17d6a8ba8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70 1]: /images/20220120/e8649d19ed884e7fbb2ec1aced87e26f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70 2]: /images/20220120/e7e8c5b9f748467bb62e07acf008d6ad.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTEyNjg0Mg_size_16_color_FFFFFF_t_70 3]: /images/20220120/7e60b4d2ce524e7085ac7397284501b4.png
[20190610171045804.jpg]: https://img-blog.csdnimg.cn/20190610171045804.jpg