Linux下安装第2个MySQL
来源:互联网 发布:北京软件行业协会 编辑:程序博客网 时间:2024/05/20 02:56
Linux下安装第2个MySQL
#tar -zxvf mysql-5.5.37.tar.gz
#cd mysql-5.5.37
#cmake -DCMAKE_INSTALL_PREFIX=/data/mysql -DMYSQL_DATADIR=/data/mysql/data -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/data/mysql/mysqld.sock -DMYSQL_TCP_PORT=3307 -DWITH_DEBUG=0 -DENABLED_LOCAL_INFILE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_EMBEDDED_SERVER=1
#make && make install
#cp /data/mysql/support-files/my-medium.cnf /data/mysql/my.cnf
#vim /data/mysql/my.cnf #需要加入basedir,和datadir否则会出问题
[mysqld]
basedir =
/data/mysql
datadir =
/data/mysql/data
#/data/mysql/scripts/mysql_install_db --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data &
#chown -R mysql /data/mysql/data
#chgrp -R mysql /data/mysql/.
#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql2
#chmod 755 /etc/init.d/mysql2
#vi /etc/init.d/mysql2
1)找到以下文件进行添加
basedir=
/data/mysql
datadir=
/data/mysql/data
conf=
/data/mysql/my
.cnf
2)修改以下参数
把$bindir
/mysqld_safe
--datadir=$datadir --pid-
file
=$server_pid_file $other_args >
/dev/null
2>&1&替换为:
$bindir
/mysqld_safe
--defaults-
file
=
/data/mysql/my
.cnf --datadir=$datadir --pid-
file
=$server_pid_file $other_args >
/dev/null
2>&1 &
3)把下面这句注释掉(前面加个
#):
parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`
4).保存退出并添加服务:
chkconfig --add
/etc/init
.d
/mysql2
连接MySQL:
mysql -uroot -p --socket=
/data/mysql/mysqld
.sock
0 0
- Linux下安装第2个MySQL
- linux下安装多个mysql
- Linux下安装启动多个Mysql
- Linux下安装启动多个MySQL
- Linux下安装启动多个Mysql
- linux上安装2个mysql实例
- Linux下安装Mysql
- Linux下安装MySQL
- Linux下安装MYSQL
- Linux下安装mysql
- LINUX下安装MySQL
- Linux下安装MySQL
- Linux下安装MySQL
- linux下安装mysql
- Linux下安装Mysql
- Linux下安装MySQL
- Linux 下安装mysql
- linux下安装mysql
- hadoop设置ssh免密码登陆
- git diff 文件
- [BZOJ2002][[Hnoi2010]Bounce 弹飞绵羊]
- listiview嵌套listview时带索引的定位,且隐藏不想显示的item
- 【Java集合的详细研究9】Java堆栈(stack)的使用方法
- Linux下安装第2个MySQL
- 智慧LED灯杆显示屏
- Leetcode 23
- Mutual Training for Wannafly Union #6 A(bfs)/B(规律)/E (并查集)
- 安装spring IDE插件 版本号一定要对上
- 表达式计算(C++实现)
- BaseActivity
- 年青人,渴望力量吗?
- 111