<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Harry Devine wrote:
<blockquote cite="mid:26426059.1206230774932.JavaMail.root@m03"
type="cite"><!---->I can do all of those commands fine. I even
followed the suggestion of <br>
<pre wrap="">another post where I did the "drop database mythconverg" command, then
ran thru the steps in that Wiki article you sent me. All went well,
BUT, when I run mythtv-setup I'm getting the same "Host <ip> is not
allowed to connect to this MySQL server" error.
How can I completely remove all of the mysql stuff and get back to a
clean slate?
Thanks for the help,
Harry
</pre>
</blockquote>
Hi Harry,<br>
<br>
The default configuration connects to "localhost" so you must not be
connecting to localhost for your database. Do the following:<br>
<br>
mysql -uroot<br>
<br>
GRANT ALL ON mythconverg.* TO mythtv@'%' IDENTIFIED BY "mythtv";<br>
FLUSH PRIVILEGES;<br>
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@'%' IDENTIFIED
BY "mythtv";<br>
FLUSH PRIVILEGES;<br>
\q<br>
<br>
Try again.<br>
<br>
<br>
Michael<br>
<br>
</body>
</html>