MySQL

Ask questions regarding Gentoox, Gentoo and Linux in general in these forums and we'll do our best to help you!
Post Reply
deusbmx
Newbie
Posts: 9
Joined: Thu Mar 11, 2004 5:56 am

MySQL

Post by deusbmx »

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)'
nobspangle
Gentoox Guru!
Posts: 1681
Joined: Sun Sep 28, 2003 11:59 am
Location: Manchester, UK

Post by nobspangle »

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.
If you keep an open mind, will your brain fall out?
reagor
Newbie
Posts: 6
Joined: Sun Oct 23, 2005 2:50 am

day 7.....

Post by reagor »

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
WINDOWS stands for Will Install Needless Data On Whole System.
cheesyboofs
Power user
Posts: 239
Joined: Wed Jan 26, 2005 1:32 pm
Location: Luton UK
Contact:

Post by cheesyboofs »

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 XboxesImage
The needs of the many out way the needs of the few or the one ...
reagor
Newbie
Posts: 6
Joined: Sun Oct 23, 2005 2:50 am

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

Post by reagor »

it was an error associated with innobd
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.
Post Reply