Re: mysql error and phpmyadmin how-to
# mysql -u root -px (xxx=password) That is how I got around the same error Hope it helps. ROb On Thu, 2003-09-18 at 22:57, 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: '[EMAIL PROTECTED]' (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 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
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: '[EMAIL PROTECTED]' (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 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] 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/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql error and phpmyadmin how-to
this was part of the howto that I followed.. mysqladmin -u root password newpassword I had also created a database already.. however 24 hours later I cant seem to get it to work...I know it something stupid..,.,. :-)- Original Message - From: Barry Hawkins [EMAIL PROTECTED] To: Shawn Guillemette [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' (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 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] 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/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: mysql error and phpmyadmin how-to
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 [EMAIL PROTECTED] To: Shawn Guillemette [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' (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 ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] 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/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
