5.0-Nano: Known Issues: Difference between revisions

5.0-Nano: Known Issues (view source)

1,225 bytes added , 28 March 2010

m

1,478

edits

@@ Line 344: / Line 344: @@
 $tabs['synchronize']['text'] = $strSynchronize;
 </pre>
+'''''[[#top | Top]]'''''
+== MySQL root password (host 127.0.0.1) ==
+Versions affected, all Mona and Nano series.
+'''''Note'':''' Version 5.6.2-Nano Updated
+=== Problem ===
+When changing MySQL root password “localhost” is correctly updated however host “127.0.0.1” remains unchanged. This is undesirable and should be rectified straight away.
+=== Solution ===
+Solution is to download the latest version of Uniform Server. However this may be inconvenient. Existing installation are easily upgradeable as follows:
+A] Edit file: UniServer\home\admin\www\'''mqsetup.php'''
+Locate this code:
+<pre>
+// Create query string (not sure if you need to flush privs)
+$query = 'SET PASSWORD FOR \'root\'@\'localhost\' = PASSWORD(\'' . $nwpass . '\')';
+$result = mysql_query($query);
+</pre>
+Just below it add the following code:
+<pre>
+// Create query string
+$query = 'SET PASSWORD FOR \'root\'@\'127.0.0.1\' = PASSWORD(\'' . $nwpass . '\')';
+$result = mysql_query($query);
+$query = "FLUSH PRIVILEGES";
+$result = mysql_query($query);
+</pre>
+B] Start servers
+C] From Unitray run restore MySQL password (root name and password both restored to root)
+D] From Apanel set a new MySQL root password or use the one you previously set.
 '''''[[#top | Top]]'''''