On 06/04/2012 06:44 AM, Hamish wrote:
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 After some playing around, this seems to work: echo " REVOKE ALL PRIVILEGES ON *.* FROM 'user'@'localhost'; DROP USER 'user'@'localhost'; CREATE USER 'user'@'localhost' IDENTIFIED BY 'user'; GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION; " | mysql -uroot -p${PASSWORD} I fall back to using the mysql 'root' user. 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: user@osgeolive:~$ MYSQL_ADMIN_PW=`sudo grep -w '^password' /etc/mysql/debian.cnf | head -n 1 | cut -f2 -d'=' | awk '{print $1}'` user@osgeolive:~$ MYSQL_ADMIN_NM=`sudo grep -w '^user' /etc/mysql/debian.cnf | head -n 1 | cut -f2 -d'=' | awk '{print $1}'` user@osgeolive:~$ echo "SHOW GRANTS;" | mysql -u$MYSQL_ADMIN_NM -p$MYSQL_ADMIN_PW Grants for debian-sys-maint@localhost 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 And it must be something that changed since Ubuntu 11.04 since the install_mysql.sh worked fine in OSGeo 5.5... Regards, Micha Hamish _______________________________________________ Live-demo mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/live-demo http://live.osgeo.org http://wiki.osgeo.org/wiki/Live_GIS_Disc This mail was received via Mail-SeCure System.
-- Micha Silver GIS Consultant, Arava Development Co. http://www.surfaces.co.il |
_______________________________________________ Live-demo mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/live-demo http://live.osgeo.org http://wiki.osgeo.org/wiki/Live_GIS_Disc
