mysql报ERROR 2003错误的解决
来源:互联网 发布:叫人帮忙安装网络电视 编辑:程序博客网 时间:2024/04/28 23:23
在创建opensips数据库时,mysql报下列错误
root@opensips.clvn.com.cn:/usr/local/opensips/sbin# ./opensipsdbctl create
MySQL password for root:
INFO: test server charset
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.18' (111)
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.18' (111)
WARNING: Failed to get the available and used character sets
解决方法
root@opensips.clvn.com.cn# vim /etc/mysql/my.cnf
#bind-address = 127.0.0.1
重新启动mysql
root@opensips.clvn.com.cn# service mysql restart
mysql stop/waiting
mysql start/running, process 24719
再次执行
root@opensips.clvn.com.cn:/usr/local/opensips/sbin# ./opensipsdbctl create
MySQL password for root:
INFO: test server charset
INFO: creating database opensips ...
INFO: Core OpenSIPS tables succesfully created.
Install presence related tables? (y/n): y
INFO: creating presence tables into opensips ...
INFO: Presence tables succesfully created.
Install tables for imc cpl siptrace domainpolicy carrierroute userblacklist b2b registrant call_center? (y/n): y
INFO: creating extra tables into opensips ...
INFO: Extra tables succesfully created.
问题解决
- mysql报ERROR 2003错误的解决
- 解决mysql 报1044错误的问题
- 快速解决mysql error number 2003错误
- THINKPAD笔记本开机报FAN ERROR错误的解决
- nginx报A error occurred错误的解决过程
- 启动Apache Tomcat报各种Error错误的解决方式
- nginx报A error occurred错误的解决过程
- mysql Error 1044 错误解决
- 解决LR 报Error -26374错误
- MySQL错误ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)的解决
- 解决Django使用MySQL报模块找不到的错误
- 怎么解决mysql远程连接报10038的错误
- 怎么解决mysql远程连接报10038的错误
- Mysql中ERROR 2002 (HY000)错误的解决
- 解决MySQL创建外键时ERROR 1005, errorno:150的错误
- MySQL的ERROR 1366 (HY000): Incorrect string value错误解决
- 解决Linux MySQL报错ERROR 2002
- 解决Linux MySQL报错ERROR 2002
- hibernate update部分更新
- 创建redis集群时出现no such fileto load -- rubygems问题的解决
- FPGA机器学习之BP神经网络4
- redis集群的配置
- 安装redis时出现zmalloc.h:50:31: 错误的解决
- mysql报ERROR 2003错误的解决
- 当执行mysqladmin时报'Host' is not allowed to connect to this MySQL server'的解决
- MySQL忘记root密码后的处理
- 在Mysql下查看给某个用户授予什么样的权限
- 解决MySQL远程登录时出现ERROR 1130错误问题
- 解决MySQL初始化时发生Could not find ./bin/my_print_defaults的错误
- Mysql中ERROR 2002 (HY000)错误的解决
- 解决mysql启动时报The server quit without updating PID file 的错误
- 配置Mysql Cluster时出错Unable to connect with connect string: nodeid=0,localhost:1186问题的解决