<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Just for info and save others googling.</p>
<p>The SQL GRANT statement has changed syntax in mysql 8.</p>
<p>So statements like</p>
<p> </p>
<p>GRANT
ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "password";</p>
<p>Have to be done in two steps.</p>
<p>CREATE USER 'mythtv'@'localhost' IDENTIFIED BY 'password';</p>
<p>GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';</p>
<p>As the old syntax is all over MythTV help info expect a lot of
confused people<br>
</p>
<p><br>
</p>
<p>
<style type="text/css">p { margin-bottom: 0.21cm; background: transparent none repeat scroll 0% 0%; }a:visited { color: rgb(128, 0, 0); text-decoration: underline; }a:link { color: rgb(0, 0, 128); text-decoration: underline; }</style></p>
</body>
</html>