MySQL access problems!

gbg · 08-22-2003, 02:17 PM

I have a mysql server running at my redhat 9 box. The problem is that and dont know what hosts are allowed to access the mysql. I have root access to the machine and the root password of the mysql DB. Any ideas?

Cooner · 08-22-2003, 02:23 PM

Until other users are added by root only root has access.
mysql -u root -p

gbg · 08-22-2003, 02:42 PM

access denied for user root@localhost (using password: YES). The problem is that and don't what hosts are allowed to access the database. That way doesn't work...

Hangdog42 · 08-22-2003, 02:47 PM

Did you set up mySQL according to these instructions? A lot of people skip setting up a mysql database and you need to.

The other possibility is that root doesn't have a password set in which case you should be able to use

mysql -u root

gbg · 08-22-2003, 02:54 PM

i set up everything right... the problem is that I changed the hostname of the server and a i cannot remember.

Cooner · 08-22-2003, 03:05 PM

OK try this:
su
password
chown -R mysql /var/lib/mysql
chgrp -R mysql /var/lib/mysql

gbg · 08-22-2003, 03:11 PM

duh?! The owner and the group are already mysql. That never solve my problem. I have permissions, don't have are the allowed hosts to access the mysql database. By default the mysql server installs 2 db, the mysql and test. On mysql db you have a table user, on user you have several fields, user, host and many previleges. I dont know are the user/host combination. GRRR

Hangdog42 · 08-22-2003, 03:13 PM

Hmm. You might try mysql -u root@olddomainname -p and see if that gets you in (I doubt it though).

You also might try resetting the root password. The procedure is here .

Also, take a read through this .

Cooner · 08-22-2003, 03:20 PM

Sorry every time I have installed MySQL and got it running (about 30 or so) /var/lib/mysql were owned by root and it needed to be changed to even start the server.
It is running right? mysqladmin -p ping

gbg · 08-22-2003, 03:34 PM

yep... this last one worked fine. Thanx all and hangdog!

gbg · 08-22-2003, 03:38 PM

sorry, not the last, the previous one.