From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([69.77.167.62] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1JHgrF-0000hb-Ni for garchives@archives.gentoo.org; Wed, 23 Jan 2008 14:45:41 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 73449E0539; Wed, 23 Jan 2008 14:45:40 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 28F94E0539 for ; Wed, 23 Jan 2008 14:45:40 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by smtp.gentoo.org (Postfix) with ESMTP id B4A5B64FC2 for ; Wed, 23 Jan 2008 14:45:39 +0000 (UTC) X-Virus-Scanned: amavisd-new at gentoo.org X-Spam-Score: -2.588 X-Spam-Level: X-Spam-Status: No, score=-2.588 required=5.5 tests=[AWL=0.011, BAYES_00=-2.599] Received: from smtp.gentoo.org ([127.0.0.1]) by localhost (smtp.gentoo.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Lwx-uv7X6VKM for ; Wed, 23 Jan 2008 14:45:33 +0000 (UTC) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTP id 31F10649D0 for ; Wed, 23 Jan 2008 14:45:32 +0000 (UTC) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JHgr0-0004Oc-9w for gentoo-user@gentoo.org; Wed, 23 Jan 2008 14:45:26 +0000 Received: from adsl-75-3-178-22.dsl.chcgil.sbcglobal.net ([75.3.178.22]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 23 Jan 2008 14:45:26 +0000 Received: from reader by adsl-75-3-178-22.dsl.chcgil.sbcglobal.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 23 Jan 2008 14:45:26 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: gentoo-user@lists.gentoo.org From: reader@newsguy.com Subject: [gentoo-user] Re: Any one using www-apps/online-bookmarks Date: Wed, 23 Jan 2008 08:45:18 -0600 Organization: Still searching... Message-ID: <87hch4sirl.fsf@newsguy.com> References: <878x2jyooe.fsf@newsguy.com> <87ejc9eixf.fsf@newsguy.com> <200801222123.06899.shrdlu@unlimitedmail.org> <87zluxcydi.fsf@newsguy.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: adsl-75-3-178-22.dsl.chcgil.sbcglobal.net User-Agent: Gnus/5.110007 (No Gnus v0.7) Emacs/22.1 (gnu/linux) Cancel-Lock: sha1:1VNSZOBaXC2u7gtmJeUJ/KLFLnE= Sender: news X-Archives-Salt: 73270363-b025-42d9-8ced-4b671bc7636e X-Archives-Hash: 88787ec5a89e1603e0cd9ab0b5296545 "James Ausmus" writes: > On Jan 22, 2008 2:02 PM, wrote: >> I may have spoken too soon. Re-installing mysql got me to where I can >> login to the console but the suggested commands still fail: >> >> # mysql -uroot -p >> Enter password: >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 16 >> Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2 >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> create database bookmarks; >> ERROR 1006 (HY000): Can't create database 'bookmarks' (errno: 2) > > > Hmm - odd. What does the output of: > ls -al /var/lib/mysql drwx------ 2 mysql mysql 1752 Jan 22 15:55 mysql drwx------ 2 mysql mysql 48 Jan 22 15:55 test It struck me odd that /var/lib/mysql has another directory inside with the same name... but that was how the previous install looked as well. > Also, what do you get in the MySQL console if you do a: > show databases; mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ 1 row in set (0.03 sec) > Also, try doing the create database procedure as previously outlined, > then do a tail -n100 /var/log/mysql/mysql.err and > /var/log/mysql/mysqld.err and /var/log/mysql/mysql.log - anything > relative showing up in there? Maybe post the output of the above > commands, as well as (tbz2'd, if they're large) attaching the > /var/log/mysql/* files - might help us track this down... My first impulse was to look there as well but strangely nothing was being written about those errors. So in response to your post I thought I would clean out those logs with rm -f /var/log/mysql/my* Then restart mysql. Surprisingly after doing those steps. It now works. Apparently you've backhandedly fixed it simply with a request for information... : ). Now smooth as silk: > mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database bookmarks; Query OK, 1 row affected (0.00 sec) mysql> grant ALL on bookmarks.* to 'bookmarkmgr'@'localhost' identified by -> 'xxxxxxxx'; Query OK, 0 rows affected (0.02 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) And I guess... not surprisingly the bookmark page now works too? Reminds me of a comment a neighbor made yrs ago. I was a sort of neighborhood fixit guy. Pretty handy with my hands from a lifetime of bluecollar work and being raised as a kid in the country. Neighbors would call me when their fixit chores got out of there league. This one neighbor, on having me come over for an electrical problem, swore things at his house started just working when he called me to come over... said they'd see me coming and just know they'd have to work shortly. That appears to be what happened here. -- gentoo-user@lists.gentoo.org mailing list