MySQL install/setup

[beemer832]

I am in the middle of setting up MythTV and am working on getting MySQl setup at this point. I have never worked with this software before so I am a bit lost.

I installed mysql using yum, packages installed, and started the service. Good so far.

These are the commands I used from here:
mysql -u root
delete from mysql.user where not (host="mythtv.localhost" and user="root");
(i edited the host= field to my hostname)
FLUSH PRIVILEGES;

SET PASSWORD FOR 'root'@'mythtv.localhost' = PASSWORD('mypass');
(again i changed the @hostname field to my hostname and set my own password)
FLUSH PRIVILEGES;

update mysql.user set user="mythdbadmin" where user="root";
FLUSH PRIVILEGES;

At this point, I am still logged into mysql. I want to test to make sure I can get back in, so I logout,
and try to log back in using:
mysql -u mythdbadmin -p
now it prompts me for the password, enter password and I get this error message:
ERROR 1045 (28000): Access denied for user 'mythdbadmin'@'localhost' (using password: YES)

So after looking at it, I realized its not setting the correct hostname. Ok, lets try to fix thatL
mysql -u mythdbadmin -p -h mythtv.localhost
prompts for me the password again, enter password, and now I get this error:
ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server

So i do some google searching and see that MySQL by default looks at the first entry in the /etc/hosts file for its hostname.
So I change the first entry to my hostname I have setup for this computer.
Save the file. Restart mysqld, try it again... same results.

I can certainly remove the package and start again but I am curious to know what I am doing wrong.

Any and all help is appreciated.

basically I want to rename the root user account to mythdbadmin and then change the host from localhost to mythtv.localhost

thanks
-josh

[beezlebubsbum]

couldn't you change the user mythdbadmin to have root privileges rather than removing root altogether?

[beemer832]

i erased and reinstalled and setup using the default localhost. It also has an interactive setup that acquired the correct hostname.
I also took your advice and kept root, and just created another privlidged user account.

Thanks
Josh

[beezlebubsbum]

woot, good to hear it all worked out for you josh!