mysql 非安装板_mysql非安装版的安装

# Example MySQL config file for small systems.

#

# This is for a system with little memory (<= 64M) where MySQL is only used

# from time to time and it's impor

# doesn't use much resources.

#

# MySQL programs look for option files in a set of

# locations which depend on the deployment platform.

# You can copy this option file to one of those

# locations. For information about these locations, see:

# http://dev.mysql.com/doc/mysql/en/option-files.html

#

# In this file, you can use all long options that a program supports.

# If you want to know which options a program supports, run the program

# with the "--help" option.

# The following options will be passed to all MySQL clients

[client]

#password= abcd

port= 3306

socket= MySQL

default-character-set=gbk

# Here follows entries for some specific programs

# The MySQL server

[mysqld]

port= 3306

socket= MySQL

skip-locking

key_buffer_size = 16K

max_allowed_packet = 1M

table_open_cache = 4

sort_buffer_size = 64K

read_buffer_size = 256K

read_rnd_buffer_size = 256K

net_buffer_length = 2K

thread_stack = 128K

basedir=D:\\java\\soft\\mysql-5.1.57-win32

datadir=D:\\java\\soft\\mysql-5.1.57-win32\\data

default-character-set=utf8

# 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

# (using the "enable-named-pipe" option) will render mysqld useless!

#

#skip-networking

server-id= 1

# Uncomment the following if you want to log updates

#log-bin=mysql-bin

# binary logging format - mixed recommended

#binlog_format=mixed

# Uncomment the following if you are using InnoDB tables

#innodb_data_home_dir = C:\\mysql\\data\\

#innodb_data_file_path = ibdata1:10M:autoextend

#innodb_log_group_home_dir = C:\\mysql\\data\\

# You can set .._buffer_pool_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

#innodb_buffer_pool_size = 16M

#innodb_additional_mem_pool_size = 2M

# Set .._log_file_size to 25 % of buffer pool size

#innodb_log_file_size = 5M

#innodb_log_buffer_size = 8M

#innodb_flush_log_at_trx_commit = 1

#innodb_lock_wait_timeout = 50

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-beep

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

[myisamchk]

key_buffer_size = 8M

sort_buffer_size = 8M

[mysqlhotcopy]

interactive-timeout

启动脚本

@echo off

echo start mysql5 on localhost

mysqld --install mysql5 --defaults-file=D:\java\soft\mysql-5.1.57-win32\my.ini

net start mysql5

pause

启动后cmd

service.msc能看到mysql5的服务

停止脚本

@echo off

echo stop mysql5

net stop mysql5

mysqld --remove mysql5

pause

修改密码

mysql -u root -p

密码默认为空，回车就进去了

show databases

use mysql

show tables

update user set password=PASSWORD("haoning") where user='root';

FLUSH PRIVILEGES;

quit

设置远程连接

grant all on *.* to 'root'@'%' identified by 'haoning';

---------------

show grants for "gather_club"@'192.168.100.209';

查看权限语句

linux安装参考http://www.360doc.com/content/10/0913/19/68824_53393096.shtml

---------

mysql-5.1.49.tar.gz

./configure \

--prefix=/mysql \

--localstatedir=/data \

--sysconfdir=/mysql \

--with-unix-socket-path=/mysql/mysql.sock \

--with-charset=utf8 \

--with-collation=utf8_general_ci \

--with-extra-charsets=gbk,latin1 \

--with-plugins=partition,blackhole,heap,innobase,myisam,ndbcluster,csv,federated \

--without-debug \

--enable-thread-safe-client \

--enable-assembler \

--enable-profiling \

--with-mysqld-ldflags=-all-static \

--with-client-ldflags=-all-static \

--with-mysqld-user=mysql \

--without-embedded-server \

--with-server-suffix=-community \

--with-tcp-port=3306

make

make install

mkdir /mysql

mkdir /data

./mysql_install_db --basedir=/mysql --datadir=/data/ --user=mysql

chown -R root:mysql /mysql

chown -R mysql:mysql /data

ln -sf /mysql/bin/mysqladmin /sbin/mysqladmin

ln -sf /mysql/bin/mysql /sbin/mysql

cp /mysql/share/mysql/my-large.cnf /mysql/my.cnf

[mysqld]下面添加

datadir=/data

log-error=/data/mysql.err

federated

ndbcluster

./mysqld_safe --user=mysql &

ln -s /mysql /usr/local/mysql

ln -s /tmp/mysql.sock /mysql/mysql.sock

mysql

或mysql --sock=/tmp/mysql.sock

cp /mysql/share/mysql/mysql.server /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig --level 35 mysqld on

chkconfig --list mysqld

service mysqld start

service mysqld stop

改密码

mysqladmin -uroot password "haoning" --sock=/tmp/mysql.sock

root@red54apple backup]# ps -ef|grep mysql

root 4079 1 0 16:42 pts/2 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data --pid-file=/data/red54apple.pid

mysql 4260 4079 0 16:42 pts/2 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/data --user=mysql --log-error=/data/mysql.err --pid-file=/data/red54apple.pid --socket=/tmp/mysql.sock --port=3306

root 4296 16425 0 16:45 pts/2 00:00:00 grep mysql

[root@red54apple backup]

配置rsyslog

http://www.cublog.cn/u2/76419/showart_1783316.html

分享到：

2011-05-11 14:31

浏览 1569

分类:数据库

评论