mysql5.5安装

tar -xf mysql-5.5.22-linux2.6-x86_64.tar.gz -C   /zywa/

cd /zywa

mv mysql-5.5.22-linux2.6-x86_64/ mysql

groupadd mysql

useradd  -g mysql -m -s "/bin/bash" -b /home/mysql -d /home/mysql mysql

chown  mysql:mysql  -R mysql/

vim /etc/my.cnf

[mysql]
default-character-set = utf8

[mysqld]
skip-name-resolve
port = 3306
basedir = /zywa/mysql
datadir = /zywa/mysql/data
socket = /tmp/mysql.sock
max_connections = 200
character-set-server = utf8
default-storage-engine = INNODB
lower_case_table_names = 1
max_allowed_packet = 16M
log-bin = /zywa/mysql/binlog/replicalog
server-id = 1
binlog_format = row

[mysqld_safe]
log-error = /zywa/mysql/log/mysql.log
pid-file = /zywa/mysql/log/mysql.pid

 vim /etc/profile

MYSQL_HOME=/zywa/mysql
PATH=$PATH:$MYSQL_HOME/bin
export PATH MYSQL_HOME

cd /zywa/mysql

rm -rf data/

mkdir data log binlog

./scripts/mysql_install_db --user=mysql --basedir=/zywa/mysql --datadir=/zywa/mysql/data

mysqld_safe --user=mysql --skip-grant-tables --skip-networking --basedir=/zywa/mysql --datadir=/zywa/mysql/data

cp support-files/mysql.server  /etc/init.d/mysqld

/etc/init.d/mysqld start

mysql -uroot

update mysql.user set authentication_string=PASSWORD('123456') where user='root';

grant all on *.* to 'root'@'%' identified by '123456';   #给与root最大权限，，线上不可如此操作

update mysql.user set password=PASSWORD('123456') where user='root';

flush privileges;

 

参考博客https://blog.youkuaiyun.com/z13615480737/article/details/80019881