r7419 - dumbhippo/trunk/super/mysql/files/scripts

[commits mugshot org]

Author: walters
Date: 2008-04-15 14:49:04 -0500 (Tue, 15 Apr 2008)
New Revision: 7419

Modified:
   dumbhippo/trunk/super/mysql/files/scripts/mysql-start.sh
Log:
Grant access from serverHost too, to handle when `hostname` is maps to
127.0.0.1, not eth0.


Modified: dumbhippo/trunk/super/mysql/files/scripts/mysql-start.sh
===================================================================
--- dumbhippo/trunk/super/mysql/files/scripts/mysql-start.sh	2008-04-11 19:42:34 UTC (rev 7418)
+++ dumbhippo/trunk/super/mysql/files/scripts/mysql-start.sh	2008-04-15 19:49:04 UTC (rev 7419)
@@ -1,6 +1,8 @@
 #!/bin/sh
 
 targetdir=@@targetdir@@
+serverHost=@@serverHost@@
+bindHost=@@bindHost@@
 
 echo "Starting MySQL..."
 
@@ -43,6 +45,8 @@
 	eval `grep 'password=' $targetdir/conf/my.cnf`
 	/usr/bin/mysqladmin -S $targetdir/run/mysql.sock -u root password $password
 	# Belt-and-suspenders; only one of these is needed on a particular host, but it all depends on what 
+	echo "grant all on *.* to root@'$bindHost' identified by '$password'" | /usr/bin/mysql -S $targetdir/run/mysql.sock -u root --password=$password mysql
+	echo "grant all on *.* to root@'$serverHost' identified by '$password'" | /usr/bin/mysql -S $targetdir/run/mysql.sock -u root --password=$password mysql
 	# reverse lookup on 127.0.0.1 gives.
 	echo "grant all on *.* to root@'$hostname' identified by '$password'" | /usr/bin/mysql -S $targetdir/run/mysql.sock -u root --password=$password mysql
 	echo "grant all on *.* to root@'127.0.0.1' identified by '$password'" | /usr/bin/mysql -S $targetdir/run/mysql.sock -u root --password=$password mysql