<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
On 06/04/2012 06:44 AM, Hamish wrote:
<blockquote
cite="mid:1338781446.76951.YahooMailClassic@web110012.mail.gq1.yahoo.com"
type="cite">
<pre wrap="">install_mysql.sh failed:
[...]
mysql start/running, process 20960
Setting up mysql-server (5.5.22-0ubuntu1) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
.. MySQL admin name is <debian-sys-maint>. (see /etc/mysql/debian.cnf)
ERROR 1045 (28000) at line 3: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
Finished: ./install_mysql.sh
</pre>
</blockquote>
<br>
After some playing around, this seems to work:<br>
<br>
echo "<br>
REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost';<br>
DROP USER 'user'@'localhost';<br>
CREATE USER 'user'@'localhost' IDENTIFIED BY 'user';<br>
GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION;<br>
" | mysql -uroot -p${PASSWORD}<br>
<br>
I fall back to using the mysql 'root' user.<br>
<br>
I don't understand why, but the debian-sys-maint user seems not to
be able to GRANT privileges, even tho' that user has all the privs:<br>
<br>
user@osgeolive:~$ MYSQL_ADMIN_PW=`sudo grep -w '^password'
/etc/mysql/debian.cnf | head -n 1 | cut -f2 -d'=' | awk '{print
$1}'`<br>
user@osgeolive:~$ MYSQL_ADMIN_NM=`sudo grep -w '^user'
/etc/mysql/debian.cnf | head -n 1 | cut -f2 -d'=' | awk '{print
$1}'`<br>
user@osgeolive:~$ echo "SHOW GRANTS;" | mysql -u$MYSQL_ADMIN_NM
-p$MYSQL_ADMIN_PW<br>
Grants for debian-sys-maint@localhost<br>
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD,
SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES,
SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION
SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE,
ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO
'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD
'*B579CC99E73527DBBA44E6124E1F89046A0AF8B5' WITH GRANT OPTION<br>
<br>
And it must be something that changed since Ubuntu 11.04 since the
install_mysql.sh worked fine in OSGeo 5.5...<br>
<br>
Regards,<br>
Micha<br>
<blockquote
cite="mid:1338781446.76951.YahooMailClassic@web110012.mail.gq1.yahoo.com"
type="cite">
<pre wrap="">
Hamish
_______________________________________________
Live-demo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Live-demo@lists.osgeo.org">Live-demo@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/live-demo">http://lists.osgeo.org/mailman/listinfo/live-demo</a>
<a class="moz-txt-link-freetext" href="http://live.osgeo.org">http://live.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.osgeo.org/wiki/Live_GIS_Disc">http://wiki.osgeo.org/wiki/Live_GIS_Disc</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<p><br>
</p>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consultant, Arava Development Co.
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a></pre>
</body>
</html>