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)'
MySQL
-
- Gentoox Guru!
- Posts: 1681
- Joined: Sun Sep 28, 2003 11:59 am
- Location: Manchester, UK
I don't know why people have trouble with this, after every step it tells you what to do next.
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.
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
If you keep an open mind, will your brain fall out?
day 7.....
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
-------------------------------------
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
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
WINDOWS stands for Will Install Needless Data On Whole System.
-
- Power user
- Posts: 239
- Joined: Wed Jan 26, 2005 1:32 pm
- Location: Luton UK
- Contact:
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...
Go fully native, it's the destiny of all Mk1 Xboxes
The needs of the many out way the needs of the few or the one ...
The needs of the many out way the needs of the few or the one ...
now how do i glue my hair back in???
it was an error associated with innobd
either i had to give
chmod 777 /tmp/
or
#skip-innodb
in /etc/mysql/my.cnf
either i had to give
chmod 777 /tmp/
or
#skip-innodb
in /etc/mysql/my.cnf
WINDOWS stands for Will Install Needless Data On Whole System.