From owner-freebsd-questions@FreeBSD.ORG Thu Sep 18 18:41:58 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F1BF016A4EF for ; Thu, 18 Sep 2003 18:41:57 -0700 (PDT) Received: from smtpout.mac.com (smtpout.mac.com [17.250.248.97]) by mx1.FreeBSD.org (Postfix) with ESMTP id 588D243F3F for ; Thu, 18 Sep 2003 18:41:57 -0700 (PDT) (envelope-from barryhawkins@mac.com) Received: from mac.com (smtpin08-en2 [10.13.10.153]) by smtpout.mac.com (Xserve/MantshX 2.0) with ESMTP id h8J1fuCr021349; Thu, 18 Sep 2003 18:41:56 -0700 (PDT) Received: from mac.com (dsl027-161-197.atl1.dsl.speakeasy.net [216.27.161.197]) (authenticated bits=0) by mac.com (Xserve/8.12.9/MantshX 2.0) with ESMTP id h8J1f4wE017756; Thu, 18 Sep 2003 18:41:24 -0700 (PDT) Date: Thu, 18 Sep 2003 21:41:03 -0400 Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v552) To: "Shawn Guillemette" From: Barry Hawkins In-Reply-To: <001501c37e62$27788350$6601a8c0@hsdlaptop> Message-Id: <548F4E9E-EA42-11D7-A53C-000A95A0485E@mac.com> Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.552) cc: freebsd-questions@freebsd.org Subject: Re: mysql error and phpmyadmin how-to X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Sep 2003 01:41:58 -0000 On Thursday, Sep 18, 2003, at 23:57 US/Eastern, Shawn Guillemette wrote: > get the following error when trying to log in to mysql as root like > so .. > > # mysql -u root -p > Enter password: > ERROR 1045: Access denied for user: 'root@localhost' (Using password: > YES) > > I'm issuing this command as root. > > > Also as root I have attempted to change the passwd.. > > > # mysqladmin -u root password newpassword > mysqladmin: connect to server at 'localhost' failed > > > mysql version --> mysql-server-3.23.55 Multithreaded SQL database > (server) > > > > Also Looking for a good how-to on phpmyadmin.. > > I installed from the ports collection (phpMyAdmin-2.3.2) Just not > sure what direction to head in now.. > > > > Thanks for your time.. > > Shawn > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > > Shawn, The user named root in MySQL is completely separate from your root user for your BSD installation. It initially has no password, so "mysql -u root" without the -p should work for you. I have always installed from source code builds, so I am not sure as to whether or not the port does this for you. Have you run the mysql_install_db script to initialize the databases in MySQL? If not, you could potentially be seeing a situation where the permission tables for the daemon are not available, so you are being rejected out-of-hand. I would try the "mysql -u root" first, if you have run the script (or if the port runs the script for you; regrettably I do not know if it does). Regards, -- Barry C. Hawkins All Things Computed site: www.allthingscomputed.com/ weblog: www.allthingscomputed.com/blog/