Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 18 Sep 2003 21:58:02 -0700
From:      "Shawn Guillemette" <shawn@guillemette.org>
To:        "Barry Hawkins" <barryhawkins@mac.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: mysql error  and phpmyadmin how-to
Message-ID:  <00c201c37e6a$9b123240$6601a8c0@hsdlaptop>
References:  <548F4E9E-EA42-11D7-A53C-000A95A0485E@mac.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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" <barryhawkins@mac.com>
To: "Shawn Guillemette" <shawn@guillemette.org>
Cc: <freebsd-questions@freebsd.org>
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"
>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?00c201c37e6a$9b123240$6601a8c0>