Mysql二进制安装-创新互联

Mysql安装

安装步骤

1、新建用户

groupadd mysql

useradd -r -g mysql mysql

cd /usr/local/----------------------------注意路径

chown -R mysql:mysql  mysql

chmod -R 775 mysql

2、安装依赖包

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                    

3、解压并将包放置在/usr/local下以mysql

tar -xvf mysql-5.5.28-linux2.6-i686.tar.gz

mv mysql-5.5.28-linux2.6-i686 /usr/local/mysql

5、初始化实例

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!

6、初始化配置文件修改

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

Mysql启动

1、配置环境变量

 PATH=$PATH:$HOME/bin:/usr/local/mysql/bin

2、启停数据库

mysqld_safe  --defaults-file=/etc/my.cnf --user=mysql &

--defaults-file表示配置文件路径

--user指定用那个用户启动

Mysql基本管理与维护

登录mysql

本地服务器多实例登录mysql

mysql -u -p      --socket=/data/mysql.sock

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。