Changes between Version 28 and Version 29 of howto/PHP

Timestamp:

Apr 12, 2023, 3:10:44 PM (13 months ago)

Author:

cyberon-org

Comment:

--

howto/PHP

@@ -128 +128 @@
 = Step 6: Configure phpMyAdmin =
 
-Edit the phpMyAdmin configuration file at ''/opt/local/www/phpmyadmin/config.inc.php''. \\
-A sample configuration file is installed at /opt/local/www/phpmyadmin/config.sample.inc.php.
-
-Consult the documentation on your server at ''"/opt/local/www/phpmyadmin/doc/html/config.html"''
-
-NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html"'' to be accessible under "<Document Root>." This can be accomplished by
-{{{
-$ cd <Document Root>
-$ ln -s /opt/local/www/phpmyadmin/doc/html/ phpmyadmin-doc
-}}}
-and then accessing ''http://<servername>/phpmyadmin-doc/''
-
-Finally, you need to set up the `phpMyAdmin` configuration to access MySQL.
+As the final step let's configure and test `phpMyAdmin`  to access MySQL.
 
 First create the config.inc.php file:
@@ -148 +136 @@
 }}}
 
-This will create a file `config.inc.php` in the `phpMyAdmin` directory. \\
+Assuming that you have /Users/username/Sites as DocumentRoot for Apache, copy and paste `phpMyAdmin` in it :
+{{{
+$ sudo cp -R /opt/local/www/phpmyadmin/ /Users/username/Sites/phpmyadmin
+}}}
+
+In your browser open `localhost/phpmyadmin`, and you will see phpMyAdmin's inlog page. Try to login as root with the MySQL password for root.\\
+There is a fair chance you can't login and will see two pink colored squares with cryptic error codes in it. The reason for it is that mySQL uses strong encryption,\\
+that phpMyAdmin can't handle. So let's change the encryption for the user root in mySQL to a lower level:
+
+{{{
+$ mysql -u root -p
+mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'here your password for root';
+mysql> exit
+}}}
+
+ 
 Next, Edit that file, and locate the line:
 {{{
@@ -170 +173 @@
 
 To check your phpMyAdmin installation, point your browser to http://localhost/phpmyadmin and verify that phpMyAdmin loads and can access your database (by providing a username and password, depending on the authentication method you selected).
+
+Consult the documentation on your server at ''"/opt/local/www/phpmyadmin/doc/html/config.html"''
+
+NOTE: This option expects ''"/opt/local/www/phpmyadmin/doc/html"'' to be accessible under "<Document Root>." This can be accomplished by
+{{{
+$ cd <Document Root>
+$ ln -s /opt/local/www/phpmyadmin/doc/html/ phpmyadmin-doc
+}}}
+and then accessing ''http://<servername>/phpmyadmin-doc/''