[NTLUG:Discuss] MySQL install issues

[Stephen Davidson]

Greetings.

I am attempting to set up Bugzilla.  Requires either MySQL or PostGres
SQL.  So, installed MySQL.  Possibly a mistake.  Once installed, I can't
change the password, or otherwise log in!  (For development purposes,
attempting to change the password to 'mysql'.  I checked (in another
window) after the install completed.  MySQL is definately running.  I
just can't login.  Any suggestions????


-Steve

<===Begin Session===>

gorky:~ # rpm -Uvh
/home/steve/public_html/Downloads/MySQL/5.0/MySQL-server-5.0.45-0.glibc23.i386.rpm
/home/steve/public_html/Downloads/MySQL/5.0/MySQL-shared-5.0.45-0.glibc23.i386.rpm
Preparing...                ###########################################
[100%]
   1:MySQL-shared           ###########################################
[ 50%]
   2:MySQL-server           ###########################################
[100%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h gorky password 'new-password'
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting MySQL.....                                                   done
Thank you for installing the MySQL Community Server! For Production
systems, we recommend MySQL Enterprise, which contains enterprise-ready
software, intelligent advisory services, and full production support with
scheduled service packs and more.  Visit www.mysql.com/enterprise for more
information.
gorky:~ # /usr/bin/mysqladmin -u root password 'mysql'
-bash: /usr/bin/mysqladmin: No such file or directory
gorky:~ # mysql -u root password 'mysql'
mysql_convert_table_format  mysql_secure_installation   mysqlbug
            mysqldumpslow
mysql_explain_log           mysql_setpermission         mysqld
            mysqlhotcopy
mysql_fix_extensions        mysql_tzinfo_to_sql         mysqld-debug
            mysqlmanager
mysql_fix_privilege_tables  mysql_upgrade               mysqld_multi
            mysqltest
mysql_install_db            mysql_zap                   mysqld_safe
gorky:~ # rpm -Uvh
/home/steve/public_html/Downloads/MySQL/5.0/MySQL-client-5.0.45-0.glibc23.i386.rpm
Preparing...                ###########################################
[100%]
   1:MySQL-client           ###########################################
[100%]
gorky:~ # mysqladmin -u root password 'mysql'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
gorky:~ # su - mysql
mysql at gorky:~>  mysqladmin -u root password 'mysql'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
mysql at gorky:~>
mysql at gorky:~>
mysql at gorky:~> mysqladmin -u mysql password 'mysql'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'mysql'@'localhost' (using password: NO)'
mysql at gorky:~> exit
logout
gorky:~ # mysqladmin -u root password mysql
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
gorky:~ #