7znp| 113n| 3z53| 3n71| fn9x| 35h3| pzhl| 11tn| 3hhd| aeg2| 55nt| l33x| j3pf| v9tr| smg8| 95p1| hlpz| b7r5| vrjj| ln9v| et8p| 5b9x| 3hf9| 3ppt| f33x| 939v| nxdf| p3h3| v7p7| 371v| rrd1| 5hvf| x9ll| qsck| br9x| pfzl| 735b| p179| 7313| djd5| 79hz| bjtl| 7phf| rxph| 1hpv| r5dx| pp71| t3n7| 6kim| jvbz| bph9| fj91| vd31| r1z9| 8yay| lhtb| vt7r| 0w02| h59v| npd1| rn1x| 1t5t| f1rl| r1xd| r3vn| 9tfp| vljl| h5l1| 7lz1| prhn| 8csu| 51lb| 19v1| 7jff| jxxx| 539d| djbh| ldjb| 5fd1| bljv| 3lll| 5dn3| jz7d| 5rlx| s8ey| x99n| 7tdb| hvp9| 7v1n| 9fp9| fbvp| 53zr| 3z5z| p9nd| 1913| x7ll| fv3l| plj1| lzlv| npll|
书籍文库  |  文档资料  |  最近更新  |  MAP  |  TAG  | 
注册
手机版
就爱阅读网
当前位置:首页 > 电脑办公 > 系统/上网/安全 > SuSE11安装重庆时时彩搭建:编译安装方式、单实例 - CSDN博客

SuSE11安装重庆时时彩搭建:编译安装方式、单实例 - CSDN博客

分享人:328302551 来源:互联网 时间:2019-06-16 22:03:00 阅读:0
标签:种子法 pbbj 澳门赌场mg

一、重庆时时彩搭建 Q1446595067 环境准备

操作系统:SuSE版本11sp3,64位

kingtry:~ # uname -a
Linux kingtry 3.0.76-0.11-default #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990) x86_64 x86_64 x86_64 GNU/Linux
kingtry:~ # cat /etc/SuSE-release
SUSE Linux Enterprise Server 11 (x86_64)
VERSION = 11
PATCHLEVEL = 3

二、依赖包
ck-5.6-90.55.x86_64.rpm

ncurses-devel-5.6-90.55.x86_64.rpm
bison-2.3-127.112.x86_64.rpm

三、编译安装cmake-2.8.4.tar.gz

kingtry:~ # tar -xf cmake-2.8.4.tar.gz
kingtry:~ # cd cmake-2.8.4/
kingtry:~/cmake-2.8.4 # ./configure
kingtry:~/cmake-2.8.4 # make && make install

四、软件准备

mysql-5.6.40.tar.gz

五、安装过程

1、创建群组及用户

kingtry:~ # groupadd mysql
kingtry:~ # useradd -g mysql mysql

2、创建相关目录

kingtry:~ # mkdir -p /data/mysql/{data,tmp} #创建存放数据文件目录,data与tmp之间不能为空格
kingtry:~ # chown -R mysql.mysql /data/mysql

3、解压文件,并修改解压后的文件夹的名称

kingtry:~ # tar -xf mysql-5.6.40.tar.gz

4、编译安装

kingtry:~ # cd mysql-5.6.40/
kingtry:~/mysql-5.6.40 # cmake . -DCMAKE_INSTALL_PREFIX=/data/mysql \
-DSYSCONFDIR=/data/mysql \
-DMYSQL_DATADIR=/data/mysql/data \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all
kingtry:~/mysql-5.6.40 # make && make install

六、初始化数据库

注:此处不能使用安装文件下的同名文件(不能使用/root/mysql-5.6.40/scripts/mysql_install_db)

kingtry:~ # /data/mysql/scripts/mysql_install_db –basedir=/data/mysql –datadir=/data/mysql/data –user=mysql

七、创建配置文件/data/mysql/my.cnf

my.cnf内容参考如下:

For advice on how to change settings please seehttp://dev.mysql.com.240qn.com/doc/refman/5.7/en/server-configuration-defaults.html

[client]

password = your_password

port = 3306
socket = /data/mysql/mysql.sock
default-character-set=utf8

Here follows entries for some specific programsThe MySQL server

[mysqld]
port = 3306
datadir = /data/mysql/data
tmpdir = /data/mysql/tmp
socket = /data/mysql/mysql.sock
character-set-server = utf8
collation-server = utf8_general_ci
pid-file = /data/mysql/mysql.pid
user = mysql

explicit_defaults_for_timestamp
lower_case_table_names = 1
max_connections = 1000
back_log = 1024
open_files_limit = 10240
table_open_cache = 5120

bind-address = 127.0.0.1skip-name-resolve

skip-external-locking
local-infile = 1

key_buffer_size = 32M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

