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

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

Grant access from serverHost too, to handle when `hostname` is maps to, 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 @@
 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 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@'' identified by '$password'" | /usr/bin/mysql -S $targetdir/run/mysql.sock -u root --password=$password mysql

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]