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也不对。请教大家。
编译参数
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