Installing MySQL on Linux system

It Maple fighter 2022-01-15 03:46:27 阅读数:555

installing mysql linux

Linux System installation MySQL

download Linux Installation package

  • https://dev.mysql.com/downloads/mysql/5.7.html#downloads
    
  • [ Failed to transfer the external chain picture , The origin station may have anti-theft chain mechanism , It is suggested to save the pictures and upload them directly (img-KnC1MOJd-1635812345545)(C:\Users\admin\AppData\Roaming\Typora\typora-user-images\1635811882767.png)]

install MySQL

  • uninstall centos Pre installed in mysql

  • rpm -qa | grep -i mysql
    rpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodeps
    
  • Upload mysql Installation package

  • alt + p -------> put E:/test/MySQL-5.6.22-1.el6.i686.rpm-bundle.tar
    
  • decompression mysql Installation package

  • mkdir mysql
    tar -xvf MySQL-5.6.22-1.el6.i686.rpm-bundle.tar -C /root/mysql
    
  • Install dependency packages

  • yum -y install libaio.so.1 libgcc_s.so.1 libstdc++.so.6 libncurses.so.5 -- setopt=protected_multilib=false
    yum update libstdc++-4.4.7-4.el6.x86_64
    
  • install mysql-client

  • rpm -ivh MySQL-client-5.6.22-1.el6.i686.rpm
    
  • install mysql-server

  • rpm -ivh MySQL-server-5.6.22-1.el6.i686.rpm
    

start-up MySQL service

  • service mysql start
    service mysql stop
    service mysql status
    service mysql restart 123456
    

Sign in MySQL

  • mysql After installation , Will automatically generate a random password , And stored in a password file : /root/.mysql_secret mysql -u root -p
    After login , Change Password : set password = password('itcast');
    Authorize remote access : grant all privileges on *.* to 'root' @'%' identified by 'itcast'; flush privileges; 12345678910111213
    
版权声明:本文为[It Maple fighter]所创,转载请带上原文链接,感谢。 https://javamana.com/2021/12/202112122326534491.html