mysql problems!!!!!!!

timvor · n00b Joined: 14 Aug 2003 Posts: 7 Location: South Africa

hi all , been following the virtual mailhosting guide but got stuck with the mysql install.

done the following
# emerge mysql

# ebuild /var/db/pkg/dev-db/mysql-4.0.13-r3/mysql-4.0.13-r3.ebuild config

#cd /var/lib/mysql
#chown -R mysql:root mysql

#/usr/bin/mysql_install_db
which completed succesfully and started fine

1st problem
/usr/bin/mysqladmin -u root -h mymachine password pass
fails with 'Host mymachine.mydomain.com is not allowed to connect to this mysql server

this has never worked , but perhaps i had different error 1st time

2nd problem
/usr/bin/mysqladmin -u root password pass
This accepted once only

# /etc/init.d/mysql start
# mysqladmin -u root -p create mailsql
# mysql -u root -p mailsql < genericmailsql.sql

# mysql -u root -p mysql
mysql> GRANT SELECT,INSERT,UPDATE,DELETE
-> ON mailsql.*
-> TO mailsql@localhost
-> IDENTIFIED BY '$password';

-> quit

from now on i cant get any thing except
Enter password:
/usr/bin/mysqladmin: connect to localhost failed
error "\'access denied for user: root@localhost Using password yes

how do i undo this mess to a clean state to try this again, or reset the password, as it seems the password i am entering is not correct

I have solved just about every other problem I experienced by searching the forums so thanks to all who contribute

_________________
tongue tied and twisted , just another GUI bound misfit I

mglauche · Posted: Tue Sep 16, 2003 2:24 pm Post subject:

the brute force method: remove everything in /var/lib/mysql/mysql/, and rerun the config script (mysql_install_db) - but beware, this might serious break existing mysql data ! so only use it on new installations

timvor · n00b Joined: 14 Aug 2003 Posts: 7 Location: South Africa

am trying that now , thanks
_________________
tongue tied and twisted , just another GUI bound misfit I

elliotte · n00b Joined: 05 Sep 2003 Posts: 27

I am having similar problems after my first mysql install. Did your fix work?

dain-bramage · n00b Joined: 11 Jul 2003 Posts: 25

Having same problem here, anyone know how to fix this?

mterlouw · n00b Joined: 17 Feb 2004 Posts: 32

I had the same problem. The guide isn't so great about holding your hand at every step it seems. When you first run mysql_install_db, it generates the following output:

mterlouw · n00b Joined: 17 Feb 2004 Posts: 32

Ok, I just tried it and it appears to have worked. Just type those two commands from the last post to set the password. I don't know if they both are needed, but I did them both just in case. I had to add -p for the second command because after the first command the root password was in effect.

Also, when doing this step:

sputicus · n00b Joined: 03 Mar 2004 Posts: 10

Thanks, the substitution for '$password' was the hint I needed to get out of this exact same problem.

Not being a mysql expert, I assumed that '$password' meant something to the mysql engine. The assumption that the reader would understand the "put your password here" subtext mislead me for at least an hour.

amigabill · n00b Joined: 05 May 2003 Posts: 59

I'm havnig problems with this as well.

sklettke · Guru Joined: 05 Nov 2002 Posts: 352 Location: Madison, WI

bocacorazon · n00b Joined: 07 May 2004 Posts: 31

I also have a domain name that doesn't exist...

It does not recognize the (local) host.

Should I create an entry on the /etc/hosts file with the machine's address?
I would not like to do that since it gets the address via DHCP

Mr_Maniac · Guru Joined: 10 Jun 2004 Posts: 546

Hmm.. Try to add the user with:

Herring42

https://forums.gentoo.org/viewtopic.php?p=1314755#1314755

Basically:
Ensure that bind-address is commented out in /etc/mysql/my.cnf.
MySql is compiled without Tcp Wrappers support.