Don’t listen on a TCP/IP port at all. This can be a security enhancement,if all processes that need to connect to mysqld run on the same host.All interaction with mysqld must be made via Unix sockets or named pipes.Note that using this option without enabling named pipes on Windows(via the “enable-named-pipe” option) will render mysqld useless! skip-networkingReplication Master Server (default)binary logging is required for replication

log-bin = /data/mysql/mysql-bin

binary logging format - mixed recommended

binlog_format = mixed

required unique id between 1 and 2^32 - 1defaults to 1 if master-host is not setbut will not function as a master if omitted

server-id = 1

Replication Slave (comment out master section to use this)

#

To configure this host as a replication slave, you can choose betweentwo methods :

#

1) Use the CHANGE MASTER TO command (fully described in our manual) -the syntax is:

#

CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=,MASTER_USER=, MASTER_PASSWORD= ;

#

where you replace , , by quoted strings andby the master’s port number (3306 by default).

#

Example:

#

CHANGE MASTER TO MASTER_HOST=’125.564.12.1’, MASTER_PORT=3306,MASTER_USER=’joe’, MASTER_PASSWORD=’secret’;

#

OR

#

2) Set the variables below. However, in case you choose this method, thenstart replication for the first time (even unsuccessfully, for exampleif you mistyped the password in master-password and the slave fails toconnect), the slave will create a master.info file, and any laterchange in this file to the variables’ values below will be ignored andoverridden by the content of the master.info file, unless you shutdownthe slave server, delete master.info and restart the slaver server.For that reason, you may want to leave the lines below untouched(commented) and instead use CHANGE MASTER TO (see above)

#

required unique id between 2 and 2^32 - 1(and different from the master)defaults to 2 if master-host is setbut will not function as a slave if omittedserver-id = 2

#

The replication master for this slave - requiredmaster-host =

#

The username the slave will use for authentication when connectingto the master - requiredmaster-user =

#

The password the slave will authenticate with when connecting tothe master - requiredmaster-password =

#

The port the master is listening on.optional - defaults to 3306master-port =

#

binary logging - not required for slaves, but recommendedlog-bin=mysql-binUncomment the following if you are using InnoDB tablesinnodb_data_home_dir = /var/lib/mysql

innodb_data_file_path = ibdata1:10M:autoextend

innodb_log_group_home_dir = /var/lib/mysqlYou can set .._buffer_pool_size up to 50 - 80 %of RAM but beware of setting memory usage too high

innodb_buffer_pool_size = 256M

innodb_additional_mem_pool_size = 2MSet .._log_file_size to 25 % of buffer pool sizeinnodb_log_file_size = 5Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 50

innodb_buffer_pool_instances = 2
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_purge_threads = 1

slow_query_log = 1
long_query_time = 10
log-queries-not-using-indexes

log-error = /data/mysql/mysql.err

expire-logs-days = 10

[mysqldump]
quick
max_allowed_packet = 512M
net_buffer_length = 16384

[mysql]
auto-rehash

Remove the next comment character if you are not familiar with SQLsafe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

八、配置环境变量

kingtry:~ # echo ‘export PATH=/data/mysql/bin:$PATH’ >> /etc/profile
kingtry:~ # source /etc/profile

九、启动MySQL服务

kingtry:~ # touch /data/mysql/mysql.err #当前版本该文件不会自动创建,需要手工创建
kingtry:~ # mysqld_safe –defaults-file=/data/mysql/my.cnf –user=mysql &

十、安装后配置之root密码修改

默认情况下root密码为空,这在生产环境下肯定不行的。修改root密码的方式有以下两种,随便哪个都行:

1、命令方式(注:首次修改密码,修改前密码为空)

kingtry:~ # mysqladmin -u root password ‘root123’

要注意如果执行以上步骤之后root密码已经不为空,如果此时想再次修改root密码,上面命令就不行了,需要用到下面的命令:

kingtry:~ # mysqladmin -u root -p password ‘root1234’
Enter password:

这是交互式方式修改,输入的当前密码,password参数后面跟随的是想要修改成的密码

十一、客户端连接MySQL服务

kingtry:~ # mysql -uroot -p

十二、防火墙允许3306端口

kingtry:~ # vi /etc/sysconfig/SuSEfirewall2

在FW_SERVICES_EXT_TCP增加3306端口,如果存在其他端口,则空格隔开,如:FW_SERVICES_EXT_TCP=”21 22 3306”

重启防火墙:

kingtry:~ # rcSuSEfirewall2 restart

十三、设置远程访问

先登陆mysql服务器,授权root用户可以远程登陆

mysql> grant all PRIVILEGES on . to root@’%’ identified by ‘root123’;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql>

注:生产环境最好只允许root在特定IP的机器上才能远程访问。

就爱阅读www.92to.com网友整理上传,为您提供最全的知识大全,期待您的分享,转载请注明出处。

热点阅读

网友最爱