groupadd mysql
useradd -r -g mysql mysql
cd /usr/local/----------------------------注意路径
chown -R mysql:mysql mysql
chmod -R 775 mysql
yum install libai* -y
yum install ncurses-devel -y
yum -y install bison
yum install zlib zlib-devel -y
yum install zlib -y
yum instlal libxml libjpeg freetype libpnggd curl libiconv zlib-devel
yum install libxml2-devel libjpeg-develfreetype-devel libpng-devel gd-devel curl-devel -y
yum install gcc -y
tar -xvf mysql-5.5.28-linux2.6-i686.tar.gz
mv mysql-5.5.28-linux2.6-i686 /usr/local/mysql
cd /usr/local/mysql/scripts
mkdir /data
chown mysql:mysql /data
chmod 775 mysql:mysql data
./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/
basedir------------mysql软件安装路径
datadir------------------数据文件存放路径
WARNING: The host 'mysql01' could not belooked up with resolveip.
This probably means that your libclibraries are not 100 % compatible
with this binary MySQL version. The MySQLdaemon, mysqld, should work
normally with the exception that host nameresolving will not work.
This means that you should use IP addressesinstead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have tocopy
support-files/mysql.server to the rightplace for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THEMySQL root USER !
To do so, start the server, then issue thefollowing commands:
/usr/local/mysql//bin/mysqladmin -u rootpassword 'new-password'
/usr/local/mysql//bin/mysqladmin -u root -hmysql01 password 'new-password'
Alternatively you can run:
/usr/local/mysql//bin/mysql_secure_installation
which will also give you the option ofremoving the test
databases and anonymous user created bydefault. This is
strongly recommended for productionservers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/mysql/ ;/usr/local/mysql//bin/mysqld_safe &
You can test the MySQL daemon withmysql-test-run.pl
cd /usr/local/mysql//mysql-test ; perlmysql-test-run.pl
Please report any problems with the/usr/local/mysql//scripts/mysqlbug script!
cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
[client]
port = 3306
socket = /data/mysql.sock
[mysql]
no-auto-rehash
[mysqld]
user = mysql
port = 3306
socket = /data/mysql.sock
basedir = /usr/local/mysql
datadir = /data
open_files_limit = 1024
back_log = 600
max_connections = 800
max_connect_errors = 3000
table_cache = 614
external-locking = FALSE
max_allowed_packet =8M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 100
thread_concurrency = 2
query_cache_size = 2M
query_cache_limit = 1M
query_cache_min_res_unit = 2k
#default_table_type = InnoDB
thread_stack = 192K
#transaction_isolation = READ-COMMITTED
tmp_table_size = 2M
max_heap_table_size = 2M
long_query_time = 1
#log_long_format
#log-error = /data/error.log
#log-slow-queries = /data/slow.log
pid-file = /data/mysql.pid
log-bin = /data/mysql-bin
relay-log = /data/relay-bin
binlog_cache_size = 1M
max_binlog_cache_size = 1M
max_binlog_size = 2M
expire_logs_days = 7
key_buffer_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 1M
#myisam_sort_buffer_size = 1M
#myisam_max_sort_file_size = 10G
#myisam_max_extra_sort_file_size = 10G
#myisam_repair_threads = 1
#myisam_recover
lower_case_table_names = 1
skip-name-resolve
slave-skip-errors = 1032,1062
replicate-ignore-db=mysql
server-id = 1
innodb_additional_mem_pool_size = 4M
innodb_buffer_pool_size = 32M
innodb_data_file_path =ibdata1:128M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 4M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 0
[mysqldump]
quick
max_allowed_packet = 2M
[mysqld_safe]
log-error=/data/mysql_oldboy3306.err
pid-file=/data/mysqld.pid
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &
--defaults-file 表示配置文件路径
--user指定用那个用户启动
mysql -u -p --socket=/data/mysql.sock
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
