[rt-users] ERROR 1045: Access denied for user: 'root at localhost' (Using password: YES)

[Jerry Hsieh]

Hi,

I experienced the following error and I had try to reinstall mysql (some one
make the error goes away after reinstall, but not to me), and search the
message archive from the list but did not get any luck. On top of that, I
also have some questions:

- I run mysqladmin -u root -p it works
- in mysqladmin help, it says "Default options are read from the following
files in the given order: /etc/my.cnf /usr/local/mysql/var/my.cnf ~/.my.cnf"
but I never find any of those files.

What should I do to make the error go away? Your help is highly appreciated,
thanks.

# make install
mkdir -p //opt/rt2/bin
mkdir -p //opt/rt2/WebRT/data
mkdir -p //opt/rt2/WebRT/sessiondata
mkdir -p //opt/rt2/etc
mkdir -p //opt/rt2/lib
mkdir -p //opt/rt2/WebRT/html
mkdir -p //opt/rt2/local/WebRT/html
/usr/bin/perl   tools/initdb 'mysql' '/usr/local/mysql' 'localhost' ''
'root' 'rt2' create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql '//opt/rt2/etc/acl.mysql'
/usr/bin/perl -p -i -e " s'!!DB_TYPE!!'"mysql"'g;\
                        s'!!DB_HOST!!'"localhost"'g;\
                        s'!!DB_RT_PASS!!'""'g;\
                        s'!!DB_RT_HOST!!'"localhost"'g;\
                        s'!!DB_RT_USER!!'"rt"'g;\
                        s'!!DB_DATABASE!!'"rt2"'g;" //opt/rt2/etc/acl.mysql
bin/initacls.mysql '/usr/local/mysql' 'localhost' '' 'root' '"123456"   '
'rt2' '//opt/rt2/etc/acl.mysql'
Enter the mysql administrator's database password to create a new user for
RT
ERROR 1045: Access denied for user: 'root at localhost' (Using password: YES)
Enter the mysql administrator's database password to nondestructively reload
the database
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root at localhost' (Using password: YES)'
make: *** [acls] Error 1

-jerry