JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » MySQL  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to topicthreaded modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 配置my.cnf时出状况了!
cerberi





發文: 3
積分: 0
於 2007-12-10 11:35 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
我昨天自己vi了一个/etc/my.cnf(打算加句max_connections=500)重起mysql后,客户端连接mysql就一直出现1045错误,服务器上的应用程序也拿不到连接,不知道怎么回事儿,后来删除了那个/etc/my.cnf错误依旧,现在通过cp /usr/share/mysql/my-medium.cnf /etc/my.cnf,还是同样错误

自己vi 的my.cnf代码
只是加了一句
max_connections=500

现在的my.cnf和/usr/share/mysql/my-medium.cnf完全一样


reply to postreply to post
作者 Re:配置my.cnf时出状况了! [Re:cerberi]
cerberi





發文: 3
積分: 0
於 2007-12-10 14:09 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
新情况
查看了mysql启动日志:
071210 1:24:06 [Warning] Found invalid password for user: 'root@%'; Ignoring user
071210 1:24:06 [Warning] Found invalid password for user: 'root@webserver'; Ignoring user


reply to postreply to post
作者 Re:配置my.cnf时出状况了! [Re:cerberi]
cerberi





發文: 3
積分: 0
於 2007-12-11 07:50 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
Post is deleted

koji edited on 2007-12-11 09:27
reply to postreply to post
作者 Re:配置my.cnf时出状况了! [Re:cerberi]
kebin_liu

雲端決策系統

版主

發文: 1861
積分: 11
於 2007-12-11 09:26 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
看來是 DB帳號的問題。
檢查看看 DB的帳號,或是 my.cnf裡面的 data path 是不是設定到不同地方,以致於重新建立DB了。


reply to postreply to post
作者 Re:配置my.cnf时出状况了! [Re:cerberi]
cerberi





發文: 3
積分: 0
於 2007-12-12 09:25 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
确实和DB账号有关
重置一下就好了
奇怪的是之前并没有修改过
谢谢诸位!


reply to postreply to post
» JWorld@TW »  JDBC/SQL討論區 » MySQL

reply to topicthreaded modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8