linux下管理db2工具有推荐的么?Toad?

mysql 5.5.9

编译参数

cmake . -DCMAKE_INSTALL_PREFIX=/opt/mysql -DMYSQL_DATADIR=/opt/mysql/data -DDEFAULT_CHARSET=utf8 -DMYSQL_UNXI_ADDR=/opt/mysql/mysql3306.sock

make && make install

cp ./support-file/my-medium.cnf /opt/mysql/my.cnf

cd /opt/mysql

sudo ./scripts/mysql_install_db --users=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data

su mysql

./bin/mysqld_safe --defaults-file=/opt/mysql/my.cnf

//以上够正常。没有什么错误给出。可以查询到mysqld ,mysqld_safe进程。

./bin/mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

我都socket明明是 /opt/mysql/ysql3306.sock

./bin/mysqladmin -u root passowrd 'new-pwd'
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

不能链接到mysql 服务。而且socket也不对。请教大家。

作者: flycatcn   发布时间: 2011-02-26

自己编译干嘛?

作者: leeaman   发布时间: 2011-02-26