X-Spam-Check-By: sourceware.org
To: cygwin AT cygwin DOT com
From: Andrew DeFaria <Andrew AT DeFaria DOT com>
Subject:  Re: perl DBD::mysql under cygwin question
Date:  Fri, 27 Apr 2007 17:41:06 -0500
Lines: 37
Message-ID: <f0tu63$pff$1@sea.gmane.org>
References:  <462F830B DOT E051F299 AT dessent DOT net> <390873 DOT 70791 DOT qm AT web52012 DOT mail DOT re2 DOT yahoo DOT com>
Mime-Version:  1.0
Content-Type:  text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding:  7bit
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
In-Reply-To: <390873.70791.qm@web52012.mail.re2.yahoo.com>
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com

fungazid fungazid wrote:
> Brian hello,
>
> Thank you a lot, this specific problem is solved.
>
> I used
>
> 1)./configure --prefix=/usr/local/mysql
> --without-server
So you want no server...
> 2) make
> 3) make install
> 4) cd /usr/local/mysql/bin
> 5)./mysql -h 127.0.0.1
>
> I tested mysql and it works. I still have some little problem with 
> user access to mysql table that I'm
> trying to solve (I guess it's a cygwin problem):
>
> mysql> use mysql
Nope. At the point where you typed in mysql to the command prompt you 
left cygwin!  You specified -h (for host) and 127.0.0.1 your loop back 
address. So you are trying to talk to your own machine as the server, 
which you just told it you didn't want one! Hint you might be able to 
specify -h <ip address of a real server> say a Linux server. Of course 
it'd need to be configured properly to allow you access, etc...
> ERROR 1044 (42000): Access denied for user 'admin'@'%'
> to database 'mysql'
This is a number of problems. First there's no server because you told 
it not to do one. Secondly, assuming you did make a server here, there's 
no configuration setting up the mysql database. So there's no mysql 
database to consult to see if "admin" can access mysql databases! 
Further - are you really named "admin"? That's a strange name for a 
person like you.
-- 
Andrew DeFaria <http://defaria.com>
I tried sniffing Coke once, but the ice cubes froze the end of my nose.


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/