Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 18 Sep 2003 21:41:03 -0400
From:      Barry Hawkins <barryhawkins@mac.com>
To:        "Shawn Guillemette" <shawn@guillemette.org>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: mysql error  and phpmyadmin how-to
Message-ID:  <548F4E9E-EA42-11D7-A53C-000A95A0485E@mac.com>
In-Reply-To: <001501c37e62$27788350$6601a8c0@hsdlaptop>

next in thread | previous in thread | raw e-mail | index | archive | help
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/



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?548F4E9E-EA42-11D7-A53C-000A95A0485E>