mysql 5.5 重新编译_mysql5.5以上编译方法

最新推荐文章于 2021-01-31 02:08:01 发布

weixin_39675513

最新推荐文章于 2021-01-31 02:08:01 发布

阅读量92

点赞数

文章标签： mysql 5.5 重新编译

本文链接：https://blog.csdn.net/weixin_39675513/article/details/113282076

版权

Yum install cmake �y

编译的方法：

cmake .-DCMAKE_BUILD_TYPE:STRING=Release -DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql-DCOMMUNITY_BUILD:BOOL=ON -DENABLED_PROFILING:BOOL=ON -DENABLE_DEBUG_SYNC:BOOL=OFF-DINSTALL_LAYOUT:STRING=STANDALONE -DMYSQL_DATADIR:PATH=/var/run/mysql-DMYSQL_MAINTAINER_MODE:BOOL=OFF -DWITH_EMBEDDED_SERVER:BOOL=ON-DWITH_EXTRA_CHARSETS:STRING=all -DWITH_SSL:STRING=bundled-DWITH_UNIT_TESTS:BOOL=OFF -DWITH_ZLIB:STRING=bundled -DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_USER=mysql-DMYSQL_TCP_PORT=3306 -LHmake make install

报错误-- Configuringincomplete, errors occurred!

没有安装ncurses-devel或者

yum install gcc gcc-c++ -y并且删除CMakeCache.txt这个文件可以find查找一个这个目录在哪里

groupadd mysqluseradd -g mysql mysql

cp/usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

vim /etc/my.cnf #需要加入basedir,和datadir否则会出问题[mysqld]basedir =/usr/local/mysql

datadir =/usr/local/mysql/datachown -R mysql /usr/local/mysql/data

chgrp -R mysql /usr/local/mysql/. cp /usr/local/mysql/support-files/mysql.server/etc/init.d/mysql/usr/local/mysql/scripts/mysql_install_db--user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data &chmod 755 /etc/init.d/mysql

chkconfig --level 345 mysql on

/etc/init.d/mysql start

/usr/local/mysql/bin/mysqladmin -u rootpassword你的MYSQL密码OK终于完成~

my.cnf优化[client]

#password = your_password

port = 3306

socket = /data/mysql/data/mysqld.sock

default-character-set = utf8

# The MySQL server

[mysqld]

port = 3306

socket = /data/mysql/data/mysqld.sock

log-error = /data/mysql/data

pid-file = /data/mysql/data/hrd.pid

skip-external-locking

key_buffer_size = 256M

max_allowed_packet = 4M

table_open_cache = 1024

sort_buffer_size = 2M

net_buffer_length = 8K

read_buffer_size = 1M

tmp_table_size = 16M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 8M

back_log = 200

skip-name-resolve

max_connections = 1000

wait_timeout = 120

thread_concurrency = 8

long_query_time = 2

slow-query_log

slow-query_log_file = /data/mysql/data/slow.log

lower_case_table_names = 1

15、mysql字符集优化SHOW VARIABLES LIKE 'CHARACTER%';查看字符环境1、在[client]字段里加入default-character-set=utf8，如下：[client]

port = 3306

socket = /var/lib/mysql/mysql.sock

default-character-set=utf8

2、在[mysqld]字段里加入character-set-server=utf8，如下：[mysqld]

port = 3306

socket = /var/lib/mysql/mysql.sock

character-set-server=utf8

遇到的问题：MySQL: Starting MySQL…..ERROR! The server quit without updating PID file

解决过程：

[root@localhost ~]#cd /usr/local/mysql

[root@localhostmysql]#chown -R mysql.mysql .[root@localhost mysql]#su- mysql[mysql@localhost ~]$cd/usr/local/mysql[mysql@localhost mysql]$scripts/mysql_install_dbInstalling MySQL system tables...

Filling help tables...

To start mysqld at boottime you have to copy

support-files/mysql.server to the right place for your system

PLEASE REMEMBER TOSET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

./bin/mysqladmin -uroot password 'new-password'

./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively youcan run:

./bin/mysql_secure_installation

which will also giveyou the option of removing the test

databases and anonymous user created by default. This is

strongly recommended for production servers.