[client]
#password = your_password
port = 3307
socket = /tmp/mysql5.sock
# The MySQL server
[mysqld]
port = 3307
socket = /tmp/mysql5.sock
五.启动mysql1和mysql2
Mysql1:
cd /etc/rc.d/init.d/
./mysql1 start
Mysql2:
./mysql2 start
六.其他服务器命令行客户端链接mysql
mysql -ulportal -pportalpwr -h PortalDev3-DB2 -P 3306
mysql -ulportal -pportalpwr -h PortalDev3-DB2 -P 3307
七.主要错误与解决:
q. Can't connect to local MySQL server through socket '/tmp/mysql.sock(11) [root@localhost mysql]# chown -R root .
[root@localhost mysql]# chown -R mysql /var
[root@localhost mysql]# chgrp -R mysql .
q. -bash: /etc/rc.d/init.d/mysqld: Permission denied
a. chmod +x /etc/rc.d/init.d/mysqld
q. Starting MySQL.Manager of pid-file quit without updating file.[FAILED]
a. /usr/local/mysql/bin/mysql_install_db --user=mysql