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