Já vi diversos links aqui sobre o mysql.
Ao fazer:
# mysql_install_db
# service mysqld start
/usr/bin/mysqladmin -u root password 'new-password'
ou
/usr/bin/mysqladmin -u root -h spyderlinux password 'new-password'
Seria dessa forma:
/usr/bin/mysqladmin -u root password 'senha.mysql'
Log-Mysql
110107 00:27:14 mysqld started
110107 0:27:14 InnoDB: Started; log sequence number 0 43655
110107 0:27:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
A mysqld process already exists at Fri Jan 7 01:03:49 UTC 2011
erro ao dar o comando para gerar sua senha
# /usr/bin/mysqladmin -u root password 'senhaqualquer'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Como conseguir fazer tudo novamente?
Estou usando o centos 5.5 x86_64
my.cnf
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid