[NTLUG:Discuss] MySQL install issues

[Stuart Johnston]

You must add the -p switch in order to enter a password.

Stephen Davidson wrote:
> 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:~ #
> 
> 
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss