直接解压mysql-server后,
1、创建mysql用户
[root@my-desktop]# chown -R root .
[root@my-desktop]# chown -R mysql data(一定要赋权,否则无法启动)
[root@my-desktop]# chgrp -R mysql .
2、初始化数据库
[root@my-desktop]# scripts/mysql_install_db --basedir=/usr/local/mysql5.5.10_3307/ --datadir=/usr/local/mysql5.5.10_3307/data/ -u mysql
Installing MySQL system tables...
OK
Filling help tables...
OK
3、修改my.cnf
[root@my-desktop]# cp /usr/local/mysql5.5.10_3307/share/mysql/my-small.cnf /usr/local/mysql5.5.10_3307/my.cnf
修改
socket = /usr/local/mysql5.5.10_3307/data/mysql.sock(原来为 /var/lib/mysql/mysql.sock )
basedir=/usr/local/mysql5.5.10_3307
datadir =/usr/local/mysql5.5.10_3307/data
4、修改mysqld_multi.server和mysql_server
--------------
mysql Ver 14.14 Distrib 5.5.10, for Linux (i686) using readline 5.1
Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
//UNIX socket: /usr/local/mysql5.5.10_3307/data/mysql.sock
Uptime: 1 min 5 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 35 Flush tables: 1 Open tables: 4 Queries per second avg: 0.61
--------------
发现还是连接的 /var/lib/mysql/mysql.sock ,如果这样的话,会跟直接部署的mysql产生冲突
110524 16:14:47 [Note] Plugin 'FEDERATED' is disabled.
110524 16:14:47 InnoDB: The InnoDB memory heap is disabled
110524 16:14:47 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110524 16:14:47 InnoDB: Compressed tables use zlib 1.2.3
110524 16:14:47 InnoDB: Using Linux native AIO
110524 16:14:47 InnoDB: Initializing buffer pool, size = 128.0M
110524 16:14:47 InnoDB: Completed initialization of buffer pool
110524 16:14:47 InnoDB: highest supported file format is Barracuda.
110524 16:14:47 InnoDB: Waiting for the background threads to start
110524 16:14:48 InnoDB: 1.1.5 started; log sequence number 1595675
110524 16:14:48 [ERROR] /usr/local/mysql5.5.10_3307/sbin/mysqld: unknown variable 'defaults-file=/usr/local/mysql5.5.10_3307/my.cnf'
110524 16:14:48 [ERROR] Aborting
110524 16:14:48 InnoDB: Starting shutdown...
110524 16:14:49 InnoDB: Shutdown completed; log sequence number 1595675
110524 16:14:49 [Note] /usr/local/mysql5.5.10_3307/sbin/mysqld: Shutdown complete
110524 16:20:22 [Note] Plugin 'FEDERATED' is disabled.
110524 16:20:22 InnoDB: The InnoDB memory heap is disabled
110524 16:20:22 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
110524 16:20:22 InnoDB: Compressed tables use zlib 1.2.3
110524 16:20:22 InnoDB: Using Linux native AIO
110524 16:20:22 InnoDB: Initializing buffer pool, size = 128.0M
110524 16:20:22 InnoDB: Completed initialization of buffer pool
110524 16:20:22 InnoDB: highest supported file format is Barracuda.
110524 16:20:22 InnoDB: Waiting for the background threads to start
110524 16:20:23 InnoDB: 1.1.5 started; log sequence number 1595675
110524 16:20:23 [Note] Event Scheduler: Loaded 0 events
110524 16:20:23 [Note] /usr/local/mysql5.5.10_3307/sbin/mysqld: ready for connections.
Version: '5.5.10' socket: '/usr/local/mysql5.5.10_3307/data/mysql.sock' port: 3307 MySQL Community Server (GPL)
[root@my-desktop]# /usr/local/mysql5.5.10_3307/bin/mysqld_safe --defaults-file=/usr/local/mysql5.5.10_3307/my.cnf
110524 16:22:39 mysqld_safe Logging to '/usr/local/mysql5.5.10_3307/data/vieri-desktop.err'.
110524 16:22:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql5.5.10_3307/data
[root@my-desktop]# netstat -an |grep 3307
tcp 0 0 0.0.0.0:3307 0.0.0.0:* LISTEN
unix 2 [ ACC ] STREAM LISTENING 14567 /usr/local/mysql5.5.10_3307/data/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>