Debian编译安装Mysql 5.5

1apt install -y binutils wget tar build-essential cmake gcc gawk bison flex texinfo automake autoconf libtool cvs libncurses5-dev libglib2.0-dev gettext intltool subversion

1# 官网下载mysql5.5.62
2wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.5.62.zip
3
4# 解压
5tar -zxf mysql-5.5.62.tar.gz
6
7# 进入目录
8cd mysql-5.5.62

1# 创建用户组
2groupadd mysql
3
4# 用户组创建用户
5useradd -M -s/sbin/nologin -g mysql -r mysql

1# 设置编译参数
2cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/home/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_unicode_ci -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_DEBUG=0 -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql
3
4# 编译并安装
5make&&make install

1chown -R mysql:mysql /usr/local/mysql
2mkdir -p /home/mysql/data
3chown -R mysql:mysql /home/mysql

1rm -rf /etc/my.cnf
2touch /etc/my.cnf
3vim /etc/my.cnf

 1[client]
 2port = 3306
 3socket = /tmp/mysql.sock
 4
 5[mysqld]
 6user = mysql
 7basedir = /usr/local/mysql
 8datadir = /home/mysql/data
 9socket = /tmp/mysql.sock
10log-error = /home/mysql/data/error.log
11max_connections = 500
12thread_cache_size = 10
13default-storage-engine = MyISAM
14innodb = OFF
15skip-innodb
16port = 3306
17socket = /tmp/mysql.sock
18skip-external-locking
19key_buffer_size = 16M
20max_allowed_packet = 20M
21table_open_cache = 256
22table_definition_cache = 400
23sort_buffer_size = 512K
24net_buffer_length = 8K
25read_buffer_size = 256K
26read_rnd_buffer_size = 512K
27myisam_sort_buffer_size = 8M
28log-bin = mysql-bin
29binlog_format = mixed
30server-id = 1
31
32[mysqldump]
33quick
34
35[mysql]
36no-auto-rehash
37
38[myisamchk]
39key_buffer_size = 20M
40sort_buffer_size = 20M
41read_buffer = 2M
42write_buffer = 2M
43
44[mysqlhotcopy]
45interactive-timeout

1/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/home/mysql/data/ --defaults-file=/etc/my.cnf
2chmod 775 /usr/local/mysql/support-files/mysql.server
3/usr/local/mysql/support-files/mysql.server start
4ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
5ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/mysqladmin
6ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump
7ln -s /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk
8ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/mysqld_safe
9rm -rf /usr/local/mysql/data/test

1touch /lib/systemd/system/mysql.service
2vim /lib/systemd/system/mysql.service

 1[Unit]
 2Description=mysql server Service
 3After=syslog.target network.target
 4
 5[Service]
 6Type=forking
 7ExecStart=/usr/local/mysql/support-files/mysql.server start
 8ExecReload=/usr/local/mysql/support-files/mysql.server restart
 9ExecStop=/usr/local/mysql/support-files/mysql.server stop
10
11[Install]
12WantedBy=multi-user.target

1ln -s /lib/systemd/system/mysql.service /etc/systemd/system/multi-user.target.wants/mysql
2systemctl daemon-reload
3systemctl enable mysql

1mysql -u root -p
2nter password:
3# 密码为空，直接回车
4
5mysql> SET PASSWORD = PASSWORD('123456');