linux下管理db2工具有推荐的么?Toad?
时间:2011-02-26
来源:互联网
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
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28