From owner-freebsd-questions@FreeBSD.ORG Thu Sep 18 18:58:25 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 94CA316A4B3 for ; Thu, 18 Sep 2003 18:58:25 -0700 (PDT) Received: from bmyster.com (loqtis.bmyster.com [65.162.190.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 34D2743FDD for ; Thu, 18 Sep 2003 18:58:22 -0700 (PDT) (envelope-from shawn@guillemette.org) Received: from hsdlaptop (d-216-195-137-242.metrocast.net [216.195.137.242]) by bmyster.com (8.12.9/8.12.9) with SMTP id h8J22nRt073499; Thu, 18 Sep 2003 22:02:49 -0400 (EDT) Message-ID: <00c201c37e6a$9b123240$6601a8c0@hsdlaptop> From: "Shawn Guillemette" To: "Barry Hawkins" References: <548F4E9E-EA42-11D7-A53C-000A95A0485E@mac.com> Date: Thu, 18 Sep 2003 21:58:02 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 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:58:25 -0000 Just noticed this.,. I'm really green to mysql so this might not be anything that will help me figure out what had happened.. I can get to mysql with out a passwd > mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> ----- Original Message ----- From: "Barry Hawkins" To: "Shawn Guillemette" Cc: Sent: Thursday, September 18, 2003 6:41 PM Subject: Re: mysql error and phpmyadmin how-to > 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/ > > _______________________________________________ > 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" >