ShALLaX.com Forums

Posted: **Fri Mar 19, 2004 6:46 am**

ok well ive tried everything to set up mySQL off the gentoo website but i keep getting password errors. I checked an earlier post about this and i tried everything but it kept giving me errors. ive checked forums from other sites but nothing helps ive tried changing mysql and mysqladmin passwords. i dont know if anyone has cleared this up but help would be greatly appreciated

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Posted: **Fri Mar 19, 2004 8:21 am**

I don't know why people have trouble with this, after every step it tells you what to do next.

Code: Select all

emerge mysql
mysql_install_db
/etc/init.d/mysql start
/usr/bin/mysqladmin -u root -h hostname password 'new-password'
/usr/bin/mysqladmin -u root password 'new-password'
rc-update add mysql default

That's it done, now when you login to mysql or when you type a mysqladmin command you need to put -p at the end of the command to tell mysql you want to enter a password.

Posted: **Tue Oct 25, 2005 4:57 pm**

emerge mysql
done
mysql_install_db
done
/etc/init.d/mysql start
done
/usr/bin/mysqladmin -u root -h hostname password 'new-password'
FAIL

/usr/bin/mysqladmin -u root -h 127.0.0.1 password XXXXX
/usr/bin/mysqladmin: connect to server at '127.0.0.1' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

/usr/bin/mysqladmin -u root -h 127.0.0.1 password 'XXXXX'
/usr/bin/mysqladmin: connect to server at '127.0.0.1' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

IM WAITING HERE ***********

/usr/bin/mysqladmin -u root password 'new-password'
IVE TRIED THISONE BEFOPRE AND IT WORKS FINE

rc-update add mysql default DONE

ive chanded 127.0.0.1 to:
pro, pro2, localhost, <xbox ip>,

the USE values are set as per tutorial

Code: Select all

 resolveip pro
IP address of pro is 192.168.0.118
 resolveip pro2
IP address of pro2 is 192.168.0.118
 resolveip localhost
IP address of localhost is 127.0.0.1

-------------------------------------

is there a conf file i can set the passwords
or is mysqladmin the only way

i know its cause the box just doesnt like me...any suggestions
edit:

NOOB MISTAKE
1. DIDNT READ EVERYTHING SOMEWHAT RELATED (PHP NUKE POST)
2. -p
3. /usr/bin/mysqladmin -u root -h 127.0.0.1 password XXXXX -p
password: <some password i somehow set in the past i guess>
4. sorry to bother hope this helps others

Posted: **Tue Oct 25, 2005 9:09 pm**

I had this error once, the Deamon had locked up I just rebooted and restarted /etc/init.d/mysql start and all was good again...

Posted: **Thu Oct 27, 2005 2:45 am**

it was an error associated with innobd
either i had to give
chmod 777 /tmp/
or
#skip-innodb
in /etc/mysql/my.cnf

ShALLaX.com Forums

MySQL

MySQL

day 7.....

now how do i glue my hair back in???