MYSQL单机多实例添加以下内容方法一方法二活着sock登陆问题：解决：问题：解决：新建一个链接或在mysql中加入-S参数，直接指出mysql.sock位置。MySQL问题解决：-bash:mysql:command not found因为mysql命令的路径在/usr/local/mysql/bin下面,所以你直接使用mysql命令时,系统在/usr/bin下面查此命令,所以找不到了解决办法是：或将路径添加到环境变量中

一、创建安装目录

下载文件

二、编译命令

1、主编参数

2、从编译参数

重新运行配置，需要删除cmakecache.txt文件

三、编译

四、修改目录所有者和组

1、主库：

cd /data/mysql-s-5.6.32

chown -r mysql:mysql .

cd /usr/local/mysql

sudo scripts/mysql_install_db --user=mysql --datadir=/data/mysql-m-5.6.32/data/ --basedir=/data/mysql-m-5.6.32/ --defaults-file=/data/mysql-m-5.6.32/my.cnf

sudo scripts/mysql_install_db --user=mysql --datadir=/data/mysql-s-5.6.32/data/ --basedir=/data/mysql-s-5.6.32/ --defaults-file=/data/mysql-s-5.6.32/my.cnf

[client]

character-set-server = utf8

port = 63306

socket = /data/mysql-m-5.6.32/mysql.sock

[mysqld]

user = mysql

basedir = /data/mysql-m-5.6.32

datadir = /data/mysql-m-5.6.32/data

log-error = /data/mysql-m-5.6.32/mysql_error.log

pid-file = /data/mysql-m-5.6.32/mysql.pid

cp support-files/mysql.server /etc/init.d/mysqld-m

cp support-files/mysql.server /etc/init.d/mysqld-s

cp support-files/mysql.server /etc/init.d/mysqld

vim /etc/profile

path=/usr/local/mysql/bin:/usr/local/mysql/lib:$path

export path

source /etc/profile

chkconfig mysql-m on

service mysql-m start --启动mysql

error! the server quit without updating pid file (/data/mysql-s-5.6.32/mysql.pid).

netstat -tulnp | grep 63306

mysql -u root -p 63306

mysql -uroot -p63306 -s /data/mysql-m-5.6.32/mysql.sock

./mysqladmin -u root password '123456’ -p63306

starting mysql..the server quit without updating pid file ([failed]/mysql/server03.mylinux.com.pid).

修改/etc/my.cnf 中datadir,指向正确的mysql数据库文件目录

error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock' (2)

ln -s /usr/local/mysql/data/mysql.sock /tmp/mysql.sock

/usr/local/mysql/bin/mysql -u root -s /usr/local/mysql/data/mysql.sock

ln -s /usr/local/mysql/bin/mysql /usr/bin