linux°²×°mysql

#½âѹ
tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar
 
#ÔÙÒƶ¯²¢ÖØÃüÃûÒ»ÏÂ
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql

mkdir -p  /data/mysql              #´´½¨Ä¿Â¼
chown mysql:mysql -R /data/mysql   #¸³ÓèȨÏÞ

vi /etc/my.cnf

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true

#½øÈëmysqlĿ¼
cd /usr/local/mysql/bin/
 
#Ö´Ðгõʼ»¯ÃüÁî
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize

cat /data/mysql/mysql.err

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

service mysql start

ps -ef|grep mysql

./mysql -u root -p     #binĿ¼ÏÂ

SET PASSWORD = PASSWORD('123456'); 

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

FLUSH PRIVILEGES;

use mysql                                            #·ÃÎÊmysql¿â

update user set host = '%' where user = 'root';      #ʹrootÄÜÔÙÈκÎhost·ÃÎÊ

FLUSH PRIVILEGES;  

yum install glibc.i686
yum install libstdc++.so.6

[root@localhost bin]#  yum install libnuma.so.1             
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
Resolving Dependencies
--> Running transaction check
---> Package numactl-libs.i686 0:2.0.12-5.el7 will be installed
--> Finished Dependency Resolution
Error:  Multilib version problems found. This often means that the root
       cause is something else and multilib version checking is just
       pointing out that there is a problem. Eg.:
       
         1. You have an upgrade for numactl-libs which is missing some
            dependency that another package requires. Yum is trying to
            solve this by installing an older version of numactl-libs of the
            different architecture. If you exclude the bad architecture
            yum will tell you what the root cause is (which package
            requires what). You can try redoing the upgrade with
            --exclude numactl-libs.otherarch ... this should give you an error
            message showing the root cause of the problem.
       
         2. You have multiple architectures of numactl-libs installed, but
            yum can only see an upgrade for one of those architectures.
            If you don't want/need both architectures anymore then you
            can remove the one with the missing update and everything
            will work.
       
         3. You have duplicate versions of numactl-libs installed already.
            You can use "yum check" to get yum show these errors.
       
       ...you can also use --setopt=protected_multilib=false to remove
       this checking, however this is almost never the correct thing to
       do as something else is very likely to go wrong (often causing
       much more problems).
       
       Protected multilib versions: numactl-libs-2.0.12-5.el7.i686 != numactl-libs-2.0.9-7.el7.x86_64